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