Excel macro help!!

[Closed]
Report
-
Posts
181
Registration date
Monday January 19, 2009
Status
Member
Last seen
April 2, 2009
-
Hello,

I'm having trouble with a Macro. Obviously..haha

Anyways, What I'm Trying to do is copy a value from one spreadsheet, find it in another spreadsheet, then copy another cell in the same row, then copy that cell and paste it back in the original spreadsheet.

Does someone know how to write the code for that? When I try to record the macro, it only does the specific cell and the selection that I have copied. Please help. I'm not exactly too VBA advanced.

1 reply

Posts
181
Registration date
Monday January 19, 2009
Status
Member
Last seen
April 2, 2009
124
You can record the macro and just change the code ActiveSheet.Range("G5").CurrentRegion.Select
Selection.Copy



.current region will copy everything surrounding G5 for instance. That any help?
1
Thank you

A few words of thanks would be greatly appreciated. Add comment

CCM 2942 users have said thank you to us this month