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 Wanet Telecoms Ltd 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

    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...
  2. 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...
  3. 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...
  4. 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