Hello I am writing a line of code as part of a more complex program that is not working correctly.
Essentially I am prompting the user to select a cell which is then assigned the variable celNm.
I then perform the following actions
celNm.EntireRow.Copy
celNm.EntireRow.Insert
Next, for reasons specific to the program (and I am assuming the celNm will be located at the same cell after the command) is 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:
celNm.Offset(-1, 0).Select
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?
Essentially I am prompting the user to select a cell which is then assigned the variable celNm.
I then perform the following actions
celNm.EntireRow.Copy
celNm.EntireRow.Insert
Next, for reasons specific to the program (and I am assuming the celNm will be located at the same cell after the command) is 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:
celNm.Offset(-1, 0).Select
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?
