Search results for query: *

IRStuff, Sorry for the late reply. >Is this for school? Quite insulting :) No, I have a doctorate in engineering and I have done enough time at school :) XLNew.

I have a macro on my worksheet (this is acutualy a button, but I have found which macro this is running). Say this macro is "xyz" which gives me a result on cell A1. The macro uses B1 as an input to compute A1. That is, the macro is excecutable with the following piece of code...

Hello! Thanks. That did the trick. :) Best wishes, XLNew

Hi: Well you have understood my problem correctly - i.e I simply want to loop over columns using the INDIRECT function. However, > "=INDIRECT(" & Cells(8,i) & ")" Does not work. Something like "=INDIRECT(" & Cells(8,2) & ")" does not work either. The problem is for example, on...

Hello All, I have a rather strange problem in VBA. I have a simple loop, something like: '+++++++++++++++++++++++ For i=1 To 10 .. 'statements .. 'statements Range("C20").Select ActiveCell.FormulaR1C1 = "=INDIRECT(cells(8,i))" Next i '+++++++++++++++++++++++ Unfortunately, it looks like VBA...

Hello, Thanks very much. I got it! Best Wishes, XLNew.

Hello All, I have a rather silly question on VBA/Excel: In Excel, I have a sheet name specified in cell A1. Say the content of A1 reads myXLworkbook.xls Now, what I would like to do is open this workbook (myXLworkbook.xls) from VBA. Currently, I use: Workbooks.Open...

Hello, Thanks a lot. That solved the problem :) Thanks for the quick solution. Best, XLNew

Hi Doug, Thanks a lot. That solved the problem :) I am used to using Matlab - so VBA is kind of a new project for me. Once again, thanks for the quick solution. Best, XLNew

Hello. Just noticed an error in my question. I meant I wanted to add the string "y" not "e" XLnew

Hello All, I am new to VBA, and have the following question: I have an exsisting array A={1;2;3;4;5} I would now want to add the string "e" to all elements of the array. i.e A={1y;2y;3y;4y;5y}. How can I achieve this in VBA? At the moment, for generating the array (row vector), I have a for...

Hello All, I am new to VBA, and have the following question: I have an exsisting array A={1;2;3;4;5} I would now want to add the string "e" to all elements of the array. i.e A={1y;2y;3y;4y;5y}. How can I achieve this in VBA? At the moment, for generating the array (row vector), I have a for...