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!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Problem with TransferText
May be a dumb idea, but try calling the table "ORDER". It might be that access is in some way thinking that ...S" means the "S" is a delimiter. At worst, it'll be one more idea eliminated!- SallyPDS
- Post #5
- Forum: VBA Visual Basic for Applications (Microsoft)
-
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...- SallyPDS
- Thread
- Replies: 1
- Forum: VBA Visual Basic for Applications (Microsoft)
