find date and select columns C,D,E in row

[Burt_100]

Is it possible to have a macro which finds the date in sheet1 column a compared to sheet 2 A2 and select the columns C,D & E in that row so that I can paste data?

[JOHN H. DAVIS]

Maybe:

Please Login or Register  to view this content.

[walruseggman]

This selects the cells C:E in the found date column. But for what it's worth, you rarely if ever need to select a range. You can just copy and paste it in the code without needing to select it.

Please Login or Register  to view this content.