variable referencing

  1. B

    Compile a variable for setting and examination Excel 2010 VBA

    I'm sorry I couldn't get HTMLMAKER to work. I hope it is ok to post my code like this. I'm using Excel 2010. This is a short and sweet version of my program. Is there a way to compile the variable in blue below without having to write code for each variable i.e. machine101, machine102, etc...
  2. E

    Referencing Variables in Formulas

    Hey guys can someone give me an extensive lesson on how to reference Just Rows, Just Columns or Cell objects in a FormulaR1C1 Formula. I Really need help with it, and I hope to display it in traditional "A1" format Here is an example 'Type Ref in C8 of a blank work book 'and type random...
  3. J

    Variable Referencing problem

    Hi everyone: I am using the vba code below to input a formula into excel cells. However, I want to make the "A:A" and the "D3" in the formula relative to the variable c2 (which is an integer). Does anyone know how to do this? Cells(3, 3).Offset(0, c2) = "=IF(COUNTIF(" & "A:A" & "," & "D3" &...

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 MrExcel.com.
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 "mrexcel.com".
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
Top