Hi
If you know the maximum possible range of your data, say A1:A1000,
RowCount = Application.WorksheetFunction.CountA(Range("A1:A1000"))
The RowCount variable is the number of rows that are filled with data.
Regards - Dave.
Date: Sat, 7 Mar 2009 06:01:24 +0530
Subject: $$Excel-Macros$$ Need he
There are a few ways that you can do it. The first is to start with the
first row and find the last populated row. Assuming data with every row
filled, you could do something like:
iNumberRows = Range("A6").End(xlDown).Row - Range("A6").Row
In this case, it assumes your data starts in A6, s
I use:
Rowcnt = Application.worksheetfunction.counta(range("A1:A65000"))
this will give you the number of cells in column A that contain data.
Paul
From: Ashkaran Badlani
To: excel-macros@googlegroups.com
Sent: Friday, March 6, 2009 7:31:24 PM
Subject: $$Excel
Hi All,
How can I check how many rows are filled with data in a macro.
--
Thanks & Regards Ashkaran Badlani
--~--~-~--~~~---~--~~
-
Some important links for excel users:
1. Excel
Thanks for your help Ashish - I'll give it a shot!
Regards,
Al
On Mar 4, 7:10 pm, Ashish Jain <26may.1...@gmail.com> wrote:
> ----
>
> Hi AI
>
> Your code is working fine on my
Hi Ashish,
Have you got the file ?
Regards
Kanwaljit
--~--~-~--~~~---~--~~
-
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloa
Hello,
If you are good in exce. Then record a Macro and use ALT + F11 and try to
understand what it has wrote for the steps you have perfromed.
There also lot of sites you can refer to as a beginner.
just write excel vba in google and you can find a lot of sites.
Hope this helps
Regards
Santos
Hello,
i am unable to find any attachement in the mail.
Regards
Santosh
On 3/6/09, r...@vi k...@r wrote:
>
>
> =clean(a:a & enter
> On 3/5/09, Lavprasad Kori wrote:
>>
>>
>> Dear All,
>>
>> Please help me.
>>
>> Attaching herewith the downloaded data. I want to do just text to column.
>> But
Sorry Ashish. Step 1 did not fix the issue, I still get the same
Error.
On Mar 5, 9:24 pm, Ashish Jain <26may.1...@gmail.com> wrote:
> Hi ccraif,
>
> Some check points for you, please try and revert back to us.
>
> 1. Try this(below) - Focus on _ (Underscore) in the end preceded by a
> spacebar.
=clean(a:a & enter
On 3/5/09, Lavprasad Kori wrote:
>
>
> Dear All,
>
> Please help me.
>
> Attaching herewith the downloaded data. I want to do just text to column.
> But when I do this, the data after special character (Square) has been
> deleted.
>
>
> --
> Thanks & Regards,
>
> Lavprasad Kori
10 matches
Mail list logo
