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 Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. 32131232424q2

    excel nested if or vba code

    thx for your input people, i cracked it with: Sub calc_cells() Dim End_Row As Long, n As Long End_Row = Range("C" & Rows.Count).End(xlUp).Row For n = 2 To End_Row Select Case Cells(n, 3).Value Case "EUR": Cells(n, 5).Formula = "=F" & n & "*O" & 2 Case "GBP": Cells(n...
  2. 32131232424q2

    excel nested if or vba code

    Ok, so i now have a function that I can use, but I have an issue where I've hard coded the cell references, sorry to seem obtuse, but how would I change these references to relative values? Thanks Function update_cells() As Double If Cells(c2) = "EUR" Then 'C2 e2 = f2 * o2 ElseIf...
  3. 32131232424q2

    excel nested if or vba code

    xlbo, because i have 9 currencies and maybe more in future...
  4. 32131232424q2

    excel nested if or vba code

    xlbo, you can only nest a maximum of 7 if statements, plus it would be harder to read bong, if I wanted to do this for multiple rows, say b2-10, c2-10 would I just list each value explicity or is there a way to dynamically account for new rows being added? thx
  5. 32131232424q2

    excel nested if or vba code

    hi, I've been asked to automate an excel facility to do the following: px-last=fx-rate (multiply or divide by currency rate) and if currency = gbp then divide gbp rate by 100 first Whether to multiply or divide depends on the currency Currency PX_LAST FX Rate Fx Table JPY 4,810.0000...
  6. 32131232424q2

    Excel f2 function takes too long

    Hi, Would anyone know why hitting the f2 fuction on a cell would take around 20 seconds to display the formula in the requested cell? Excel displays the formula in the formula bar instantly, but if you hit f2, Excel takes around 20 seconds to display the formula in the chosen cell, any ideas...
  7. 32131232424q2

    Macro opens same workbook every time

    Hi, I'd like to know how to assign a macro to a toolbar without the macro opening the original document the macro was written in. Essentially, I need to open an excel workbook (say book1) to write a macro, but I wan't to use this macro with several workbooks. I've assigned the macro to a...
  8. 32131232424q2

    Excel macro

    Thx for replies, Here's the code: Sub updater_() Application.Calculate End Sub I believe this does the same job as hittig F9 on the keyboard, but sometimes on the worksheet f9 doesn't seem to work, so I've written this macro as a work around. Any ideas, let me know. Thx
  9. 32131232424q2

    Excel macro

    Hi, I'd like to know how to assign a macro to a toolbar without the macro opening the original document the macro was written in. Essentially, I need to open an excel workbook (say book1) to write a macro, but I wan't to use this macro with several workbooks. I've assigned the macro to a...

Part and Inventory Search

Back
Top