Syntax error on formula that works in spreadsheet

		Microsoft Office Forums > Microsoft Excel > Excel Programming
Syntax error on formula that works in spreadsheet

11-02-2016, 06:49 PM

macropod

Windows 7 64bit Syntax error on formula that works in spreadsheet

Office 2010 32bit

Administrator

Join Date: Dec 2010

Location: Canberra, Australia

Posts: 22,467

Try using ActiveSheet.Range("al10").Value

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Formula works on most cells	gbaker	Excel	1	04-26-2014 12:31 AM
Error handling in formula - suppress 'Syntax Error'	Cosmo	Word	7	02-24-2014 07:08 AM
Using multiple formulas in one (IF, AND and SUM) gives syntax error	markdeniet	Word	1	02-05-2014 05:17 AM
Syntax to use OFFSET() in a cell formula?	dlowrey	Excel	3	07-09-2013 09:15 AM
Why it works but the macro is error in VB?	tinfanide	Excel Programming	5	12-03-2011 12:53 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 01:41 PM.