Previous Topic Next Topic

Excel macro help!!

Closed
Michael - Jan 22, 2009 at 11:44 AM
Tweedledum Posts 181 Registration date Monday January 19, 2009 Status Member Last seen April 2, 2009 - Jan 23, 2009 at 05:55 AM
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.
Related:

1 response

Answer 1 / 1
Tweedledum Posts 181 Registration date Monday January 19, 2009 Status Member Last seen April 2, 2009 125
Jan 23, 2009 at 05:55 AM
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

Similar discussions

How to calculate positions (1st,2nd,3rd...) in Excel
hardy -
TrowaD -

6 responses
Date formatting in dd/mm/yyyy
nisha -
appu -

11 responses