Forum Discussion
mtthomasm516
Oct 30, 2023Copper Contributor
Count Black Cells In a Range Using VBA
I am trying to count blank cells in a range using VBA. Below is an abbreviated version of my code. The full macro contains more, but I figured all that is irrelevant at this point since it chokes o...
- Oct 31, 2023
mtthomasm516
Oct 31, 2023Copper Contributor
Once upon a time I was incredibly good with Excel VBA, but that was way back in the Excel 4 days! Haven't done a lot of it since then, but still, I should have seen that! Current_Tasks is a named range in the worksheet. I guess I was just thinking that the macro would somehow know that!
HansVogelaar
Oct 31, 2023MVP