Problem:
A1: 1 B1: 2 C1: (empty) D1: 3 E1: 4
After solution is applied:
A1: 1 B1: 2 C1: 3 D1: 4
Problem:
A1: 1 B1: 2 C1: (empty) D1: 3 E1: 4
After solution is applied:
A1: 1 B1: 2 C1: 3 D1: 4
Please click on * Add Reputation if my solution was useful, thanks
Please Login or Register to view this content.
If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
Mark your thread as Solved
If the suggestion helps you, then Click *below to Add Reputation
What about
Please Login or Register to view this content.
- Battle without fear gives no glory - Just try
This code worked on the first few attempts but then failed when for example A1 to FF1 are not empty but every cell to the right of this range is empty:
Set rBlank = Rows("1:1").SpecialCells(xlCellTypeBlanks)
Run time error 1004: No cells were found
Please Login or Register to view this content.
Entia non sunt multiplicanda sine necessitate
See another one
Please Login or Register to view this content.
Last edited by PCI; 03-13-2018 at 06:44 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks