Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
In my worksheet I have a calculation (count of records). I want the macro to
send by cursor / cell reference that many rows down in the spreadsheet. However, I want to do this in a blank row, so "Selection.End(xlDown).Select" doesnt work. Can someone help be simply move my cursor to that location? (Yes, I'm an amateur). Example: I have data in A2 through B50 Cell A1 = count(A2:b50)...this calculates 98. I want the cell reference to move to C98. I'm beyond ignorant, and don't know how to program that into my macro. Any help would be appreciated. Thanks. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
indirect function to reference cell on different sheet | Excel Worksheet Functions | |||
Cell Value Updated based cell input | Excel Discussion (Misc queries) | |||
Flexible Cell Reference | Excel Discussion (Misc queries) | |||
Cell Formula reference to cell Based On third Cell Content | Excel Discussion (Misc queries) | |||
Cell Reference Math | Excel Worksheet Functions |