switch

I need to switch characters around (namely £ so it sits before the numbers which proceeds it, and taking account of any decimal place). So if I have a instance of 100£ or 75.50£ to use VBA code to switch it to £100 and £75.50. The numbers are just examples but hopefully it illustrates it could...

Hello all, When I use SWITCH, and the values are formulas I don't get any result, when the values are just values i do. is there an alternative? Here's a shortened example: =SWITCH(D15,KDS!L9,KDS!N9,KDS!M10,KDS!N10,KDS!M11,KDS!N11,"-") KDS!L9: =M10-TIME(0,1,0) the value is 3:33 if I type...

Hi all, I just need a little help using a switch formula, I've used it before, but now I can't seem to make it work. I'm using a nested if... =IF(C5='Item Pricing'!C3,'Item Pricing'!G3,IF(C5='Item Pricing'!C4,'Item Pricing'!G4,IF(C5='Item Pricing'!C5,'Item Pricing'!G5,"-")))*B5 Which works...

Hello All, I have a couple formulas that have been created in 2016 and I need to see if there are any ways to easily convert it to an older version. I have several variations of this formula, so any assistance making this change would be greatly appreciated...

Hello all, I'm a bit lost on how to go about this: Both F10 & D10 are time values (start and end times for a work shift) Now, occasionally the F10 time will not display a time but rather say "CLOSE", is there a way for my formula to look at this as not a word but as whatever value is...

Hello, Hopefully this is one-liner. I open a workbook using the following code: Workbooks.Open Filename:="Z:\hq4p1v1\INVTRADE\El General\Early Return\" & Format(Now(), "m.d.yyyy") & " - PSRCashManagement.xls" Then I copy from it and paste into another workbook with a static name. I need...

Good Morning, I am trying to use a switch to modify excel data in a word mailmerge. I used the switch \@ "h:mm:ss AM\PM" after my field in advanced settings, but for some reason it renders like the below. Basically, it says A8P8 not automatically putting in AM or PM based on the time. What am...

I am running a macro that is calling a macro from another file. however, everytime i receive this error message: can not run the macro '' the macro may not be available in this workbook or all macros may be disabled I tried many codes but it still does not work, any suggestion? here you can find...

Good day, I have a dashboard that I have built within excel, however due to the amount of data that we require it to display, I have had to make the sheets switch. I was using the below to switch the sheets every minute, however the sheet "Specials" doesn't need to display for the same...

Hi guys, I have a question regarding the use of VBA switch statements, any help would be very appreciated, I'm still getting to know the language. Essentially, I have a column of integer values which I would like to iterate through. The integers in the column vary from 12 to -12 with the...

Hi all, here's what I'm trying to do (and thanks for helping, I'm very stuck): On one sheet, there is a list of names like this in one column: Smith (STAFF) Amy L (SALES) Picard (CAPTAIN) Jean Luc On another sheet, the names are listed like this: Amy L Smith(STAFF) Jean Luc Picard...

Somewhere in the past 48 hours, my Excel 07 CUT function turned into a COPY function. i.e. I either use the cut button or the CTRL+X and visually nothing happens (no selection rectangle), but when I paste, the proper content is pasted - and is now in the original range, and the pasted range...

In Windows you can switch between the Activewindow and the Last window by pressing [Alt]+[Tab]. I would like to be able to switch between Excel sheets the same way using [Alt]+[Caps Lock]. ([Alt]+[~] would be ideal, except that {~} in VBA is onkey for ENTER and cannot be assigned as itself)...

So simple, can't seem to find the answer I have a block of cells and I need to change all formulas from relative to absolute I've tried command-t, which doesn't do anything Also tried using the "Switch Reference" in the ribbon, which seems to work only when I am IN one cell. Any help would be...

I am able to activate the speak cell and can hear the computer speaking But one huge flaw in Excel’s cell speaking system is if you attempt to switch to another window or minimize excel while Excel is speaking the cells, it will stop! That virtually renders it useless if you attempt to cross...

I have a script to open programs, however is there a script that can just switch to the program if it is already open. i.e. switch to internet explorer.

Hello, I have a program that works pretty well, but I ran into this snag. I am looking to have a pre-defined shape copied into a newly created chart with a macro attached. So far, I have created the chart, copied the shape, and attempted to confirm the macro assignment, but the shape's macro...

Hi I have a pretty huge spreadsheet with +25 worksheets tabs. My problem is that sometimes I can not switch between them when clicking on the tabs. When I click the tabs either nothing happens or I get a standard windows right click menu even though i left click (like this one, but don't...

First of all, let me tell you that I am re-posting this cause a member of the board cannot see the contents of the post that was posted a few days ago: In a previous post I didn't know how to explain what was my problem. I now know that what I needed to do was to switch between rows/columns (I...

This probably sounds simple, but I haven't been able to figure it out. I'm trying to make a cell alternate between 0 and 1, or 1 and 2, etc. every time you enter in new data or press DELETE. I don't care what numbers or letters it alternates between, but I need it to switch back and forth every...