sitem

Hello, I want to copy 3 worksheets to a new workbook, but exclude a range from one of the worksheets (and any buttons on the worksheet as well. I want to exclude J1:U2 on "Metric Report" Is there a way to do this? this is what I am using right now Sub ThreeSheets() With...

I have the get folder location function listed below. I would like the dialogue box that opens to start into a specific root directory. This will allow the user to start at this location which they select the final destination from the list of folders within the root directory. How to I modify...

I'm using this to allow users to browse to a folder in order to save the file; Function GetInstallFolder() As String Dim fldr As FileDialog Dim sItem As String Dim sDesktop As String Dim bValid As Boolean sDesktop = Environ("USERPROFILE") & "\Desktop" Set fldr =...

I'm using this to browse to a folder to save the current workbook; Function GetInstallFolder() As String Dim fldr As FileDialog Dim sItem As String Set fldr = Application.FileDialog(msoFileDialogFolderPicker) With fldr .Title = "Toolbox" .AllowMultiSelect = False .InitialFileName =...

Hi I've written a macro to allow a user to export a selection from the active sheet to PDF and to save it in a user defined location....but it doesn't work! Can anyone help? Thanks in advance Sarah Sub Save_to_PDF() ' ' Save_to_PDF Macro ' ' Range("d1:AD103").Select...

Hi All, I am trying and failing to extract slicer values into a worksheet (Msgbox). I have made a very basic pivot based on Months and Qty's and cannot figure out why I get a Run-Time error 5 on the 'Set cache = ActiveWorkbook.SlicerCaches("Month")' line. Can someone please put me out of my...