Thread: [Solved] Excel vba to check to check if two columns are empty
View Single Post
 
Old 07-09-2015, 04:45 PM
macropod's Avatar
macropod macropod is offline Windows 7 64bit Office 2010 32bit
Administrator
  
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,467
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default
Basically, all the macro does is to compare the count of empty cells in columns A & B for the rows selected against twice the number of rows. Quite simple, really. A slightly different approach is required once you're past the last used row on the workbook, but in that case one can safely assume columns A & B are empty.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote