Hello all,
How do I set special range in the below vba. Currently the range is set to entire column B.
How do I set the range to be column B but the row should begin from first data cell after blank cell availabe at the top direction from
the active row and til the first blank cell at the bottom direction from the same active row.
To explain if my current active row is 10 and column B5 to B15 are all data cells but B4 and B16 are blank cells , then
I want the range to be B5 to B15. And if my active row of the same sheet is 20 and B17 to B30 are all data cells,
except B16 like before is blank and so is B31, hence my range this time should be B17 to B30.
How do I achieve this please??
Will appreciate a lot and thanks.
How do I set special range in the below vba. Currently the range is set to entire column B.
VBA Code:
Set Fnd = Range("B:B").Find("b*", , xlValues, xlWhole, , , False, False)
How do I set the range to be column B but the row should begin from first data cell after blank cell availabe at the top direction from
the active row and til the first blank cell at the bottom direction from the same active row.
To explain if my current active row is 10 and column B5 to B15 are all data cells but B4 and B16 are blank cells , then
I want the range to be B5 to B15. And if my active row of the same sheet is 20 and B17 to B30 are all data cells,
except B16 like before is blank and so is B31, hence my range this time should be B17 to B30.
How do I achieve this please??
Will appreciate a lot and thanks.
Last edited: