Hi Don Further to your suggestion of using the offset etc. I have included in attached workbook, but if I drag a number into column A it places it where I place it and not in next available row. Would you mind checking and see if I have this set up correctly. When fixed I can use recorder to get code.
Thanks and regards Charlie Harris On Tue, Oct 18, 2011 at 1:19 PM, Cab Boose <swch...@gmail.com> wrote: > > 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