st = st & vbCrLf
>>>Next
>>> MsgBox st
>>> End Sub
>>>
>>> -Original Message-
>>> From: excel-macros@googlegroups.com [mailto:
>>> excel-macros@googlegroups.com]
>>>
@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of vijayajith VA
Sent: Monday, July 25, 2011 5:51 PM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ vba for loops -beginner
Hi rajan
Can you explain
below code
st = st & vbTab & Ar
& vbTab & Arr(Rw, Cl)
>Next
>st = st & vbCrLf
>Next
> MsgBox st
> End Sub
>
> -Original Message-
> From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
> On Behalf
Please Attach Your Code and Workbook
-Original Message-
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of netuser501
Sent: Sunday, July 24, 2011 6:37 PM
To: MS EXCEL AND VBA MACROS
Subject: Re: $$Excel-Macros$$ vba for loops -beginner
I'm lo
& Arr(Rw, Cl)
> Next
> st = st & vbCrLf
> Next
> MsgBox st
> End Sub
>
>
>
>
>
>
>
> -Original Message-
> From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
&g
M
To: MS EXCEL AND VBA MACROS
Subject: $$Excel-Macros$$ vba for loops -beginner
Hi
The question worksheets is filled with data on 5 rows and 3 columns.
I'd like to have this data stored in an Array. For testing purpose, I
want to test if the loop is "reading" the data with an intege
Hi
The question worksheets is filled with data on 5 rows and 3 columns.
I'd like to have this data stored in an Array. For testing purpose, I
want to test if the loop is "reading" the data with an integer "tmp"
that should return the number of cells filled in with data.
Set wkb = ThisWorkbook
S