LinkBack URL
About LinkBacks
fluffyvampirekitten 
Could anyone help me look at my Index Match function vba code
I got an error 1004
Range("S2").FormulaR1C1 = "= INDEX([PatientMerge.xls]2015!C10,1)Match(RC[-16][PatientMerge.xls]2015!,C10,0))"
Could anyone help me look at my Index Match function vba code
I got an error 1004
Range("S2").FormulaR1C1 = "= INDEX([PatientMerge.xls]2015!C10,1)Match(RC[-16][PatientMerge.xls]2015!,C10,0))"
Maybe this :
Range("S2").FormulaR1C1 = "= INDEX([PatientMerge.xls]2015!C10,1)Match([PatientMerge.xls]2015!RC[-16],C10,0))"
if it does not work, type your formula in a cell, then go in the VBA Editor, open the Immediate Window (CTRL+G) and type: ? Activecell.FormulaR1C1
GC Excel
If this post helps, then click the star icon (*) in the bottom left-hand corner of my post to Add reputation.
Originally Posted by GC Excel
I got
Run-Time error '1004':
Application-defined or object-defined error
The macro recorder is gold for making formulas in VBA.
<----- If you were helped by my posts you can say "Thank you" by clicking the star symbol down to the left
If the problem is solved, finish of the thread by clicking SOLVED under Thread Tools
I don't wish to leave you with no answer, yet I sometimes miss posts. If you feel I forgot you, remind me with a PM or just bump the thread.
I did use macro recorder but still i got the same error
and is there anyway i can record IndexMatch formula ?
Cos I can only see Index formula or Match Formula , it wasnt together
Last edited by fluffyvampirekitten; 07-10-2015 at 05:04 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks