VBA: Change content of each sheet in an workbook

[bongus]

Hello.

I am new to this forum and hope for a little help.

I have searched the forum have, to my surprise, not found anything quite similar to my request. Perhaps it is too obvious?

For every sheet in a workbook, I would like to replace cell contents. It is always the same for each sheet and the structure of each sheets is the same.


I tried some permutations of the following syntax but to no avail.

Please Login or Register  to view this content.

Now there are two questions:
1. What should I use to replace the ..... ?
2. How do I specify a formula (where formula I want in C5 could be "=if($C$1="OK"; A5+B5; 0)" ?
Edit: Figured the second one out.

Extra bonus: How to do this for all workbooks in a directory or in the current directory.

Optionally: If it is simpler, it is OK to copy a range from a template and paste into all sheets.

Best regards

[rvasquez]

Hello there, try the following:

Please Login or Register  to view this content.

[bongus]

Thanks a lot.

I'll see if anyone attacks the bonus question before changing status to solved.

[rvasquez]

Hello there,

Try this one, you'll need to change the red highlighted text to your filepath for the folder that contains the files you wish to loop through:

Please Login or Register  to view this content.

Code compliments of:
http://stackoverflow.com/questions/5...d-pulling-data

[bongus]

Thanks a million. It works.

Noe I will sort out how to get ALL the operations in the loop to work in this context. I will not bother you with that, though.

Best regards
/Henrik Målberg