Making new Directories

[sassriverrat]

I have an workbook that will save as as required. I know how to make a specific directory with the MkDir code but here's where I get stuck. I'd like a piece of code that will check for the number in a specific cell (let's say Sheet1, Cell "A1") and will make a new folder if and only if the number doesn't fall in one of the previously made folders. These folders should range in increments of 50 (example- 1-50, 51-100, 101-150, Etc etc) and obviously if the folder is already created, then save in that folder, and if it doesn't exist, create it and save. A1 might have a number like 74, in which case it either makes folder 51-100 and saves it or just saves if the cell already exists. I have the coding for the C:\Users\Bridge\Desktop\Noon\ portion of the save as but i don't know the mkdir part.

thanks

 

[KolGuyXcel]

This might help!

https://www.mrexcel.com/archive/vba/macro-to-create-new-folder-save-file/

 

[sassriverrat]

I appreciate the idea but no go. I need excel to save in the right folder based on the number (range) of sheet1cellA1 and more importantly, if the folder doesn't exist, it needs to make it but it needs to make it based on ranges of 50.