Search results for query: *

I need to include a macro in my spreadsheet that will take a directory of files and combine them into a single specific sheet in my spreadsheet. I found code here(http://www.rondebruin.nl/fso.htm) that I could tweak for my specific purposes, and it works in most cases. After a few test runs...

I'm working with the Worksheet_Change event for the first time. It works fine when individual cells are changed, recalculating all my relevant columns. Unfortunately, copy/pasting or deleting entire rows of cells will call the subroutine so many times that everything slows down to a crawl. I...

I’m trying to add a “Last Time Updated” column to my spreadsheet of product information. I got it to work (it updates Cell BQ every time any cell in that row is changed), but it has “broken” the Undo function in Excel. I just get an error beep and nothing is undone. If I can’t fix that, I’ll...

I have a spreadsheet of product info including two columns – “Color” and “Color Family.” The Color column is for specific (sometimes odd) color names like “Starry Night.” The Color Family column is supposed to clarify that the Color actually is for search purposes (e.g. “Silver”). I’m trying...

I’m completely stuck on this one! I’m programming an entry form for entering product information into an Excel spreadsheet. Until recently, my “Undo” button worked just fine. Now, it’s stopped working and I haven’t specifically been testing it on every save, so I don’t know which changes I...

I have been teaching myself VBA to create a data entry form for entering my company's products into a spreadsheet. The form includes 30 textboxes where the user can enter the specific brand’s possible colors, and a checkbox for each to indicate whether that color should be used for a specific...