ExcelBanter - VBA Copy & Paste

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - VBA Copy & Paste (https://www.excelbanter.com/excel-discussion-misc-queries/110845-vba-copy-paste.html)

Bob Barnes

VBA Copy & Paste

I have a Column in Excel 2003 that is automated within
Access to Excel.

It places a date in Row 1 - IE, 9/15/06.

There are 240 dates in the columns to the right.

How do I "find" the column to the far right of the
"Automated receiving column", and copy the
"Automated receiving column" to the column
having the matching date on the far right??

TIA - Bob

All times are GMT +1. The time now is 01:17 AM.