Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: SallyPDS
  • Content: Threads
  • Order by date
  1. SallyPDS

    Quotation Marks in Excel Macro

    I am trying to write a macro to construct the formula =if(datacell="N",value1,value2) into each cell in a column as it moves down. My macro line looks like: Activecell.Offset(0,20)="=if(T"& Activecell.Row & "="N",v1,v2)" Because the formula to be inserted is within Quotation marks, it is...

Part and Inventory Search

Back
Top