solved!!!

Dim Path As StringDim Filename As String Path = "C:\Report\" Filename = Range("B4") ActiveWorkbook.SaveAs Filename:=Path & Filename & ".xlsx", FileFormat:=xlNormal I am self teaching myself VBA and have run into an issue. Despite spending a lot of time searching, I wasn't able to get this macro...

Hey All, First huge fan of the site, been ridiculously helpful thus far. I finally hit a problem I hadn't found a thread for, and decided to join the community. Second, the problem... Background: I have used various frankenstiened pieces of code/recorded Macros/ and coded a bit to make a...

Hey, guys. I have a bunch of shapes that I grouped together. I want to Show/Hide them with a macro. I tried ActiveSheet.Shapes("Group 1").Hide and that didn't work at all. Is there a way to hide the whole group or show the whole group or do I have to show/hide them all individually?

I have a table that looks kind of like this: <tbody> T/F True False True True False False False True A B C D E F G H </tbody> The values in the blank spaces are either "N/A" or a number. I'm attempting to write...

I am working on a dashboard that has 4 Cascading Combo Boxes, where one filters the next which filters the next. They are connected to a linked cell with a named range. On another worksheet I have Pivot Table that is connected to a Pivot Chart on the same page as my Combo Boxes. Long...

I got my second ActiveX comboBox to populate based on the 1st comobox selection but now I need only unique values to show in Combobox#2 Here is my code for filling combobox2 <colgroup><col style="width:74pt" span="2" width="99"> </colgroup><tbody> Private Sub cmbRent_change()...

Instead of using slicers I would like to use dropdown lists to filter a Pivot table and pivot chart. Found this Macro on youtube and it was exactly what i needed. https://www.youtube.com/watch?v=S5Ix5a8GezE&list=FL_oli1FqDXvw11HOHmulHdA Here is the code I modified from the video to operate my...

Hello all, First off I'm really new to excel and vba so bare with me I've always been able to solve whatever problems I encounter, searching forum and melting my brain, but this one is way out of my reach and I don't seem to find nothing in the forums that clearly solves the problem. I'm...

Hi, I'm trying to learn VBA, and I'm getting stuck on the code that I have. Sorry that it is really amateur. I'd like to run this code that changes all blank cells to zeros in a specific range only on the worksheets who have a specific keyword in the tab name - I'd like the code to run on all...

Been picking my brain, trying to wrap my head around how to accomplish this... If worksheets("SNList").Range(C3:C94,"7FA")=>1 then worksheets("UT").Columns("AF:AN").hidden = True End If I know the above wont work, but I would be very grateful if someone could help me out. Thanks for any...

Hi! Is there a ISDATE native formula in excel? I am trying to enter a formula in one cell (cell Z11) in which, it will display TRUE if T11 finds the same value or date in cells B11:R32. Please take note that I formatted cells T11 and B11:R32 as [$-409]d;@ so that it would only display as number...

Hello! I'm new to this forum and I'm hoping that someone can help me out with a formula that I'm having trouble with. Below is a small recreation of the spreadsheet that I have to work with. I'm trying to count the number of Confidential parent sites that belong to Manager A, B, or C then add...

Good morning, I'm trying to write a VBA code that will alphabetize the tabs between a "Start" tab and an "End" tab. The tabs inbetween will constantly be changing names, so I want to have a code that will keep this alphabetized at any given time that are between the "Start" and "End" tab.

Het bedrijf, waar ik werkzaam ben, gaat binnenkort over op Office10. tot nu toe heb ik altijd gewerkt met Excel 2003, met de wizard sjablonen. Met deze wizard heb ik uitgebreide berekingen gemaakt, die opgeslagen worden in een aparte database. In Excel 2010 is deze plugin niet meer actief. Wel...