mysheet

I'm an idiot or something. I took, what I thought were pretty straight forward directions on here, but it's not working out for me. MISC S1 has a month in it. I get an error no matter what I do with the "Set ws = Sheets(MySheet)" line. I just want that "JUL" to change depending on the cell in...

I'm at a standstill right now. I have some code that will run when cells in a Column A are selected. These particular cells are only for invoking the code. Each cell is used as a reference cell that is in the same row as the PO used. The code will create a second worksheet (invoice) and name the...

So I created some code that will allow a user to enter multiple pages of data and then just click a print button to click the number of pages of data he has entered. However we are running into a problem where by if a user enters 200 lines of data, then deletes the last 25 lines, it is still...

I am trying to get a better understanding how to declare Public variables and call them in various subs (mainly Private Subs). I am using the message box to test my code. O.K. so just below the Option Explicit and above a Private Sub, I declared a Public variable. Option Explicit Public...

Hello friends, hope all is well! I want to copy and paste the code: Worksheet_Activate Call copy_value Call format End sub To every unhidden sheet’s module in the workbook. The sheets are selected via the following code: Sub SelectSheets() Dim mySheet As Object For Each mySheet In...

Hi All, First of all thank you for you're help, your about to cure my head ache I have this running (see below) and I am trying to run the macro but it's telling me I need to unprotect the sheet, but it's not protected, im not an expert when it comes to all this but it has been working fine...

Hi All, Can anyone tell me why I am receiving the Pastespecial of range class failed error when trying to paste a copied range of rows from one workbook to another? My code is below: Sub GetPricingData() Application.ScreenUpdating = False Dim StartDate, EndDate As Date Set MySheet =...

Hi all, I am currently having a lot of difficulty trying to update legacy code to become dynamic. Effectively I want to create a loop that runs through a bunch of pivot tables, refreshes them according to some some cell value on an index sheet (i.e. new filter is Sheet1!A1 or similar), and then...