LinkBack URL
About LinkBacks
Hi,
Can you try this instead :
y = ThisWorkbook.Sheets("Data").Cells(ThisWorkbook.Sheets("Data").Rows.Count, 1).End(xlUp).Row + 1 '<-------- For this line i keep getting runtime error '9', subscript out of range
Hi,
Can you try this instead :
y = ThisWorkbook.Sheets("Data").Cells(ThisWorkbook.Sheets("Data").Rows.Count, 1).End(xlUp).Row + 1 '<-------- For this line i keep getting runtime error '9', subscript out of range
GC Excel
If this post helps, then click the star icon (*) in the bottom left-hand corner of my post to Add reputation.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks