Hi All,
I have a list in excel with a fixed amount of rows (8 till about 1000) and each row has a variable amount of columns.
Within each row sometimes, the value is empty.
I need to write a VBA script to only show me the rows that contain cells with empty values between column C and the last column of each row with a value.
In below picture for example you can see these lines in red.
Line 3 has D3 empty
Line 6 has E6 empty
line 10 had G10 empty
line 13 has H13 empty
The green lines can be hided
I managed to find last row with values and I'm able to find last column in a row with a value but somehow I can't tie it together.
All help is appreciated.
Thanks in advance.
Wim
I have a list in excel with a fixed amount of rows (8 till about 1000) and each row has a variable amount of columns.
Within each row sometimes, the value is empty.
I need to write a VBA script to only show me the rows that contain cells with empty values between column C and the last column of each row with a value.
In below picture for example you can see these lines in red.
Line 3 has D3 empty
Line 6 has E6 empty
line 10 had G10 empty
line 13 has H13 empty
The green lines can be hided
I managed to find last row with values and I'm able to find last column in a row with a value but somehow I can't tie it together.
All help is appreciated.
Thanks in advance.
Wim