View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
George[_3_] George[_3_] is offline
external usenet poster
 
Posts: 14
Default 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