Search results for query: *

Thank you. That was a bit like forest for the trees. Appreciate your response.

Have found this adds the row desired but does not apply the column width formatting. No errors, just does not apply the formatting. If the formatting of the Master sheet could be applied to all other visible worksheets in the workbook this would be great. Am having difficulty without...

Hi Am trying to apply column widths to all worksheets in a workbook & then add 1 row at top of all worksheets except for the one named Master. Assistance Appreciated. Am struggling getting this code to affect all sheets, seems only to impact the 1st sheet in the workbook? Appears to run but...

Thanks Andy the Style Property works. Cheers

Thank you Skip, will perform some testing. Sometimes the obvious eludes us... Make it a Great Day! R

Have set up a User form in Excel 2007. In this form have added a Combo box for user to be able to select info from a drop down list in the Combo box. How can I prevent manual keying into this combo box. 2 option ideas: 1) If user attempt to key into the box engage MsgBox("Must Select from...

Sheet names are changed in the workbook so the Special name method does not work. Is there a way to do what was 1st asked? Can VBA Code in Sheet1 Module be copied & added to sheets 2 - 10 with VBA. Or could be copied from a specific sheet & added to 1st 9 sheets in the workbook.

1) Code is being applied to all worksheets? Only want to work on Sheets 1 to 10. Also, will the sheet tab name make a difference? 2) Also have applied to Worksheet calculate code as follows: Am getting Compile Error, Can't assign to read only property. Me.Name is highlighted in code. Works...

Skip, just provided sample code. Per usual there is other code involved in the three areas noted below. Ideally to start is there a way to do what was requested? This would save much needed time initially. In the longer term can definitely see the benefit of taking the approach you have...

While I attempt to apply what you have indicated, is there a way to do what I had asked to do?

Hey Skip Not all sheets use this same code, only sheets 1 - 10...

Am looking for a simple way to copy the VBA code for Sheet1 to Sheets2 - 10. Note there are a few other worksheets in the workbook that do not require this code. for sample sake, with VBA code below on found on Sheet1 module add same code to Sheets2 to 10 Private Sub...

SPath method worked well. Missed an error made when altering code. Thanks Skip, much appreciated. PH also thanks for your input.

Have tried all 3 methods suggested, no success. Starts Publishing & runs into Run Time Error 1004 Document not saved.... Ideas?

Code below is used to generate a PDF file from a workbook. Would like to be able to alter the code so the save file path can be in cell A12 on Sheet("Setup"). This is current hard coded into the code as Filename:="C:\Temp_Test\" .... Ideas appreciated Sub Export_PDF_File() ' ' Export_PDF_File...

To resolve this.... Separated Manual Debits & Manual Credits to two separate worksheets. Then applied code like below to get desired results. Similar code with "RELIC MANUAL CREDITS" as the Value to place in Column A. Fast & simple.. Thanks for all the input. Sub Manual_Dr_AcctType() Dim c...

Really just looking for a solution or some assistance with this peice On ImpartData1 worksheet. Number of Acct numbers will vary. Account Types MANUAL DEBITS & MANUAL CREDITS will not vary in number. Changing this Before Column A MANUAL DEBITS 00123 2256925 00234 5555555 01111 2222222 02222...

Without significant efforts to mask information am unable to do this. Are you able to provide some assistance that will allow understanding of how to perform the task with the one specific worksheet. ImportData1.

Simple code is set up to import data into a number of worksheets & clean up some of the formatting issues etc. For the sake of this discussion will call them DataImport1, DataImport2, DataImport3. Am looking for this code to to work on Active worksheet at this time. May later apply this...

Yes, each worksheet data is imported to will have Manual Debits & Manual Credit a Work Types. The number of acct numbers will vary.