Forum Discussion

Copper Contributor

Feb 02, 2023

Solved

Set range in VBA as the last non blank cell

I am trying to make my VBA code more flexible. I am trying to create a combination of all cells for a column set Columns A through E are the input and Columns H and J show all combinations ...

excel

Macros and VBA

HansVogelaar
Feb 02, 2023
arajagopal4

Use

Set AISLE = Range(Range("B2"), Range("B1").End(xlDown))

HansVogelaar

MVP

Feb 02, 2023

arajagopal4

Use

Set AISLE = Range(Range("B2"), Range("B1").End(xlDown))

arajagopal4
Copper Contributor
Feb 03, 2023
Awesome. Thanks Hans!