Autofill using variables

  • Thread starter Thread starter Deecrypt
  • Start date Start date
D

Deecrypt

Hi,
Please tell me what is wrong with the below statements. I'm positive
that it is a trivial error but I cant seem to figure this out. This
code works fine if I use absolute cells references i.e "D1:D7" rather
than pasteMonthStart, & pasteMonthEnd.

ActiveCell.Offset(0, 3).Select
ActiveCell.FormulaR1C1 = "=TEXT(RC[-3],""mmmmmmmmm_yyyy"")"
Range(pasteStart).Select
Selection.AutoFill Destination:=Range("pasteMonthStart, &
pasteMonthEnd")


Thank you kindly
Deecrypt
 
Try:

Selection.AutoFill Destination:=Range(pasteMonthStart, pasteMonthEnd)

Mike F
 
Thanx for your prompt reply Mike,
I tried your solution but was unsuccessful. Eventually found the below
solution so am displaying that for the benefit of all.

Range(pasteMonthStart).Select
Selection.AutoFill Destination:=Range(pasteMonthStart & ":" &
pasteMonthEnd)

Thank you
Deecrypt

Mike said:
Try:

Selection.AutoFill Destination:=Range(pasteMonthStart, pasteMonthEnd)

Mike F

Deecrypt said:
Hi,
Please tell me what is wrong with the below statements. I'm positive
that it is a trivial error but I cant seem to figure this out. This
code works fine if I use absolute cells references i.e "D1:D7" rather
than pasteMonthStart, & pasteMonthEnd.

ActiveCell.Offset(0, 3).Select
ActiveCell.FormulaR1C1 = "=TEXT(RC[-3],""mmmmmmmmm_yyyy"")"
Range(pasteStart).Select
Selection.AutoFill Destination:=Range("pasteMonthStart, &
pasteMonthEnd")


Thank you kindly
Deecrypt
Click to expand...
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

autofill down until reach variable range 3
Autofill with Column as a variable 5
macro to copy rows that contain a cell with a certain number 2
Autofill Error 4
File Name changes with dates and Deleting Rows of Zeros 0
Macro that deletes and pastes filterd rows and then some 2
Using the AUTOFILL Function 2
Macro should Save and Overwrite file 1

Back
Top