I imagine that you have some code you are building and need this for a specific reason. It is generally not a good idea to use the Activecell, or use Select for anything - which the Macro Recorder will give you tons of that type of code. It is quite inefficient. Try posting your entire code for a possible better solution. Don't forget to include a good written description of what it is that you are trying to accomplish along with the desired results.
Here's my full code below. Basically what I am doing is having the macro find a specific font etc, then move the data in that cell down and to the left one cell (already done). The thing is, I need to repeat that task on average bout 150 times, so I am wanting to build the code so it will select a cell below the one that I just moved to avoid moving it again. Hope that's a little clearer!!
Ohh, I couldn't get the first string of code to work.
' MoveSupervisor Macro
' Macro recorded 1/26/2005 by TCollin6
I have a list of supervisor and their employees all in one column (raw data given to me like this). the only thing that identifies the supervisors is that they are in bold and green. I've got that piece figured out on how to search and find them, the only problem is when I repeat the macro, it moves the same name unless a cell below it has been selected before the macro is run again. So that what I really need to make sure happens. I have to run this macro many many times (i basically set-up a shortcut key and hold id down for a couple minutes).