View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
davemorrison
 
Posts: n/a
Default using If statement to change values in a range

yes that will work, I believe we are dealing with a newbee,
if I were you I would go with arrow's suggestion
just out of curiosity, why are you using R1C1 references??