Replace filename with variable in "Activecell.FormulaR1C1=" expression

**pommyb** · 02-27-2009, 05:07 AM

I am new to Excel VBA so excuse me if I am asking a silly question. I have recorded a macro which contains several lines of code like this one:

Please Login or Register  to view this content.

I would like to replace the filename "OCR 14-02-09.xls" with a variable. I have tried several different combos of brackets and quotes but always get an error message. Is this possible?

Thanks
pommyb

**DonkeyOte** · 02-27-2009, 06:09 AM

pommyb,

first please edit your last post and adjust your closing CODE tag to [*/CODE*] without asterisks

to then answer your Q

Please Login or Register  to view this content.

Though this formula doesn't make much sense given you're referencing a 2 column range D38:E38 ... you should be looking to "do" something with it... SUM / COUNT etc...

**pommyb** · 03-04-2009, 02:17 AM

Donkeyote,

Thanks, your solution worked just fine. With regard to your last comment, I recorded that part of the macro.

Regards

pommyb

**Tomkat** · 11-05-2010, 03:49 PM

Does anyone know why THIS DOESN'T work?

Please Login or Register  to view this content.

I just want the filename (closed file) that it counts cells from to be a variable... why is this so difficult?

**daddylonglegs** · 11-05-2010, 04:04 PM

Your post does not comply with Rule 2 of our Forum RULES. Don't post a question in the thread of another member -- start your own thread. If you feel it's particularly relevant, provide a link to the other thread.