A really easy one to start the day!
I have a VBA code that creates a row, but I want to autofill from the above row, but only a certain amount of columns (currently 3 to 60). I was just going to use a simple autofill function one cell at a time, then move it as it will still be very quick, but there's got to be an easier way fo doing it, and, more importantly, I can't figure out how to autofil to a cell below the current activecell.
When I record a macro it gives a range that I'm autofilling to, ie Selection.AutoFill Destination:=Range("B7:B8"), Type:=xlFillDefault
I tried to replce the range with offset, but this doesn't work.
I'm using excell 2003.
I have a VBA code that creates a row, but I want to autofill from the above row, but only a certain amount of columns (currently 3 to 60). I was just going to use a simple autofill function one cell at a time, then move it as it will still be very quick, but there's got to be an easier way fo doing it, and, more importantly, I can't figure out how to autofil to a cell below the current activecell.
When I record a macro it gives a range that I'm autofilling to, ie Selection.AutoFill Destination:=Range("B7:B8"), Type:=xlFillDefault
I tried to replce the range with offset, but this doesn't work.
I'm using excell 2003.