+2  A: 

Change ActiveCell.FormulaR1C1 to ActiveCell.Formula since you're using basic A1 notation and not R1C1.

BenV  2010-07-07 17:21:32

related questions

Win32 ShellExecute and a UNC Path
Tool to reformat xml-comments (Visual Studio 2008)
Excel - Macro to conditionally copy rows to another worksheet
Excel Macro Help
MS Word: How do I create a shortcut or toolbar button for the "Paste Special..Unformatted Text" option?
How can I find last row that contains data in the excel sheet with a macro?
How can I refresh all the pivot tables in my excel workbook with a macro?
Writing a ++ macro in Common Lisp
is there a way to write macros with a variable argument list in visual C++?
My first Lisp macro; is it leaky?
How do I save each sheet in an Excel workbook to separate CSV files with a macro?
How do I keep RecipientTime when executing MailItem.Move in an Outlook macro?
How do I assign a keyboard shortcut to a VBA macro in Outlook 2007?
Modifying a spreadsheet using a VB macro
How to disable Visual Studio macro "tip" balloon?
What are the best keyboard macros for programming in windows?
good directory picker for visual basic macros in MS Outlook (2007)
VS2008/TFS: Get Latest of solution from command line or macro
Helpful snippits?
How to enable the TRACE macro in Release mode?
How do you create a debug only function that takes a variable argument list? Like printf()
Do you have any recommended macros for Microsoft Visual Studio?
[ADO.NET] What's the deal with |Pipe-delimited| variables in connection strings?
Visual Studio 2005 Macros stop working when Visual Studio 2008 is installed
How far can LISP macros go?