RUN TIME ERROR "1004"

[JOBZ]

Guys any one could help me solving this problem:

ActiveCell.Offset(1, 0).Range("A1").Select

as I try to save data to transfer it to yearly attendance record it giving me this error.

 

[Alex Blakenburg]

Given your screenshot, I am guessing your active cell is on the last row of the sheet ie row 1048576 and offset 1 is taking you off the page.

 

[JOBZ]

Guys any one could help me solving this problem:

ActiveCell.Offset(1, 0).Range("A1").Select

as I try to save data to transfer it to yearly attendance record it giving me this error.

 

[JOBZ]

Given your screenshot, I am guessing your active cell is on the last row of the sheet ie row 1048576 and offset 1 is taking you off the page.

thank you for reply hope can you kindly help me what I need to edit on this formula?

 

[Alex Blakenburg]

Replace the previous 2 line with this line.
ie Range("B6").Select and Selection.End(xlDown).Select

Range("B" & Rows.Count).End(Xlup).Select

 

[JOBZ]

Replace the previous 2 line with this line.
ie Range("B6").Select and Selection.End(xlDown).Select

Range("B" & Rows.Count).End(Xlup).Select

Thank you so much now it works ok.

 

[Alex Blakenburg]

You're welcome. Glad I could help.