hi, i have this code but every time it says compile error, could you please help many thanks
Code:
Range("A25").Select
Selection.End(xlUp).Select
selection.Offset(1, 0)
Printable View
hi, i have this code but every time it says compile error, could you please help many thanks
Code:
Range("A25").Select
Selection.End(xlUp).Select
selection.Offset(1, 0)
Code:
'Using your code
Range("A25 ").Select
Selection.End(xlUp).Select
Selection.Offset(1, 0).Select
'Same but neater
Range("A25 ").Select
Selection.End(xlUp).Offset(1,0).Select
'I use message boxes frequently as I build unfamiliar code
'This might be overkill here but shows exactly where cursor is going etc
'Message boxes can tell you a huge amount
Range("A25 ").Select
MsgBox "1 Now at " & ActiveCell.Address
Selection.End(xlUp).Select
MsgBox "2 Now at " & ActiveCell.Address
Selection.Offset(1, 0).Select
MsgBox "3 Now at " & ActiveCell.Address
Thanks so much Yongle it was really helpful :)
Re: Same but neater????
Selecting however should not be required but we need to see the rest of the code.Code:Range("A25").End(xlUp).Offset(1).Select