U¿ytkownik "Jim at Eagle" napisa³ w
wiadomo¶ci ...
That worked. Every stored invoice on sheet4 is assigned the invoice
number.
Locating the range by the named allows viewing and printing. The code you
supplied will only work if sheet4 is selected. So range name is sheet
specific.
Thanks, now I can move on with frustrating myself further. Thanks again


"Macgru" wrote:


U?ytkownik "Jim at Eagle" napisa3
w
wiadomo?ci ...
I need to create a named range from an area that is still highlighted
from
a
copy paste special code before I lose the cell id. Is this possible?
Jim at Eagle


if its still selected from copy mode you can try
ActiveWorkbook.Names.Add Name:="your_name", RefersToR1C1:=Selection

you should add a number to your named range to have it done
automatically
like
i=1
......
i=i+1
mcg




try then sheest(...).selection
mcg