Recent content by Cknight

Not sure if this helps but I just noticed I have had better luck with adding macros and not having them disappear from alt F8 if I unhide the Personal.xlsb sheet and go into VB editor through altF8. If I access through the developer tab and Personal.xlsb is hidden, there is almost an 100%...

I finally was able to recreate the error. Debaser- When the macros are not showing, I cannot access the References option. It is not greyed out or anything. Just when I click it, it does nothing. When the macros are showing properly in Alt F8, however I am able to access the Tools References...

Thanks vletm and Debaser! Now of course when I build a macro, it works as expected. I will attempt the Debug-Compile as soon as I get it to malfunction again and see if that fixes it and report back. I followed some of the other suggestions for the google search that I will look into as well.

Sorry they do not show when All Open Workbooks are selected either

Yes. That is the one. I can still see them in the Developer tab but they disappear when I add a new macro or edit an existing one and save personal.xlsb. I doubt size is an issue but I checked and my personal.xlsb file is hovering around 450kb in size

Hi all- I have had this problem happen intermittently over the past couple of years but now it seems to happen almost every time I try to save a new macro to my personal file. I will insert a module in developer mode and paste the vba code in or manually record a macro. I will then save the...

Thanks for the response! Is there a formula for column F as well that column E can reference?

Hi all- I have been trying to find a solution for this but have come up empty. We have a new system that puts all of our barcodes into one cell in column C (example below) These values are dynamic. Some have 1 barcode and some have 15+. I am trying to find a way to use index match or...

So true. Wise words!

Thanks everyone! I tried everyone's recommendations but did not have any success so I restored a backup from last week. I was still able to access the current Personal file so I exported those to NotePad and was able to paste those into the restored Personal file so I lost minimal work...

Hi all! I have no idea what happened. I have used a version of my Personal.xlsb file for years and have over 200 macros saved to it. I was creating a new macro, made my changes like normal and saved the personal file as usual. It had the unique box to save the personal as it usually does...

Pasting into Notepad puts each entry into its own row for me but all in column A. 9161264 9180788 2 1 XYZ 123 ABC 3456 6 12

That works perfectly. Thanks so much for your help!!

Here is another file to show what it looks like with more than 2 entries that need to be separated

Uploaded. Sorry about that