| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Help with text function
I am trying to copy a sheet to a different workbook and then rename the
sheet by adding a date from cell B3. I have seen the text() function below used to get the date from a cell and convert it to text. When I try what is shown below I get variable not defined. Only part of the macro is shown. Cell B3 is formatted as Date. What am I doing wrong? Sheets("SET UP").Select Sheets("SET UP").Copy Befo=Workbooks("Archives.xls").Sheets(1) Sheets("SET UP").Select Sheets("SET UP").Name = "SET UP " & Text(B3, "dd - mm - yyyy") Thanks, Albert |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| using a conditional suffix in text function format syntax=text(value,format_text) | Excel Worksheet Functions | |||
| Can Text Function change output text color? | Excel Discussion (Misc queries) | |||
| Advanced text function (combining text) | Excel Worksheet Functions | |||
| Using Concatenate function to generate text in Text Box | Charts and Charting in Excel | |||
| Macro or Function to make text size to suite text Length? | Excel Discussion (Misc queries) | |||
Threaded Mode
