$$Excel-Macros$$ beginner question

I would like to know the best option between using an array (most often as type variant) or a range object? -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://tw

Re: $$Excel-Macros$$ vba for loops -beginner

& 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

$$Excel-Macros$$ Re: vba for loops -beginner

For the second question (redim a 2d array in a for loop) my own guess: c = 0 for r = 0 to cells.(r+1,1) = "" MyArray(r,c) = cells(r+1,c+1).Value c = c+1 redim preserve MyArray(r+1,c) next r ? -- -- Some important li

$$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 integer "tmp" that should return the number of cells filled in with data. Set wkb = ThisWorkbook S

Re: $$Excel-Macros$$ workbook location on status bar

thanx, Venkat solution is most practical for 2007 since it works on all workbooks that work and don't work with vba code. I guess the vba code for this is for Excel 2003? Pascal -- -- Some important links for excel

$$Excel-Macros$$ workbook location on status bar

Hi, Is there a code or a build-in option to have the location path of a workbook permanently showing on the Excel status bar? Thanks Pascal -- -- Some important links for excel users: 1. Follow us on TWITTER for ti