Hi
I am trying to copy a formula down from my TopRow to my BottomRow in a column on a worksheet that is formulas that reference two columns on another spreadsheets.
How do I get the bottom section of the code to write formula all the way down to the bottom row without going cell by cell.
Thank you for your help!
Please Login or Register to view this content.
ORPlease Login or Register to view this content.
Please Login or Register to view this content.
Last edited by AB33; 03-16-2022 at 04:17 PM.
Thank you but neither one of those does what I need it to.
attached is a file that shows what I need. Capital entries tab has names in column Q and R and DIU tab shows exactly how they should be laid out
Thank you for your assistance!!
[/CODE]Please Login or Register to view this content.
Last edited by AB33; 03-18-2022 at 08:18 AM.
Hi
Every time I try to run it I get
Out of Memory error at
ReDim w(1 To UBound(x) * UBound(x), 1 To 2)
Even with everything closed. Tried to trouble shoot myself and got no where.
Any thoughts
Thanks
Hi, try this !
According to your attachment a VBA demonstration for starters :
PHP Code:Sub Demo1()
Dim V, R&
With ['Capital Entries'!Q1].CurrentRegion.Rows
With .Item("2:" & .Count).Cells
ReDim V(1 To .Count, 0)
For R = 1 To .Count: V(R, 0) = "=" & .Item(R).Address(, , , True): Next
[DIU!AB2].Resize(.Count).Formula = V
End With
End With
End Sub
► Do you like it ? ► ► So thanks to click on bottom left star icon « ★ Add Reputation » ! ◄ ◄
Last edited by Marc L; 03-17-2022 at 09:38 PM. Reason: optimization …
Sorry! I was away for the last two days.
My code was wrong anyway as you have asked for a formula. Marc has now given the solution you are after.
Thank you both!! appreciate your help!!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks