Jack-P-Winner
Member
How can I fix this error in my Macro? Or do I need to upload the whole Macro?
Set rCel = rSeq.End(xlDown).Offset(1)
Set rCel = rSeq.End(xlDown).Offset(1)
error in Macro I need to fix "Set rCel = rSeq.End(xlDown).Offset(1)"
- Thread starter Jack-P-Winner
- Start date
NARAYANK991
Excel Ninja
Hi ,
You need to see how the range rSeq is defined i.e. what is its address range.
If your rSeq is the last row of a range of data , and you execute the End(xlDown) part of your statement , you will be reaching the last row of the worksheet ; executing Offset(1) on this will generate an error.
Narayan
You need to see how the range rSeq is defined i.e. what is its address range.
If your rSeq is the last row of a range of data , and you execute the End(xlDown) part of your statement , you will be reaching the last row of the worksheet ; executing Offset(1) on this will generate an error.
Narayan
Jack-P-Winner
Member
Got it thanks guys!!! Don't forget me sir//// (-:
