wsname

Hi, I have the following macro that copies the master sheet and adds a sequential number every time its run. I also need it to replicate the sheet number in cell S13. My macro works but for some reason the sheet numbers change after i insert the second sheet. The worksheet numbers represent the...

Hi everyone, I am trying to have Excel print a specific number of pages according to a cell value. I have it working perfectly for a form control button in my spreadsheet, but i want it to do the same when the user prints from the file menu. I do not know vba so have copied the working code from...

Hi team, Code below. I t is meant to run through the work book and format the Tab name with the name in D6. It has been working fine for a couple months but now it refuses to budge from this error on this line. There are on 10 names that appear repeatedly. Sub Tab_name() Dim ws As Worksheet...

Good Afternoon, Can anyone please assist in displaying the tab name in a cell value. I need to tab name to automatically update without having to manually run any macros. I've tried using the following equation =MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,255) which works...

I have found similar topic that deal with copying an entire sheet in one workbook and pasting it to a NEW sheet while the value on the specific cell increments and adds to the name of the new sheet created. However, the code provided was incomplete and missed the copying of the entire template...

Hi forum, I am having a weird problem that I've been struggling for a couple of weeks now. I have a list of employee names in Column A and a a For loop that sets the worksheet name ("wsName") to each cell value (employee names). The macro works fine for the first 13 employees; on the 14th...

Hi Experts, I need to create new worksheets using the names stored in an Array, however, when I run my code it creates the right amount of sheets, but the names are not been assigned to the new worksheets, so I was wondering if one of you could point my mistake, below is my code: Sub...

I have a template sheet that I need to copy 1 button on the template sheet to the new sheet. I am using the following code to copy the sheet; can someone assist with the code need to copy the button (Button 2) as well in this code? Sub Duplicate_Sheet() Dim wsName As Variant With...

Hi All. Pls help me. What's wrong in the following code? The line in red in returns error. But why? Both files i keep open during running macro. ------------------------------------ Sub GL_DPR_FillIn() ' Fills in Report with up-to-date data. Dim wbA As Workbook Dim wbB As Workbook Dim...

Hi I pretty new to VBA and have a problem I need some help solving. I have one sheet with a range (MyRange) containing the sheet names I would like to loop through. If the sheet name matches the name in MyRange I would like the macro to create a pivottable on a sheet that already is created and...