Hi Don and ChilExcel Thanks for info. Don like earlier I have not put enough info. I should learn from this.
See attached workbook with comments. Thanks, apologies and regards Charlie Harris On Tue, Oct 18, 2011 at 12:29 PM, dguillett1 <dguille...@gmail.com> wrote: > If you have a defined name range such as myrng defined using this, then > if you drag to col A it will extend the named range to accommodate the new > data. zzzz assumes numbers. If numbers in col A, use 999999 or any number > greater than you might use > =OFFSET(Sheet1!$A$2,0,0,MATCH("zzzzzzzz",Sheet1!$A:$A),2) > > Don Guillett > SalesAid Software > dguille...@gmail.com > > *From:* Cab Boose <swch...@gmail.com> > *Sent:* Monday, October 17, 2011 5:57 PM > *To:* excel-macros@googlegroups.com > *Subject:* $$Excel-Macros$$ Paste into a Named Range > > Hi > > I have a 2 cells in a row that I want to copy into a named range (say > 'serialNo') also only 2 columns. > > Do I have to do the vba xcell up routine ? or should I be able to paste > into 'serialno' and it will go into next available row. I have tried > recording copy/paste, select 'serialno' but not successful. > > > > > Thanks > > > Charlie Harris > -- > > ---------------------------------------------------------------------------------- > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links : > http://twitter.com/exceldailytip > 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 > 3. Excel tutorials at http://www.excel-macros.blogspot.com > 4. Learn VBA Macros at http://www.quickvba.blogspot.com > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > To post to this group, send email to excel-macros@googlegroups.com > > <><><><><><><><><><><><><><><><><><><><><><> > Like our page on facebook , Just follow below link > http://www.facebook.com/discussexcel > > -- > > ---------------------------------------------------------------------------------- > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links : > http://twitter.com/exceldailytip > 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 > 3. Excel tutorials at http://www.excel-macros.blogspot.com > 4. Learn VBA Macros at http://www.quickvba.blogspot.com > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > To post to this group, send email to excel-macros@googlegroups.com > > <><><><><><><><><><><><><><><><><><><><><><> > Like our page on facebook , Just follow below link > http://www.facebook.com/discussexcel > -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
PasteToNamedRg.xls
Description: MS-Excel spreadsheet