I have a set of data in a spread sheet that is linked to Pivot table. After I select different criteria from Pivot table, sometimes it will give me random blanks between data rows. I am having trouble to write a macro so that it will delete those random blanks automatically. Any help will be greatly appreciated.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
VB excell macro
- Thread starter wz75025
- Start date
![[glasses]](/data/assets/smilies/glasses.gif "[glasses] [glasses]")
[red][/red]![[tongue]](/data/assets/smilies/tongue.gif "[tongue] [tongue]")
- Status
Similar threads
- Locked
- Question
- Locked
- Helpful tip
- Locked
- Question
- Locked
- Question