Select Case Scenario

[Skybluekid]

Hi All,

I am using a multiple Select Case Statement in vba. What I would like is if in the loop, it sees the word "Delete", then select the case Delete. In the case delete, I would like it to go straight back to the loop.

Thanks in Advance

 

[Peter_SSs]

That is very unclear to me.

 

[Skybluekid]

What I have on a sheet is a down load from a database. From the download, I have to copy items to several different sheets and some which I ignore. In order speed things up, I have created a helper column which will look at certain criteria and then show either Damage, OCS, Depot or Delete. I have created a macro, using Case Statement within a loop, that will look at the helper column and then call the relative procedure to copy that line an paste it in the relevant worksheet within the workbook. My Question was, the macro came across the word Delete, I noticed that it was going through the whole list of procedures before moving on. I wanted to know if there was a way of not scrolling down the list. I solved the issue by creating a Case Statement called Delete, with that I used the Goto Statement to bypass all the other cases.