|12 Jul 2011||#1|
| || |
EXCEL VBA 2007 Macro: Offsetting cell form a user defined selection
I am writing a line of code as part of a more complex program that is not working correctly. I am new to VBA so please bear with me...
Essentially, I am prompting the user to select a cell which is then assigned to the variable 'celNm'.
I then perform the following actions:
Next, for reasons specific to the program (and I am assuming the celNm will be located at the same cell after the command [Not the same location]), I want to move the cell selection upwards, so it is now located at the row just recently copied above. I am using the following line to do this:
This, however, does not work.
The next step in the program would be to create a list in this location. However the program still creates a list at the previous location (in the cell selected). Why is this?
|My System Specs|| |
|Similar help and support threads for: EXCEL VBA 2007 Macro: Offsetting cell form a user defined selection|
|Excel Macro||Microsoft Office|
|Excel 2010 Multiply cell||Microsoft Office|
|Excel 2007 Home and Studentl: calculation results in blank cell||Microsoft Office|
|Excel 2003 Macro Help?||Microsoft Office|
|uac crashes excel macro||Microsoft Office|