| 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)" |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
using a macro to move a function into excel cell
Double all single " so they read "" and it should work.
Only internal instances, and not the first and last... HTH, Bernie MS Excel MVP |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
using a macro to move a function into excel cell
"Bernie Deitrick" <deitbe @ consumer dot org skrev i melding
... Double all single " so they read "" and it should work. Only internal instances, and not the first and last... Roger last. First is not quoted in the initial posting. Double the first that's in the posting. <g Best wsishes Harald |
| Reply |
| 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 | |||
Hybrid Mode
