Help with with pasting into multiple workbooks in a directory.

**chumbawamba** · 08-22-2018, 02:27 PM

So, I need to paste a formula from Book1 into cells V21:V26 of several workbooks. (they all have same formatting and are in the same folder)

this is what I have so far. I made sure that what is to be pasted is already on the clipboard. I cannot get it to work. What is your advice?

Please Login or Register  to view this content.

**shg** · 08-22-2018, 04:00 PM

Untested:

Please Login or Register  to view this content.

**chumbawamba** · 08-23-2018, 02:38 PM

thank you for your help

**shg** · 08-23-2018, 04:28 PM

You're welcome.

Help with with pasting into multiple workbooks in a directory.

LinkBack

Thread Tools

Rate This Thread

Display

Help with with pasting into multiple workbooks in a directory.

Re: Help with with pasting into multiple workbooks in a directory.

Re: Help with with pasting into multiple workbooks in a directory.

Re: Help with with pasting into multiple workbooks in a directory.

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Protecting multiple workbooks in a directory - Automation

VBA for multiple workbooks in a directory

Open multiple workbooks in directory, copy a range to them for data collection

Sort first column of multiple workbooks from a single directory

VBA for emailing sheet 1 of multiple workbooks from a directory that i can select

Copying range into multiple workbooks in a directory

header onto multiple workbooks in same directory

Bookmarks

Bookmarks

Posting Permissions