autofill using vba

Hi I want a macro to when I change or add value in one cell (e.g: D5) then auto-fill the below row ( row no. 6 from column A to M) and convert the formula in above row (row no. 4 from column A to M) convert to number to decrease size of file. I recorded this macro in excel but it only work for...

Hi everyone, I am new to VGA, but I really need to get this button to work. I have a sheet with different tables. In my second table, I have 4 rows and 2 columns. The first column says 1st, 2nd, 3rd, 4th, and the second column is blank (besides having a thick border) for the user to fill in...

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

I was wondering how - if possible - I can go about using the autofill method to fill to the end of the column if the column isn't necessarily specified, but referenced. It's harder to explain than it is to see so here's what I'm working with right now. I just started using VBA a couple of...

Hi I am trying to write a code that will autofill the formula in cell B7 down to the last row in column A. This macro is run on multiple worksheets where the number of rows will change. The problem I am having is when a worksheet only has one row of data and therefore does not need the autofill...

I have a workbook that will have over 20+ tabs and I am wanting to build a macro to do an autofill to last active cell in the current column I have selected. What is the correct code? I have this currently but it doesn't work (obviously :)) The only thing consistent will be that the formulas...

Hi all, I could use a bit of help here. I have a file with a master list of data, titled "Values." In this sheet, I have specific identifying columns - Building #, Floor # and Unit. (Columns B, C and D, respectively). This sheet contains information for all units on all floors in 5 different...

Hi guys, I am trying to autofill using the following code but no luck, can someone kindly help me correct the following code, Range("B4:T4").AutoFill Destination:=Range("B4:T" & Range("T" & Rows.Count).End(xlUp).Row) All I want to select the range A4:T4 and autofill down. Thanks in...