Returning to initial cell after macro runs

[blk]

Hi,

This is probably easy, but I can't work it out.

I have a macro that while running, it is necessary to select cells, due to paste special values.

How can I get excel to remember what cell or range was active at the start of the macro, and then return to the same cell or range at the end.

Thanks


Ben

 

[jimboy]

Try this;

Dim mysheet
Dim mycell
mysheet = ActiveSheet.Name
mycell = ActiveCell.Address

'your code here

Sheets(mysheet).Range(mycell).Select

 

[tusharm]

There are very few reasons to 'go' places in a macro. PasteSpecial is not one of them. See the code I posted in your other discussion on how to convert all values in a range to upper case. That code did not 'go' anywhere to accomplish the task.

For more on how to eliminate 'activate's and 'select's, check the Excel | VBA | 'Beyond Excel's recorder' page of my web site.

Hi,

This is probably easy, but I can't work it out.

I have a macro that while running, it is necessary to select cells, due to paste special values.

How can I get excel to remember what cell or range was active at the start of the macro, and then return to the same cell or range at the end.

Thanks


Ben

 

[blk]

Thanks. Works great!!