firstblankrow

  1. M

    Subscript error

    For the life of my, I can't figure this out. I'm sure it's obvious. I'm getting a subscript error on the line in red below. Sub UpdateWatchlistM() Dim k1 As Worksheet, k2 As Worksheet Dim FirstBlankRow As Long, r As Long, StartingRow As Long Dim ESFound As Range Set k1 =...
  2. M

    Table Update VBA - byref argument type mismatch

    Hi there, I'm trying to update the information in a subset of columns in my table from another workbook. A bit of background on the data format and my objective. Workbook 2 (source) Columns A:K (1 to 11), each row is a person Workbook 1 (destination) The data from Workbook 2 are offset by one...

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