realize

Hello I am looking for a code that when the command button is clicked it will change "B1" Private Sub CommandButton2_Click() If "B1" = 1 then "B1" = 2 else If "B1" = 2 then "B1" = 1 I realize this is not a code it's just and example of what I'm looking for. Thank you

Hello, I have a Question. I want to add two different columns from two different tables. How do i realize that in Dax. Which Function should I use? headoffice[Auftrags-Nr] and headpointofsale[Beleg-Nr]

Hi, I need the correct formula for a countbank function. The range should be A5 to A and the number in cell A1. I realize it may need an indirect to some concatenation, but I can't get it right. Thanks

I am working on an workbook that serves as a character sheet in a table top RPG that I play. I am trying to find a way to code the hit point functions in VBA so that I can enter numbers in three different cells and have the entered numbers subtract or add to other cells and then clear the field...

Hello, how do I get this string to round down instead of up. =INT(MROUND(B31,1/192)) & TEXT(12*MOD(MROUND(B31,1/192),1),"' - 0 #/##") & """" B31 = 10.81 OUTPUT = 10' - 9 3/4" But I need the out put to be 10 - 9 11/16" I realize that rounding up is the function of MROUND,, I tried other...

Trying to get and set an image's scaleheight and width msgbox activesheet.Shapes(1).ScaleHeight returns nothing. I realize there are 3 parts to Scaleheight and width Help a brother out? Thanks

I am wondering if someone could provide some insight; I am having trouble getting over the concept of ranges - why I am having trouble with Range(Cells(4, 3), Cells(88, 12)).Copy and no trouble with Range ("C4:L88").Copy I thought I may have read somewhere where it has to do with...

Is it possible to have a formula that will auto fill something to a name associated with it example if I type “A” it would then change it to “Auxilary” ”Bo” would go to bogart i realize I would need a reference table, but what kind of formula would I need to work with?