Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Referencing a cell, not the value
I have the following line in some VBA: objSht.Cells(Row, "U").Formula = "=477" & "* Q" & Row & "" This line basically sets the formula for all of column U for as many rows as there are. It works great. However, suppose if I had a worksheet called "Data" and in that worksheet I had a cell lets say B1 and in that cell is the 477 figure. How can I make this dynamic? Meaning, if the user changes the 477 to 577, I want all of the formulas referencing that cell to update properly? Thanks, Brian |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Referencing a cell, not the value
Try this.
objSht.Cells(Row, "U").Formula = "=Data!$B$1" & "* Q" & Row & "" Regards, Jayant |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Referencing a cell, not the value
I'm hoping you've just been looking at it too long
objSht.Cells(Row, "U").Formula = "=" & objsht.Range("B5").value & " & "* Q" & Row & "" "BerkshireGuy" wrote: I have the following line in some VBA: objSht.Cells(Row, "U").Formula = "=477" & "* Q" & Row & "" This line basically sets the formula for all of column U for as many rows as there are. It works great. However, suppose if I had a worksheet called "Data" and in that worksheet I had a cell lets say B1 and in that cell is the 477 figure. How can I make this dynamic? Meaning, if the user changes the 477 to 577, I want all of the formulas referencing that cell to update properly? Thanks, Brian |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Referencing a cell, not the value
Awesome!
This newbie thanks you! -Brian |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Help with cell referencing. | New Users to Excel | |||
Help with cell referencing. | New Users to Excel | |||
Referencing Last Cell | Excel Worksheet Functions | |||
Referencing Cell Next To Today's Date Cell | Excel Discussion (Misc queries) | |||
cell referencing | Excel Worksheet Functions |