Dear Jake !
try the following solution:
Private Sub cmdOK_Click()
Sheet2.Range("A4:A1000").ClearContents
For x = 0 To ListBox2.ListCount - 1
Sheet2.Range("A" & x + 4).Value = ListBox2.List(x)
Next
End Sub
Best Regards
--~--~-~--~~~---~--~~
-
Yea I think it's a better solution, but Shahina want to copy only
visible rows if you don't know..
On May 22, 8:37 pm, TAlgo wrote:
> Try this if this helps
>
> Sub CopyPaste()
> Dim ws As Worksheet
> For Each ws In Worksheets
>
> If ws.Name <> "JAN" Then
> ws.Select
> ws.Applicatio
Hi Deepak rawat !
I saw the solution you have provided is working perfectly and also
implementing immediately that's a very good job doing by a VBA
function "OFFSET" I will highly appreciate.
On May 22, 1:20 pm, kishan@gmail.com wrote:
> Hi,
> I did this with vba, but I am unable to attach
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
t; not.
> They're pre-requisites for it.
>
> Regards
> Ashish Jainwww.excelitems.com
> Developer of Open XL
> ---
> On Apr 29, 9:44 am, msakibkhan wrote:
>
>
>
> > Hi gu
Hi guys,
I have just installed OpenXL Beta 1.0.0.0 successfully but it's not
showing any addin/toolbar in Ms-Excel 2007. But it's appearing in list
of installed application in Add/Remove Programs.
Can anybody help me please.
Thanks in ADVANCE.
Regards
--~--~-~--~~~--
Hi Amit..
I can help you if you send me your excel file and also mdb file so, I
will create VBA project as per your requirement.
Feel fee to contact me.
On Apr 25, 2:33 pm, Amit wrote:
> Hi,
>
> I wan to write data to an existing (with required tables) MDB from
> Excel 2003/2007 h
Hi Amit..
I can help you if you send me your excel file and also mdb file so, I
will create VBA project as per your requirement.
Feel fee to contact me.
On Apr 25, 2:33 pm, Amit wrote:
> Hi,
>
> I wan to write data to an existing (with required tables) MDB from
> Excel 2003/2007 h
