Posted to microsoft.public.excel.programming

José Ignacio Bella José Ignacio Bella is offline

external usenet poster

Posts: 7

SpecialCells(xlLastCell)

Hello Group, I have a problem with a macro, and maybe you can help me

I use a sentence 'ActiveCell.SpecialCells(xlLastCell).Select' to go to the
last worksheet cell.
The problemis when this cell has been erased. Then it's not really the last
cell, but Excel still points to this one.
Saving, closing and re-opening, then Excel points to the real last cell.

Do you know how to refresh the xlLastCell without closing the book?
Thanks in advance.

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Cntrl + End (xlLastCell)	Bill	Excel Discussion (Misc queries)	2	January 22nd 05 03:56 AM
xllastcell vs xlcelltypelastcell	Paul Lautman	Excel Programming	3	August 10th 04 02:42 PM
xlLastCell question	Rich[_16_]	Excel Programming	1	December 1st 03 08:35 AM
.SpecialCells(xlLastCell).Select	jim c.	Excel Programming	3	October 3rd 03 04:02 PM
XP VBA: Range("A2", ActiveCell.SpecialCells(xlLastCell)).Select	wessman	Excel Programming	2	July 23rd 03 06:33 PM

All times are GMT +1. The time now is 05:33 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us