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)

"George" wrote in message
...
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