Hi Pawel,
Here is a short answer to what I think you want.
It is a generic solution to the key issue of copying formulas (and only
formulas) down to the next row.
Dim LastRowRange As Range
...
Set LastRowRange = ... ' Determine last row's range here
With LastRowRange.SpecialCells(xlCellTypeFormulas)
.Offset(1).FormulaR1C1 = .FormulaR1C1
End With
If you run into any difficulties, report back with your questions. Post the
code you have come up with so far at that juncture and it will be easiest
for us to assist.
Also, a non-VBA solution if you use Excel 2007 or higher, is to simply
convert your table or tables of data to actual Excel Tables. In that case,
Excel will automatically bring your formulas down when you enter data on the
next row (the feature is called "calculated columns"). Excel Tables have
other benefits for working with tabular data, too.
Asa
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of pawel lupinski
Sent: Saturday, July 14, 2012 9:38 AM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ macro with multiple rows
Hi DON,
so what I need is check if in eg cell M10 is function (not empty cell) copy
this function to column O:DO ( the same row ) and after calculation copy
range O:DO and paste as a text. and make a loop ... cell M11 ... M12 ... and
so on, if you can help me I will be appreciated.
Regards,
Pawel
From: dguillett1 <dguille...@gmail.com>
To: excel-macros@googlegroups.com
Sent: Saturday, July 14, 2012 5:24 PM
Subject: Re: $$Excel-Macros$$ macro with multiple rows
I do NOT understand your need. Give examples
if M___? is ______then copy the VALUES to col O:DO
etc
Don Guillett
Microsoft Excel Developer
SalesAid Software
dguille...@gmail.com
From: pawel lupinski <mailto:lupins...@yahoo.com>
Sent: Saturday, July 14, 2012 9:48 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ macro with multiple rows
Sorry All correct file
Hi All,
I'd like to ask you help me with writting macro, problem is I've no idea how
to do it?
In column "M" there are functions (colour in white) that need to be copied
accross rows (started from column "O"), but only these functions. When in
column "M" there is nothing macro should be checking next cell in column
"M". Macro should be copied function (from column "M") accross columns "O"
to column "DO", and after that save results as "text".
So for the future use I'd like to add additional product and macro will
doing the same for this additional items. Please if you can check and help
me in this.
Regards,
Pawel
--
FORUM RULES (986+ 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
To unsubscribe, send a blank email to
excel-macros+unsubscr...@googlegroups.com
--
FORUM RULES (986+ 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
To unsubscribe, send a blank email to
excel-macros+unsubscr...@googlegroups.com
--
FORUM RULES (986+ 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
To unsubscribe, send a blank email to
excel-macros+unsubscr...@googlegroups.com
--
FORUM RULES (986+ 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
To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com
