-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
destination cells
-
J
VBA AutoFill formula to adjacent cells
I have a report that returns a variable amount of rows depending on the number of transactions returned. I have my cursor located in the last occupied cell in Col. "F", which contains an AutoSum formula. This formula needs to be copied to the next 5 cells to the right (along with the...- jerryneubauer
- Thread
- adjacent cell fill autofill autosum destination cells vba
- Replies: 4
- Forum: Excel Questions
-
F
AutoFill with Cells
Hi, I want to use AutoFill function. In destination value I start in point E13 but END values is dynamically counted, so I can't use Range-> Range("E13:E" &....). Selection.AutoFill Destination:=ws2.Cells(13, s), Type:=xlFillDefault My autofill destination is like: E13:AA13, or E13:CC13.....- Forestq
- Thread
- autofil cells autofill autofill range autofill range auto fill destination cells
- Replies: 2
- Forum: Excel Questions
-
A
VBA - Setting a paste destination range relative to Active Cell
Hi ... I'm new to this forum - thanks in advance for taking the time to help me with this ... I'm creating a Macro to paste a series of formulas from a template in hidden rows above to cells further down in the same worksheet. My code works fine if I set an absolute range as the Destination -...- AnnR27
- Thread
- activecell reference destination cells excel 2007 vba
- Replies: 3
- Forum: Excel Questions
