RockandGrohl
Well-known Member
- Joined
- Aug 1, 2018
- Messages
- 788
- Office Version
- 2010
- Platform
- Windows
Hi all,
We all know the traditional "Do until cells(activecell.row, "A").value = "" "
Meaning, stop when the first blank row is reached.
I'm trying to loop through a range of columns, offsetting every 11 columns, and I want to stop when either the active cell is blank or the column reaches DD
I'm really rusty with VBA at the moment and I can't remember how to do anything, so I'd like to avoid anything more complex for the moment.
I would expect the following to work:
Instead I get a type mismatch. Any ideas? Thanks.
We all know the traditional "Do until cells(activecell.row, "A").value = "" "
Meaning, stop when the first blank row is reached.
I'm trying to loop through a range of columns, offsetting every 11 columns, and I want to stop when either the active cell is blank or the column reaches DD
I'm really rusty with VBA at the moment and I can't remember how to do anything, so I'd like to avoid anything more complex for the moment.
I would expect the following to work:
VBA Code:
Do until activecell.value = "" or activecell.column = "DD"
--doing stuff here--
activecell.offset(0,11).activate
Loop
Instead I get a type mismatch. Any ideas? Thanks.