Permanently Paste the Formula in First row
And use this :
Sub A()
Dim wksSHeet As Worksheet
Dim rngFill As Range
Set wksSHeet = Sheet1
Set rngFill = wksSHeet.Range("rngStart").CurrentRegion
Set rngFill = Intersect(rngFill, rngFill.Offset(1, 9))
rngFill.FillDown
End Sub
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of chandra sekaran
Sent: Dec/Sat/2011 05:49
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Large Data Formula Take More time
Hi Sir,
Here with attahced Large data file i have wrriten macro but i feel
it will take more time is not professional manner can have a look and
modify my macro
1. Formula also copy past only i used after that i used calculation
also
Pl. help sir
Regards
chandra sekaran.
--
FORUM RULES (934+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please
Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will
not get quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security
measure.
4) Acknowledge the responses you receive, good or bad.
5) Cross-promotion of, or links to, forums competitive to this forum in
signatures are prohibited.
NOTE : Don't ever post personal or confidential data in a workbook. Forum
owners and members are not responsible for any loss.
----------------------------------------------------------------------------
--------------------------
To post to this group, send email to excel-macros@googlegroups.com
--
FORUM RULES (934+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Cross-promotion of, or links to, forums competitive to this forum in
signatures are prohibited.
NOTE : Don't ever post personal or confidential data in a workbook. Forum
owners and members are not responsible for any loss.
------------------------------------------------------------------------------------------------------
To post to this group, send email to excel-macros@googlegroups.com
