Some of you familiar with C may know the "continue" command, for example:
for (i=0; i<5; i++) // equivalent to For i = 0 To 5 in VB
{
if (some condition)
cpntinue;
some statement;
} // In VB this would say Next i
In this case, if "some condition" is satisfied, then instead of...
I need to select a range of cells from (1,1) to (i,8), where i is variable computed during the execution of my VBA routine.
Microsoft documentation (and my book) shows a way you can select the cells if the co-ordinates are hard-coded, e.g. range("a2:b3").select
However, how do you do that if...
I want to create a message box with the text "Which plant are you upgrading?" and three buttons: "Live" "Test" and "Cancel".
The text is not difficult to produce, but I do not know how to generate the buttons. I have searched the help instructions of the MsgBox function but it seems that the...
I am trying to copy a cell containing a time to another using .value but this results in a decimal!
Try running this on your computer:
Cells(1, 1).Value = "18:00"
Cells(1, 2).Value = Cells(1, 1).Value
In the first cell, the value is 18:00, but the value in the second cell is 0.75! (=18/24...
