I'm looking for some VBA that will copy the values held in columns 2-9 in the last filled row of one worksheet to a named destination in another sheet.
I would normally have copied the entire row but if I use this it will over write some formulas in my second worksheet in columns 12 and 13.
Please accept my apologies if code which only needs to be tweaked to meet my needs has already been posted, but I couldn't find it.
Using Excel 2002 and trying to teach myself VBA using Power Programming by JW.
I would normally have copied the entire row but if I use this it will over write some formulas in my second worksheet in columns 12 and 13.
Please accept my apologies if code which only needs to be tweaked to meet my needs has already been posted, but I couldn't find it.
Using Excel 2002 and trying to teach myself VBA using Power Programming by JW.