1. D

    read and copy line from master tab to newly created tab

    I'm trying to take a master tab, 1. read column A, 2. create a tab in that workbook with the name found in column a, 3. then copy that one line from the master into the newly created tab. I have the code (below) that cycles thru column A and creates the tabs but having issue with copying the...
  2. M

    Ignoring Worksheet Copy Error

    Hi, I obtained this code for get individual worksheet sizes inside the workbook but it produces errors when attempting to copy a worksheet with vba code defining a global variable such as Private timerDictionary As Scripting.Dictionary This is the code I used to get individual size of each...
  3. N

    VBA For Each Formula & Autofill

    Dear All, Hello, I've just learnt how to use VBA and still new on it. I made a formula below, where it works perfectly for my sheet. Range("$AE$2").FormulaR1C1 = "=IF(RC[-25]=""V6"",LEFT(RC[-11],LEN(RC[-11])-1),RC[-11])" Range("AE2").AutoFill Destination:=Range("AE2:AE" & Range("F" &...
  4. P

    VBA Worksheet Combobox Font color setting

    I have the following code which programmatically adds a combobox to a worksheet. Set Cell = WSD.Range("J2") WSD.OLEObjects.Add(ClassType:="Forms.ComboBox.1", link:=False, _ DisplayAsIcon:=False, Left:=Cell.Left - 5, Top:=Cell.Top + 3, Width:=Cell.Width + 125...
  5. J

    Beginner Struggles with VBA

    I am trying to utlize the recording feature to learn about the code that controls excel via taking an action and then reviewing the code that is recorded. Recently I was able to get the following code to work: Sheets("GEN INCENTIVE").Select Range("AV1").Select Columns("AV:AV").Select...
  6. D

    Copy pasting cells from one worksheet to another in Excel

    Hello everybody, I am currently having some problems with my excel spreadsheet. In short, I have a list of materials in my "Order form" sheet 1 and I have all the hard data in a hidden sheet called "Products" (sheet 2). Currently, I have just set the fields in my "Order form" sheet = the...
  7. A

    Insert column dose not work

    Hi there I have an excel workbook and I can't insert any column in any worksheet. I will appreciate helping me on this. Here is the excel file .Excel file
  8. M

    Rename the worksheet based on cell value

    I want to rename the worksheet based on cell value and delete the row where cell value 1.Worksheet 1 contains cell value A1 have fruits. Worksheet 1 will be renamed as fruits. In the worksheet fruits, Cell value row should get delete. Worksheet 2 contains cell value A1 have vegetables. Worksheet...
  9. E

    How Do You Reference with a Single Statement Many Worksheet Names?

    I am doing a data pull that consolidates the data from multiple workbooks into a single workbook. My current code works as advertised; however, I would like to make the code more flexible by having it refer to specific cells in a spreadsheet on what and where to pull my data. I am having a...
  10. L

    Apply code to all but one worksheet in workbook

    I create a daily summary report each day that includes a pivot table with several worksheets based on filter pages within the pivot table. The pivot table includes a worksheet called "Executive Speeding Report" and "PT". Essentially the Executive Speeding Report worksheet contains the "raw" data...
  11. K

    Combining Two Worksheet VBA Codes

    Hi all, I would like to combine two worksheet VBA codes. The first code creates a timestamp and username of the last person to update any cell in the table, while the second code lock cells in the worksheet after data is entered into them. See code one below Private Sub...
  12. S

    Conditional formatting based on whether a specific sheet name is present

    Hello, I have a series of specific templates that are being added to a workbook. I would like to highlight a cell in the first sheet of the workbook if the workbook currently has a worksheet by that name present. For example, if I add a template named "Saturday" to the worksheet, I would like...
  13. L

    Worksheet trigger works one-time

    Hi all, I'm trying to use worksheet triggers to run a macro but it only works one time and then never again. Example: If write a worksheet trigger to hide rows if a cell displays 'Yes' (list data validation), it will work the first time after the workbook was open. After it has worked that one...
  14. J

    Help writing a hyperlink reference to another worksheet based on a number in a neighboring cell

    I'm using Excel 365 with Windows 10. I want to create links inside my excel file and am having a lot of trouble combining different formulas inside one cell to make a link. I have one workbook named "Trade Log" with two worksheets named "Trade Log" and "Screenshots." In the Trade Log worksheet...
  15. U

    Inserted row above total is not included in total. Any solution would be welcomed!

    I have a worksheet with a list of properties. Every time an expense is added to the list it goes on the last row for the property, just above the total. I welcome any kind of solution either a worksheet formula or a VBA solution that would insert the new row and update the =SUBTOTAL( and =Sum(...
  16. S

    Name a worksheet after cell contents

    Hi I have a bit of coding that copies an existing worksheet (called "SCHEMES") and puts it before another worksheet ("AUDIT") but I'd like to add in some code that will automatically take the content of cell A1 of the sheet that's copied across and automatically uses that as the worksheet name...
  17. L

    VBA PasteSpecial method Worksheet class failed

    Hello everyone, I have a code which starts this: Private Sub CommandButton1_Click() Dim destination As Worksheet Set destination = Worksheets("STATS") Set myIE = CreateObject("InternetExplorer.Application") myIE.Navigate "" myIE.Visible = True...
  18. T

    Loop Each Tab and Delete Rows

    I have the following code: Sub delete_dc_row() Dim wbCurrent As Workbook Dim wsCHINO As Worksheet Dim wsSTOCKTON As Worksheet Dim wsFLM As Worksheet Dim wsDGV As Worksheet Dim wsAURORA As Worksheet Dim nLastRow, i As Integer Set wbCurrent = ActiveWorkbook Set wsCHINO =...
  19. T

    Find Next Empty Cell

    Hello, I have the following code: Sub EmptyRow() On Error Resume Next Application.Calculation = xlCalculationManual Application.EnableEvents = False Application.ScreenUpdating = False Dim wbCurrent As Workbook Dim wsCHINO As Worksheet Dim wsSTOCKTON As Worksheet Dim wsFLM As Worksheet...
  20. K

    macro list of name ranges includes some i dont want

    I have a macro for listing all name ranges in active workbook when a certain worksheet is activated. the code is Sub Rprt() Dim nm As Name, n As Long, y As RANGE, z As Worksheet Application.ScreenUpdating = False Set z = ActiveSheet n = 8 With z .[a5:O155].ClearContents .[a7] =...

Watch MrExcel Video

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back