Refresh a worksheet

[LoriD]

Is there a way to refresh a page so that I can use Alt+End to go the last cell with data.

Whe I do this, it brings me to the last cell that previously had data in it, before I made some deletions.

I want to go to the last cell in my new range, and am assuming I need to refresh the page or the range somehow.

[Anne Troy]

Unfortunately, it s not quite like that.

If you re deleted the data from cells, you should use Edit-Delete. AND THEN SAVE THE FILE.

Deleting by using the delete key removes the cell contents only; not the formatting! Excel will select cells that have formatting even if they are empty.

Does it help you to know that bit of info, Lori? Or do you still need help with it?



~Dreamboat
TheWordExpert

Edited by - Dreamboat on May 09 2002 13:11:48

[LoriD]

Not exactly what I was looking for. Let me try something else. Is there a way, through VB code, to just move to the cell on the right, without naming the cell?
When I try this through the macro recorder, it always calls the cell I selected. For example C10 . So if I have data through row 30, it still only goes to C10.

[smozgur]

Hi LoriD,

Basically use the code below for Sheet1.

Sheet1.UsedRange.Dirty

:)

Regards

Oz

[LoriD]

Well, that sounds easy enough, but I don t know where to put it.

[smozgur]

LoriD,

Actually it should be Ctrl+End instead Alt+End if i understood you.

Could you please delete some rows in range in Sheet1 then goto VBA and activate immediate window (Ctrl+G) then execute this code by pasting it there and hitting enter.

Sheet1.UsedRange.Dirty

Then go back to sheet1 and check if it is like you need.

Hmm, where? You created a macro by Macro Recorder?? Ok, just goto that module to edit it and add the line above at the bottom of the code:

Opening macro for editing:

Tools_Macro_Macros..(Select Macro Name)..Edit
or
Alt+F8..(Select Macro Name)..Edit

Helped?





Oz

[LoriD]

Thankyou!!!

Lori

[smozgur]

Anytime you need

:)

Oz