VBA: find number of columns in named range?
In a spreadsheet, I can use '= columns(Range1)' to get the number of
columns in Range1. I'm having trouble doing this in a VBA script.
I tried 'worksheetfunction(columns(...)), but this seems to be looking
for some sort of (row,col) args.
Thanks,
George
|