$$Excel-Macros$$ Re: Find the first empty row

2009-05-04 Thread msakibkhan
Hi Jesper. there are some confusions, anywayz I can help you if you will attach a required sample. So I will ammend it with solution. OK On May 4, 12:22 pm, Jesper wrote: > Hi all > > I have a little problem with this VBA thing. I need to make a > macro that can find the first empty row

$$Excel-Macros$$ Re: Find the first empty row

2009-05-04 Thread msakibkhan
Hi Jesper. there are some confusions, anywayz I can help you if you will attach a required sample. So I will ammend it with solution. OK On May 4, 12:22 pm, Jesper wrote: > Hi all > > I have a little problem with this VBA thing. I need to make a > macro that can find the first empty row

$$Excel-Macros$$ Re: Find the first empty row

2009-05-04 Thread Harmeet Singh
Range("a1").End(xlDown).Offset(1, 0).PasteSpecial On Mon, May 4, 2009 at 12:52 PM, Jesper wrote: > > Hi all > > I have a little problem with this VBA thing. I need to make a > macro that can find the first empty row and paste the content of the > clipboard in that row from col A > > col H al

$$Excel-Macros$$ Re: Find the first empty row

2009-05-04 Thread Alokeshwar Tiwary
Sub SelectFirstEmptyRow() Dim r As Long r = Application.WorksheetFunction.CountA(Range("A:A")) Cells(r, 1).Select End Sub _ "There are known knowns. These are things we know that we know. There are kn