btsboarder
New Member
- Joined
- Jun 28, 2013
- Messages
- 9
Hi All,
I am trying to have my VBA code grab all the information in the relevant range, but not pick up any empty lines, i.e stop when there is no more information. This is the code I have right now.
Set rng = Nothing
Set rng = Range("B5:H31").SpecialCells(xlCellTypeVisible)
So say my information only goes to row 20, I don't want it to continue until row 31. I have it set up to paste the information into an email, so I want to cut down on white noise.
Thanks!
I am trying to have my VBA code grab all the information in the relevant range, but not pick up any empty lines, i.e stop when there is no more information. This is the code I have right now.
Set rng = Nothing
Set rng = Range("B5:H31").SpecialCells(xlCellTypeVisible)
So say my information only goes to row 20, I don't want it to continue until row 31. I have it set up to paste the information into an email, so I want to cut down on white noise.
Thanks!