View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Piyush[_2_] Piyush[_2_] is offline
external usenet poster
 
Posts: 2
Default Copy and past as values

Hi
I am new to vba and macros. need urgent help
In Sheet 1, I am trying to copy a cell C1 and paste as values in cell D1 and
then from C2 to D2. The function needs to progress in this fashion one by
one. I want to create a macro and still be able to run it from a different
worksheet say Sheet 2.

Kindly help

Regards
Piyush