Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Search results for query: *
- Users: excelblackbelt
- Content: Threads
- Order by date
-
How to create a solid color data validation list
Does anyone know how to create a solid color data validation list (without text)- excelblackbelt
- Thread
- Replies: 13
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Need help on a Macro Excel 2010 for filtering / cut / save worksheet
Hello: I have a worksheet that I need to breakout by location into separate worksheets. Does anyone know of a macro that does this? I don't want to have to copy and paste every single country out into new sheets. I am working with 12,000 rows of data. Also, if I am maintaining budgets in these...- excelblackbelt
- Thread
- Replies: 28
- Forum: VBA Visual Basic for Applications (Microsoft)
-
My Macro turned off my formulas...how do I fix this? I have included the coding!
This macro takes a workbook and divides the sheets and saves them by name. Now the original workbook the values and formulas work, but when I run the macro and go into an individual sheet the formulas do not work...can someone help here? Sub Copy_Every_Sheet_To_New_Workbook() Dim FileExtStr As...- excelblackbelt
- Thread
- Replies: 11
- Forum: VBA Visual Basic for Applications (Microsoft)
