do while criteria

Happy day Below is the data of my work. Data size will be variable.i need to format the rows and columns as per the values which are intersect. Rows' colors and formats of column C as shown in the left are as default color and format of the respective same rows in specified working range and...

Hi all. I wanna have loop that keeps "looping" as long as countif < 1, but also if the file is not found and if the vlookup returns an error. I can do only with the first condition: Else 'still need the location found but not price error handling MsgBox ("The location was not...

Hi all, I am having trouble taking my macro from a basic single loop to multi-loop based on certain conditions. The first loop below works properly but I cannot get a second and third identical loop to work without giving a "Loop Without Do" error. In my second and third loops I am replacing...

Hi everyone, I am trying to use a Do while with multiple conditions for an inputbox but it doesn't work. My code: '--------------------- dim x as variant dim y as variant Do While x - y <= 0 Or x-y > 30 or isnumeric(x)=false x = InputBox("Invalid value. Please insert")...