Thread: How to add a blank line within an exporting sub?
View Single Post
 
Old 02-13-2013, 06:22 AM
OTPM OTPM is offline Windows 7 32bit Office 2010 32bit
Expert
  
Join Date: Apr 2011
Location: West Midlands
Posts: 981
OTPM is on a distinguished road
Default
Hi
Can you not just change your data range to include a blank row. For example if Q8 sits on a blank row you could include that row in your range. I am not a VBA expert but just thought I would make a suggestion.
Tony
Reply With Quote