finding the first available cell in the column to paste a value into

[Pat_The_Bat]

Trying to create a range variable that will be the next available cell in the column (after the last used cell in that column, or just below the last used cell in that column)
When I step through the code, I get an error on the line of code that begins "Set LSTROW= ....."

Can anyone help me get un-stuck on this?



Sub LSTROW()


Dim LSTROW As Range


Set LSTROW = Worksheets("Doc Checklist").Range("C2").End(xlDown).Row + 1










With Sheets("Doc Request").Range("B17:B100").SpecialCells(xlConstants)
.Offset(, -1).Copy LSTROW
'The line above this needs to reference range = the next available cell in the column C
End With
On Error Resume Next
Sheets("Doc Checklist").Range("C2:C100").SpecialCells(xlBlanks).EntireRow.Delete
On Error GoTo 0








End Sub

 

[Pat_The_Bat]

You're welcome.

Since you are going to start a new thread I won't write a solution here. However both points are quite easy to do.

Trying to follow proper board etiquette! Dying to know your thoughts though. If you feel compelled...

https://www.mrexcel.com/forum/excel-questions/1065341-once-added-list-dont-add-again.html

 

[nardagus]

Ok. Fluff closed your thread cause of double posting. So either we discuss it here, or move there:

https://www.mrexcel.com/forum/excel...st-creating-duplicates-final-output-list.html

After all I think we stick here as new point are still a part of the same project.

So.

1) You don't want to double copy the data already copied. Would some helper column be ok? You could place some mark in it. Then macro would check this column and skip rows with a mark. What do you think?

2) We need to do another macro for clearing "Doc Checklist" worksheet.

 

[Fluff]

@nardagus
As the Op has asked a new question and a new post has been started please continue on that thread, not this one.
Thanks