1. I

    FormulaR1C1 + Error 1004

    Hi, I have written some code that looks for column headings to locate the columns of data required in my formula, thus returning a column number. So logically the best method of creating my formula in the cell is to use the FormulaR1C1 function in vba, however I have been unsuccessful in getting...
  2. J

    Beginner Struggles with VBA

    I am trying to utlize the recording feature to learn about the code that controls excel via taking an action and then reviewing the code that is recorded. Recently I was able to get the following code to work: Sheets("GEN INCENTIVE").Select Range("AV1").Select Columns("AV:AV").Select...
  3. M

    Offset "Application.Match" result to find destination cell

    I'll try to be as brief as possible. Here's the rundown. Setup: I have 2 Workbooks. I'm trying to loop through Workbook#1 and for every cell that contains a blue border, I then want to search for that cell value on Workbook 2 (a result SHOULD always be present). Once the result is found, I...
  4. G

    VBA Select range using Find method and variables

    Hi All, I have a set of values in Column A of a worksheet named "Data". Cell A1 has the value as "Description" Cell A9 is blank Cell A10 has the value as "Team Total" The current active cell is D100 I would like to use the VBA "Cells.Find(What:="Description" statement to get to A1 from...
  5. A

    VBA .xlam for multiple workbooks

    Good morning, I have several tools working with which include sometimes the same Subs . So everytime I found an effort on one Sub and change it in one workbook I repeat this in the other workbooks. Wasting time - isn’t it? I want to have one workbook with all Subs inside, soft coded. So they...
  6. M

    Best Way to Clean Up After Running Code

    Curious about the best way to clean-up after running code. I often run code that utilizes Workbook, Worksheet, Range, ADODB.Connection and ADODB.Recordset variables, sometimes all in the same procedure. At the end of the code I set all variables equal to nothing (e.g., Set dbConn = Nothing)...
  7. M

    Userform to modify data in different workbooks

    Hey guys, Hope everyone is doing great. At my current job we use several workbooks to store data regarding different steps of a process. Tehe thing is that some data is the same through the different workbooks. I have been working on a vba app that would allow me to store the data needed on all...
  8. Q

    Table Lookup

    I'm trying to create a look-up formula that fills in cell values in accordance with corresponding variables from different tabs. For example: In the tab "Match-Up", cell "J3", I'd like the formula to display the number of games "Auburn" has played (according to the data found in tab "Auburn")...
  9. D

    Finding approximate value based on interpolation of data

    Hello, I need help with this problem of finding the closest result based on 3 criteria. Using index and match I get the result but only if the result value and the variables are exact match. These are the measurements that I get from device: Variable_1 - B2=59.3 Variable_2 - B3=31.3 Variable_3...
  10. S

    Pass value between two user forms - but txt box and form name held as public variables

    Hi all, I need to pass a value from a text box (frmkeypad.tbvalue.value) to another text box in another userform. But the form name and text box name to pass it to are stored as public variables (formref and fieldref). So something like formref & "." & fieldref & ".value" =...
  11. B

    Loop through variables which defined as range

    Hello, how can I loop through ranges. What I have already tried so far. Is it possible? Dim Variabel as Range Dim Variabel_1 as Range Dim Variabel_2 as Range Dim Variabel_3 as Range Dim I as Long ' the ranges are as an example Set Variabel_1 = Range("A1") Set Variabel_2 = Range("B5") Set...
  12. G

    Online scoreboard

    I wish to create a scoreboard for pool matches on a live stream as an overlay image. I was thinking of using an external button box to change the variables within an excel file which then in turn changes said variables on my overlay. The variables I would require would be: Player 1 name...
  13. VBE313

    How can I select the next item and next item and next item?

    Private Sub CommandButton1_Click() For I = 0 To Me.ListBox4.ListCount - 1 If InStr(UCase(ListBox4.List(I, 1)), UCase(sFind)) > 0 Then Me.ListBox4.TopIndex = I + 1 Me.ListBox4.ListIndex = I + 1 Exit For End If Next I End Sub...
  14. H

    Return multiple variables from a Function

    I am relatively new to programming. I am trying to return multiple variables from function. I have read a couple of posts that outline that this is not possible. They suggest that this can be solved by passing a array. I understand how to do this, however what if one of the variables is an...
  15. B

    Easy VBA Loop Through Variables Looking for Boolean Flag

    Hi All, I'm attempting to write a code that looks through a potential of 50 different Boolean variables and creates a new variable "YES" if at least one is flagged yes. I am extremely new to VBA and just know basic loops. Any help would be appreciated. Thank!
  16. O

    relationship among four variables

    How can i get the relationship among this 4 variables a = no of days = 30 b = rates/number of holes/ma = 315.81 c = expected monthly target (number of holes) = 240 d = expected production amount = 75,795.36 (Naira) regards
  17. O

    Dividing Variable Ranges or Strings

    I am trying to get a range to divide itself by itself divided by a different range, and then multiplied by 12. I wrong the code below in an attempt to achieve this, and keep getting an error stating "Compile error: Object required". I have tried changing the "AnnualizeMonths" and...
  18. R

    Outlier detection and removal from ranges

    Good day, I have a two ranges (for X and Y data) that I graph on a userform using the traditional method of graphing, exporting to image, and loading the image into a picture control. Oftentimes, the data in the Y data has a few errors in terms of outliers (X data is just dates). I'd like to...
  19. D

    Excel Solver Question

    Hello- I am stuck on Excel Solver question. I have 4 decision variables used to determine thresholds for items to stock in warehouse. From a list of of all items, by changing these variables in any combination, I can identify new opportunities to generate incremental revenue. I have a binary...
  20. C

    RE: Expressing Application.onTime("00:00:10") as a variable...

    RE: Expressing Application.onTime("00:00:10") as a variable... I just want to be able to vary the time to display a MsgBox using a variable from a cell value on a sheet using Application.onTime("h:m:s"), where h, m and t are variables In the title, a variable evaluates to 10 seconds. Would...

Watch MrExcel Video

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back