vba-help

  1. E

    VBA help reducing chain of linked cells

    To simplify the issue: I have 4 worksheets in my workbook: "Business X", "Business Y", "Totals" and "Summary". The formula in cell A1 of "Totals" is: ='Business X'!A1+'Business Y'!A1 and the formula in cells A1 of "Summary" is =Totals!A1 I want to cut out the middle man ("Totals" worksheet)...
  2. J

    VBA Auto Filter Error

    I've written code to compare the data included in 2 huge Excel files and while running the comparison code I encounter a "Run time error '91' - Object Variable or With block variable not set". Anyone know what my error is? The debug button leads me to the code bolded and underlined below...
  3. V

    Lock the cells in the worksheet and assign macro to button

    Hi, I have written a code to lock the cells in the worksheet, which is assigned to a button Sub CellLocker() Cells.Select Selection.Locked = false Range("A1:A54").Select Selection.Locked = true ActiveSheet.Protect DrawingObjects:=false, Contents:=true, Scenarios:=false End Sub Now, I'am...
  4. J

    Concatenate Multiple Adjacent Cells In Same Row to Another Cell in Row (VBA)

    I'm looking to concatenate the values in the same row for two separate columns, e.g., A1 and B1, into column C1, and to complete this task whenever values change in an identified range, e.g., A1:B10. I will in turn use the concatenated values in column C in my code, e.g., using vlookup. I...

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 MrExcel.com.
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 "mrexcel.com".
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
Back
Top