View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Matthew Pfluger Matthew Pfluger is offline
external usenet poster
 
Posts: 130
Default Referring to merged columns in range object

I would like to set the Style property of columns 3 & 4 of a range. These
columns are merged, and I can't figure out how to refer to that range. Right
now, I'm using

Range("tblTasks").Columns(3).Style = "Calculated Value"

This gives me a Run-time error '450', "Wrong number of arguments of invalid
property assignment". However, if I change the style reference to "Currency"
or change the Columns(3) to Columns(2), it works.

Can someone tell me what I'm doing wrong? Thanks,
Matthew Pfluger