Cell Focus

[vestax22]

Hi,

I have an excel 2000 application. At the end of a macro execution I would like to select a cell. I tried this code :

with worksheets("Billing&quot

.activate
.range("A1&quot.select

end with

the problem is that the screen doesn't seem to update to the new location. Any ideas?

Thx

 

[SQLBI]

Does it select cell A1 and not adjust the screen scroll or does it do nothing?

Try

Sheets("Billing).Activate
ActiveSheet.Cells(1, 1).Select


Leigh Moore
LJM Analysis Ltd

http://www.ljm-analysis.co.uk

 

[Bowers74]

Or try:

with worksheets("Billing&quot

.Select
.range("A1&quot.select

end with



Peace!

Mike

Never say Never!!!
Nothing is impossible!!!

 

[SkipVought]

Hi,

Do you have ScreenUpdating turned off?

Application.ScreenUpdating = True
then select cell

Skip,
Skip@TheOfficeExperts.com

http://www.TheOfficeExperts.com