Hi Monika
try
Range("AK73:AO" & last_row_var)


--
Regards
Frank Kabel
Frankfurt, Germany

monika wrote:
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