Kid Empties Bottle - Funny Waterfall

Occationally, on a large spreadsheet later in the process I
suddenly discover that when I try and Copy 1 cell (Ctl+C)
and Paste it to a single other cell (Ctl+V) it does so;

But if I go to another cell and Ctl+V - I get the Beep!!;
What is the nature of what I've done to cause multiple
pastes to multiple cells?

Any leads appreciated?

CONTEXT:

I am using a UserForm to update formula values on a worksheet. When a value is changed on the form, it is taken back to the worksheet where other cells are affected by its new value. The new values in the cells are then fed back to the form.

The original formula in each cell is defined in the Userform_Activate event with the intention that if the user cancels out of the form, nothing is changed on the sheet. (Well, in actual fact, it is changed back rather than not changed to begin with!)


PROBLEM:

The problem I am having is that while the code,

varFormulaWk4 = Cells(5, 45).Formula

actually picks up and stores the formula, when the Userform_Activate event is left the variable FormulaWk4 becomes empty.

Just so that you know, the variable FormulaWk4 is never redefined as part of the process of updating cells.


QUESTION:

How do I force a variable to retain its contents until I want to clear it?
Am I using the correct expression to define the cell formula in the first place?


Sorry to be quite vague....this is my first form!
Thanks in advance.

In column "P6:P13" I have values in cells like "Nov '10".
I want to check to see if the cells to the left are empty


O6 = 1 & P6 = Nov '10
O7 = "" & P7 = Nov '10
O8 = "" & P6 = ""
O9 = 1 & P6 = Nov '10
O10 = "" & P6 = Nov '10
O11 = 1 & P6 = Nov '10
O12 = "" & P6 = ""
O13 = 1 & P6 = Nov '10

P2 formula is COUNTIF(G6:G13,"Nov '10") which end result is 6. How would I need to change the formula to return 2 (O7 and O10 are empty)

Thanks,

Kurt

cell A1 contains a value : " 2.5; 3.68;;;9.87"

I have the following code

DataArray = Split (Cell(1,1),";")

For x= 0 to UBound(DataArray)
if DataArray(x)="" then DataArray (x)="-"
Next X

Do to the fact that these Arrays can get rather large, is there another quicker way to run this code?

I had a similar issue with converting text to numbers with using a for loop but was able to use the code
range(cell(1,1), cell(20,5)).value=range(cell(1,1), cell(20,5)).value

(I'm just trying to make the code run as quickly and efficently as possible)

Thanks

Hi,

Upon deactivation of a worksheet I am trying to check a range of cells("B8:M8") for empties. If any cells are empty I want to generate a MsgBox that asks the user to remedy the situation. It is not necessary to tell them which cell is empty but it would be nice. Can anyone help me format this code?

Thanks in advance.

Hi board,

I'm trying to check if one field in my query contains at least a numeric value bigger than zero. If the value isn't bigger than zero or there is no value at all , I want to see the result of the query. I'm a bit stuck here since I load data via a macro into a table. sometimes the check works, but sometimes it doesn't, so I think it has to do with the data type.

This is the query (SQL view)
Code:

SELECT Tbl2_Receipts_Updated.ItemNumber, Min(Tbl1_Cornerstones.Conversion) AS MinOfConversion, Tbl1_Cornerstones.Uom1, Tbl1_Cornerstones.Uom2, Tbl1_Cornerstones.Flavor
FROM Tbl2_Receipts_Updated LEFT JOIN Tbl1_Cornerstones ON Tbl2_Receipts_Updated.ItemNumber = Tbl1_Cornerstones.ItemNumber
GROUP BY Tbl2_Receipts_Updated.ItemNumber, Tbl1_Cornerstones.Uom1, Tbl1_Cornerstones.Uom2, Tbl1_Cornerstones.Flavor
HAVING (((Min(Tbl1_Cornerstones.Conversion)) Is Null Or (Min(Tbl1_Cornerstones.Conversion))="" Or (Min(Tbl1_Cornerstones.Conversion))

Is it possible to create a waterfall chart where the sections represent portions of 0 - 100% and then have one of those sections divided into subsections that make-up that component? Almost like a waterfall within a waterfall.

I am trying to break down how time is spent over an eight hour shift with one of those section comprising "lost time". From there I'd like to display the make-up of that lost time over a set of categories.

Can this be done in one chart or would the second part be better off in its own waterfall chart?

Hello,

Could anybody help me get my waterfall chart to work ? I have tried using the method from John Peltier i found in the forums. But i am doing something wrong ? I have attached the file with the data and the chart.
Somehow the chart will not cross the x axes ?

Thanks in advance for your help !

Hi guys. I need help in creating a waterfall chart.

I have a baseline figure, incremental adds and a final figure. I just need to know how to set up a table so I can make a waterfall chart from the numbers I have.

Sample sheet attached.

Thanks.

I need to chart the following-
count % to contract
300 30%
288 -30%
422 -50%

and so on.. the informations begins at -90% and goes thru 100%. I need to show the count using the % as the X showing the positive and negative.. i hope this makes sense.

Thanks!!