| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Concatenate error and Date Format Error
Any ideas on the 'date' issue I am having??
"Jim Cone" wrote: Question 2. This uses two methods to add sufficient quotation marks. Chr$(34) is used for the variables and a double set of quotes is used around the word "to". It is just to illustrate, one method is not necessarily any better than the other... ActiveCell.FormulaR1C1 = "=CONCATENATE(" & Chr$(34) & newName1 & _ Chr$(34) & ",""to""," & Chr$(34) & newName2 & Chr$(34) & ")" -- Jim Cone San Francisco, USA http://www.realezsites.com/bus/primitivesoftware "Coal Miner" wrote in message I posted a question a few days ago but had no answer. Soooo, I tired to create this macro myself (i am not a programmer nor do i pretend to be one). The macro runs through but I have the following problems: 1) The filter is not working properly. I am trying to filter for data between the beginning and ending dates. I am getting no data. Guessing a formatting problem? 2) My concatenate idea is not working. Simply returning #name? Here is my code (as I said, I am no expert but just a simple person trying to make these easier) - trimmed- 'THIS IS PROBLEM #2' ActiveCell.FormulaR1C1 = "=CONCATENATE(newname1,""to"",newname2)" |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| date format error in cell | Excel Worksheet Functions | |||
| Date format error | Excel Discussion (Misc queries) | |||
| Date-error Format | Setting up and Configuration of Excel | |||
| Date format error in Excel | Excel Worksheet Functions | |||
| Date Format - April error | Excel Discussion (Misc queries) | |||
Hybrid Mode
