| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
using a macro to move a function into excel cell
Hi
Double all single " so they read "" and it should work. HTH. Best wishes Harald "Deb" skrev i melding ... The function works in Excel. But, when VB encounters the first quote, it thinks the rest is a comment. I renamed the spreadsheets to have a one-level name so that I could remove the single quotes, but it still didn't work. Help!! Worksheets("Reformatted Data").Range("D1").Formula = "=INDEX(INDIRECT("'Downloaded Data'!$A$1:$H$"&'Start Here'!$E$11),MATCH(I3,INDIRECT("'Downloaded Data'!$I$1:$I$"&'Start Here'!$E$11),0),4)" |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| macro to move to another cell | New Users to Excel | |||
| Macro to move one cell down | Excel Worksheet Functions | |||
| Function to move to a given cell | Excel Worksheet Functions | |||
| How to write macro to move object via if function | Excel Discussion (Misc queries) | |||
| Macro to move to next cell | Excel Programming | |||
Threaded Mode
