I have the following macro but I am having trouble with one piece of it,
The code is
' PMTimetable Macro
If MsgBox(Prompt:="Have you filtered on PM Timetable?", Buttons:=vbYesNo + vbQuestion, _
Title:="Insert PM Timetable") = vbNo Then
Application.CutCopyMode = False
What i would like is for it to look for the next blank row and insert there instead of it being inserted into Row 10 everytime. EG - - Rows("10:10").Select
How do I do this?