RE: $$Excel-Macros$$ create macro to find first empty row

2010-07-30 Thread Dave Bonallack
).Offset(0, 1).Select End Sub > Date: Thu, 29 Jul 2010 22:41:12 -0700 > Subject: Re: $$Excel-Macros$$ create macro to find first empty row > From: federico.mazz...@ikea.com > To: excel-macros@googlegroups.com > > > Hi David, > many thanks for your answer. where i

Re: $$Excel-Macros$$ create macro to find first empty row

2010-07-29 Thread fede
Hi David, many thanks for your answer. where i should insert your line? regards Fede On 30 Lug, 01:24, Dave Bonallack wrote: > Hi, > > Try this line of code: > > Cells(ActiveCell.Row, Columns.Count).End(xlToLeft).Offset(0, 1).Select > > Regards - Dave. > > > > > Date: Thu, 29 Jul 2010 05:27:59 -

RE: $$Excel-Macros$$ create macro to find first empty row

2010-07-29 Thread Dave Bonallack
Hi, Try this line of code: Cells(ActiveCell.Row, Columns.Count).End(xlToLeft).Offset(0, 1).Select Regards - Dave. > Date: Thu, 29 Jul 2010 05:27:59 -0700 > Subject: $$Excel-Macros$$ create macro to find first empty row > From: federico.mazz...@ikea.com > To: excel-macros@googlegroups.co