Can VBA Code the Blank Spaces in a Column
Closed
bikercowboy
Posts
2
Registration date
Monday October 26, 2009
Status
Member
Last seen
October 28, 2009
-
Oct 27, 2009 at 03:27 PM
bikercowboy Posts 2 Registration date Monday October 26, 2009 Status Member Last seen October 28, 2009 - Oct 28, 2009 at 09:13 AM
bikercowboy Posts 2 Registration date Monday October 26, 2009 Status Member Last seen October 28, 2009 - Oct 28, 2009 at 09:13 AM
Related:
- Can VBA Code the Blank Spaces in a Column
- Samsung keypad reset code - Guide
- Battery reset code - Guide
- Samsung volume increase code - Guide
- How to get whatsapp verification code online - Guide
- Twitter spaces on desktop - Guide
2 responses
venkat1926
Posts
1863
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
811
Oct 27, 2009 at 10:19 PM
Oct 27, 2009 at 10:19 PM
autofilter for blankd and the visible cells do the function and remove autofitler.
bikercowboy
Posts
2
Registration date
Monday October 26, 2009
Status
Member
Last seen
October 28, 2009
Oct 28, 2009 at 09:13 AM
Oct 28, 2009 at 09:13 AM
That would work if I was placing the same formula in each blank cell
but the formula changes
=PERSONAL.XLS!Concat1(A18:A20," ") in one blank cell, the next one is
=PERSONAL.XLS!Concat1(A22:A185," ")
The formula includes all the nonblank cells since the last
but the formula changes
=PERSONAL.XLS!Concat1(A18:A20," ") in one blank cell, the next one is
=PERSONAL.XLS!Concat1(A22:A185," ")
The formula includes all the nonblank cells since the last
