Macro question

[Abhinav Shori]

I started recording a macro. A simple macro to copy and paste from a different worksheet using vlookup.

I had an active cell once I started the macro then I put the vlookup formula in. The formula is being put in along the row (so only column is changing). I stop recording my macro and it works fine but when I change the active cell to some other cell and run the macro, only the active cell gets a result and the macro jumps back to the original place (where I recorded it) and keeps processing.

Is there a way for a macro to advance right along the row depending on the active cell??

thanks in advance

 

[Nebu]

Can you upload a sample file , it will be way easier for someone to help u out with a sample file...

 

[Hui]

The macro recorder records the actual address of the cells not necessarily the movements when recording macro's

Can you try the following
Open the Developer Tab
If you can't see it Right click on the Ribbon, Customise the Ribbon
Add the Developer Tab to the Main Tabs window

On the Developer tab
Click on the Use Relative References
Record your macro again
Ensure that you finish with a move to the next cell to the right movement

Beyond that please post the file here with details of what you are trying to achieve

 

[Abhinav Shori]

Thanks Hui,
I guess that is what I wanted to know. It worked