![]() |
#7
|
|||
|
|||
![]()
You could edit NoSparks macro like below ... so long as the term END will always be three rows under the last data entry.
Code:
Option Explicit Sub Dave_T() Dim lr As Long, i As Long lr = Cells(Rows.Count, "A").End(xlUp).Row For i = lr To 1 Step -3 If Cells(i, "A") = "" Then Cells(i, "A").Select Exit For End If Next i End Sub |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
![]() |
Alex1s85 | Mail Merge | 4 | 01-18-2020 11:30 PM |
Leaving a Blank Field Blank | migman | Mail Merge | 10 | 08-29-2017 03:28 AM |
![]() |
mbesspiata | Excel | 1 | 01-17-2015 05:02 AM |
Page numberring 1 - blank - 2 - blank etc | Intern | PowerPoint | 0 | 09-02-2011 01:16 AM |
![]() |
sieler | Word | 3 | 04-12-2009 01:38 PM |