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

MsgBox Range("range1").Columns.Count

"George" wrote:

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

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

On Mon, 30 Apr 2007 08:56:03 -0700, Toppers
wrote:


MsgBox Range("range1").Columns.Count

Thanks. G

"George" wrote:

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