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...
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 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...
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 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...