[SOLVED] I have a row number defined in a variable (FHRow1) and I want to use that row number to offset from the active cell. I am using the following:
ActiveCell.Offset(-FHRow1,0).Select and it does not work. What is the correct syntax for what I am trying to do?
Thanks!
Last edited by bbatterman; 08-05-2013 at 03:38 PM. Reason: [SOLVED]
Means you are selecting a row above the active cell. If the active cell is A1, you will get a syntax error as there is no cell above A1.
Please Login or Register to view this content.
Post the code. Remember to use [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE]
Ben Van Johnson
The active cell is, say A35. The variable value for FHRow1 is 7. I am trying to get the code to offset to A28 using ActiveCell.Offset(-7,0).Select where the "7" is brought in with the variable FHRow1.
Please Login or Register to view this content.
That did it! Thank you.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks