VBA: find number of columns in named range?

  • Thread starter Thread starter George
  • Start date Start date
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
 
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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Range Name Use 4
FInding the largest number in a range meeting a criteria 4
INDEX return multiple columns 1
Creating a loop 1
Concatenate array problem. 1
Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
Search a named range 1
Macro needs updated Range name addresses 3

Back
Top