autofill range

I currently have this: Dim lastrow As Long Dim lastcol As Long Sheets("Template").Select Range("v13").Select lastrow = Range("S" & Rows.Count).End(xlUp).Row lastcol = Range(11, Columns.Count).End(xlToLeft).Column Range("V13").Formula = "FORMULA HERE" Range("V13").AutoFill...

Hey guys. I have one more for the experts. I'm trying to create a macro that will find a location, input an equation, and autofill that equation to the bottom of the existing data. I tried recording the macro and using the double click feature, but when I was done, it didn't create a variable to...

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

Below is the code i have that works for me with no problems at the moment, the green comments are a description of what the macro should be doing the red text is the code which needs revising AND the blue text is what i am trying to achieve rather than the red text If you need anymore...

Hey, so I'm trying to use the AutoFill with Cells command an I am having trouble. Here is my code Range("L2").Select ActiveCell.FormulaR1C1 = "=(DATEVALUE(RC[-1]))" Selection.NumberFormat = "m/d/yyyy" Selection.AutoFill Destination:=Range(Cells(2, 12), Cells(lastRow2, 12))...

Hi there - I hope someone can help. I have a very limited knowledge of VB with an intermediate knowledge of formulas and am using Excel 2011 for Mac. I wish to create a spreadsheet that will enable me to lookup which electricity distribution network companies operate in specific regions in the...