Home |
Search |
Today's Posts |
#3
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Whoa, I may be in the wrong group <g. I am just getting started on
macros and am not into VBA yet. What I had hoped to do was find a way 'go to' a specific cell in the Master sheet using a calculated value but I can't find a way to 'say' A(Contents of another cell). Is that not possible without programming? Thanks! HalB Gary Keramidas wrote: you can try something like this: dim ws as worksheet dim lastrow as long set ws = worksheets("Master") lastrow = ws.Cells(Rows.Count, "A").End(xlUp).Row ws.range("A" & lastrow +1).value = "your value" |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Circular Reference Problem Calculating Net Pay | Excel Worksheet Functions | |||
Calculating a cell reference | Excel Discussion (Misc queries) | |||
How can I remove cell reference when calculating outside of the pi | Excel Worksheet Functions | |||
problem with cell reference in =sum(offset(cell reference,x,y,z,a)). Want cell ref to be variable. | Excel Worksheet Functions | |||
Problem with =sum(offset(cell reference,w,x,y,z). I want cell reference to be variable | Excel Worksheet Functions |