Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations TugboatEng on being selected by the Eng-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: XLnew
  • Order by date
  1. XLnew

    Solver-Macro loop

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

    Solver-Macro loop

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

    Loop within INDIRECT function

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

    Loop within INDIRECT function

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

    Loop within INDIRECT function

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

    Open file specified in Excel cell

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

    Open file specified in Excel cell

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

    Add string to array

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

    Add string to array

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

    Add string to array

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

    Add string to array

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

    Add string to array

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

Part and Inventory Search

Back
Top