How can I change this code so that it doesn't go within rows 1-4. So if the next empty cell is within rows 1-4 then it starts at 5.
Please Login or Register to view this content.
How can I change this code so that it doesn't go within rows 1-4. So if the next empty cell is within rows 1-4 then it starts at 5.
Please Login or Register to view this content.
Without seeing the rest of the code, I would try
Please Login or Register to view this content.
GC Excel
If this post helps, then click the star icon (*) in the bottom left-hand corner of my post to Add reputation.
Sorry, I forgot to include the code for NxtEmpCell. This is it:
Please Login or Register to view this content.
Then, it should work :
Please Login or Register to view this content.
That works, but I can't figure out how to change the code on the Else side to set C to start from row 6 instead. I tried adding the line nxtempcell = 6 but it wouldn't allow it.
Hello,
Maybe
but again, difficult to tell without seeing the rest of the code or your workbook.Please Login or Register to view this content.
What are you trying to do exactly?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks