VBA: find number of columns in named range?

G

George

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
 
B

Bob Phillips

range("A1:H10").Columns.Count

as an example


--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)
 
Top