sheetcol

  1. M

    new user having trouble with subscript on VB - error 9 : subscript out of range

    hello i am trying to self teach Excel skills to help me with work ..... i have followed an online "how to" and have encountered an issue and cannot progress as there is no guidance on how to rectify my problem any help you can provide would be great - im very new to excel so apologies if i...
  2. A

    VBA not working show run time error '13'

    Hi Excel Experts, Below VB shows run time error '13' what's wrong in the vb. please help me to solve the problem. Sub CheckUser() Dim UserRow, SheetCol As Long Dim SheetNm As String With Sheet1 .Calculate If .Range("B8").Value = Empty Then 'incorrect Username MsgBox "Please enter a correct...
  3. T

    Mixing data types

    Is it OK to mix data types? Function Matching(ByRef Startstring As Variant, ByRef Sheetname As Worksheet, ByRef Ref As String) As Variant Matching = Application.Match(Startstring, Sheetname.Range(Ref), 0) End Function Sub Start() Dim SheetCol...

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