-----------------------------------------------------------
New Message on MumbaiUserGroup
-----------------------------------------------------------
From: kalpesh
Message 3 in Discussion
Regarding the first question
since you are starting from q1, use following code to Autofill
Range("Q1:Q2").Select
Selection.AutoFill Destination:=Range("Q1:Q" & lastrow), Type:=xlFillDefault
Range("Q1:" & lastrow).Select
in above case, lastrow will be the row upto which you want to fill values (Assuming
you have values in Q1 & Q2)
Next thing, you want to do the same thing for formulaes
1) write the formula =c2+d2, in cell b2
and =c3+d3 in cell b3
Then
Range("b2").select
Selection.AutoFill Destination:=Range("B2:B" & lastrow), Type:=xlFillDefault
Range("b2:" & lastrow).Select
HTH
Kalpesh
-----------------------------------------------------------
To stop getting this e-mail, or change how often it arrives, go to your E-mail
Settings.
http://groups.msn.com/mumbaiusergroup/_emailsettings.msnw
Need help? If you've forgotten your password, please go to Passport Member Services.
http://groups.msn.com/_passportredir.msnw?ppmprop=help
For other questions or feedback, go to our Contact Us page.
http://groups.msn.com/contact
If you do not want to receive future e-mail from this MSN group, or if you received
this message by mistake, please click the "Remove" link below. On the pre-addressed
e-mail message that opens, simply click "Send". Your e-mail address will be deleted
from this group's mailing list.
mailto:[EMAIL PROTECTED]
