AutoFill with Cells

[Forestq]

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.....

 

[sheetspread]

Does:

selection.value = ws2.cells(13,s).value work?

(or vice versa?)

 

[Forestq]

I'm affraid no, but I resolved my problem in other way,

thanks!