Search between a Gas Station

Run Time Error on Active formula in Excel Macro code I want to use the value of cell A5 of Sheet 2 to my active formula in macro in Sheet 1. However, I'm getting an Error 1004 (application defined or object defined error). If using a static value, for instance 100, instead of 'Sheet 2'!A5 , it is working. 'Sheet 2'!A5 Below is my code: ActiveCell.FormulaR1C1 = "=if('Sheet 2'!RC>'Sheet 2'!A5,""PASS"", ""FAIL"")" 1 Answer 1 You cannot mix-and-match xlA1 cell references with xlR1C1 cell references. A5 is R5C1 in xlR1C1 syntax. ActiveCell.FormulaR1C1 = "=if('Sheet 2'!RC>'Sheet 2'!R5C1,""PASS"", ""FAIL"")" Now in this formula, the RC is a relative row/relative column reference to the same cell on 'Sheet 2' that the active cell on the active ...

Dependent drop down list for multiple cells i want to create a Dependent drop down list in excel and i have a small doubt in it.i have one main table and one dependent table,Main table have 6 choices and in that 6 only one choice need dependent drop down list,when i create the Dependent drop down list,it work for only one cell,but the choice may repeat may times and i need to select Dependent drop down when ever the choice selected in that coloumn. I used formula for DDD list is =INDIRECT(SUBSTITUTE(B2," ","")),My doubt is how can i select B2 to B1200,and when ever my choice repeat, i need Dependent drop down list should come,Hope my Question has understandable . I Have a table shown below Booking confirmation Booking update Booking cancel Loadlist/SE File SLI Reviewed Other updates Cargo receipt On board Sailing schedule and i have Dipendent table only for Other Update 6th one in above order Vessel Rollouts Loadlist revision no update found when i select Other up...