Posted to microsoft.public.excel.programming

Lazer[_5_] Lazer[_5_] is offline

external usenet poster

Posts: 1

Copying an entire row of formulas

I did that but it kept copying over the numbers. In the end, I figure
this out:

For columnIterator = 1 To Columns("EI" & ":" & "EI").Column
If Cells(10, columnIterator).HasFormula Then
Cells(currentRow, columnIterator).FormulaR1C1
Cells(10, columnIterator).FormulaR1C1
End If
Next

Thanks!
Elieze

--
Message posted from http://www.ExcelForum.com

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Conditional copying of entire row across worksheets	Marish	New Users to Excel	1	October 10th 08 08:16 AM
Copying entire worksheets	Todd Nelson	Excel Discussion (Misc queries)	2	August 31st 05 06:50 PM
Copying an Entire row using an IF Statement	Marcus	Excel Programming	1	July 6th 04 06:31 AM
Copying an Entire row using an IF Statement	Marcus	Excel Programming	2	July 5th 04 03:19 PM
Macro for copying entire raw	Mac[_5_]	Excel Programming	3	November 13th 03 03:09 AM

All times are GMT +1. The time now is 04:46 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us