Hi All,
I am a new user to this Exceltip.Com but profiecient in Excel. I Basically work on macro's.
I got a problem in Macro just wanna to explain you the sequence:
I got to have 4 Columns , in the first Column it is "1" , 2nd column it is "3", 3rd column it is "5" & the last column is Now().
By writing a Macro i have brought the result for the 4 Columns the result will be displayed on the next column E as:
A B C D E
1 3 5 =now() 1-3-5-06/14/2008
All the activity was done on first row with using all these Columns and a macro will be recorded on the first Row and first 5 Columns only.
But i want to run the same macro in the second row also where as the macro recorded is for the first row and first 5 col's how can i use the same macro in the second row
For Eg:
A B C D E
1 3 5 =now() 1-3-5-06/14/2008
2 4 6 =now() 2-4-6-06/14/2008.
Can any one help me as it would be helpfull for my daily spread sheet updations.
Regards
Surya.
Bookmarks