hi...

i want to replace Range("AK73:AO102") ...proper address so as to remove
the hardcoding. i know the lastcell number of my sheet . but how do i
replace the above with proper using '&' ... i tried but it doesn't work !

Application.CutCopyMode = False
Selection.AutoFill Destination:=Range("AK73:AO102"), Type:=xlFillDefault
Range("AK73:AO102").Select

thanks
monika