visual basic error

  1. H

    Type Mismatch Error in VBA for Range

    Hi, I get a type mismatch error for the following Sub DeleteEmptyRows()On Error Resume Next range("A:A").Select Selection.SpecialCells(xlCellTypeBlanks).EntireRow.Delete End Sub Regards, Hasib
  2. K

    400 Error on Button Press Before Sub-Procedure Runs

    I have a button (Form Control not ActiveX Control) that when pressed, calls a sub procedure inside inside a worksheet module for the worksheet that the button is on. For whatever reason after opening the workbook the first time I click on the button, it produces a 400 error: Every time I click...
  3. E

    Run time error from code capitalizing all cells in multiple ranges

    I implemented the following VB code to my excel sheet where I want all input within multiple ranges forced to capital letters. Code is as follows: Private Sub Worksheet_Change(ByVal Target As Range) If Not (Application.Intersect(Target, Range("E9:CQ19, E22:CQ32, E35:C45")) Is Nothing) Then...
  4. C

    Translate INDEX/MATCH code from Cell to VBA in excel

    Hello, I have an Index/ Match code that basically cross references values in a table to give a numerical output and need help translating it into VBA. Here is the original code: =INDEX(T2:AH14;MATCH(B7;S2:S14;0);MATCH(B15;T1:AH1;-1)) Range of Outputs is T2:AH14 Table Header/ Column is...
  5. cmpgeek

    run-time error '1004': Method 'Intersect' of object '_Global' failed

    I have some VBA code that someone helped me with years ago that works great 99% of the time. For some reason, When I try to delete one cell from all the spreadsheets within the workbook at once - or do a replace all on a highlighted group of cells (again - on all spreadsheets at once) I get the...
  6. J

    VB Code to auto sort

    I am trying to have data I enter in Col B (300 lines) auto sort Hig to low and can't seem to get it to work. Any Ideas? Private Sub Worksheet_Change(ByVal Target As Range) If Intersect(Target, Range("B1:B300")) Is Nothing Then Exit Sub Application.EnableEvents = False Me.Sort.SortFields.Clear...
  7. H

    Stock quote question

    Hello everyone, I am trying to learn VB for stock quoting. I want to quote the index from this site. https://www.etnet.com.hk/www/eng/stocks/realtime/quote.php?code=0011 I would like to quote Nominal, High, Low and Turnover values in the blue boxes. And P/E ratio in the table. and export it...
  8. A

    Malpractices in using the Currency data type?

    Hi everyone, I'm quite not sure if my question is right, I just want to make sure I'm programming things correctly. "D Anyway here it goes. I'm using the Currency data type to store and manipulate employee salary values. As of the moment, I'm just using simple MDAS operations. I'm...
  9. P

    Ctrl-X Error

    Whenever I attempt to cut using CTRL-X in Microsoft Excel 2003, I get a Microsoft Visual Basic error: Argument not optional. To my knowledge I am not having any other problems. I am able right-click and choose cut or choose it from the Edit pull-down ... it is just the shortcut key that is not...

Some videos you may like

This Week's Hot Topics

Top