Forum Discussion
bigjim1216
Jan 17, 2022Copper Contributor
selecting a range of cells starting with the ActiveCell
I am using "find" to locate the first empty cell in a column. From that "ActiveCell" I would like to clear the contents of the next 400 cells below it. I set up a for next loop but it is extremely sl...
- Jan 17, 2022
Range(ActiveCell, ActiveCell.Offset(400)).Clear
HansVogelaar
Jan 17, 2022MVP
Range(ActiveCell, ActiveCell.Offset(400)).Clear
bigjim1216
Jan 17, 2022Copper Contributor
That worked! Thanks so much for your help
Jim
Jim