active cell

[canablitz]

hi, once again i have come to a grinding halt in my project. i have recorded a very long macro, but i left the active cell flashing (as when you copy the cell) so every time i run the macro, it leaves the cell border flashing, is there a command to enter in visual basic at the end of the macro to make it deselect this cell?

please help me, as im tearing my hair out

BoB

[willlobb]

it might not seem very 'tidy' but its all i can think of for now!, try entering a value into an empty cell, then deleting it. this should get rid of it.

Range("A1").Value = "a" 'or any empty cell
Range("A1").Select ' or the cell you have entered text into
Slection.ClearContents

hope this helps, if you do find any other way, can you please post it on the board.
Will

[willlobb]

sorry, spelt selection wrong, missed the 'e'
Will

[Derek]

Hi Will

If your cell border is flashing because you have recorded a macro which copies and pastes, you need to add this line to your code after the paste expression;
Application.CutCopyMode = False
You can achieve this whilst recording a macro by pressing the Esc key on your keyboard after you have pasted.

Hope this helps

regards
Derek

[willlobb]

thanks, i always wondered what that was for!
Will