Search results for query: *

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

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

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

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

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

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

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

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

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