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
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
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
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