Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by eargo

  1. eargo

    Multi Dimensional Array Question...

    Is it possible to ReDim a multidimensional array? Ideally don't want to declare a 100 x 100 element array when I'm only going to use say 30 x 70 elements or something on average. Thanks
  2. eargo

    Declaring a public array

    what exactly do I put, and where, I'm just getting errors when I declare it outside the subs or modules, and errors if I declare it inside.
  3. eargo

    Declaring a public array

    nope - no joy
  4. eargo

    Declaring a public array

    Hiya, how do you declare a public array? exactly? I can find no code snippets - and when I try: public dim colorarray(1 To 15) As Long I get an error. I've tried it inside a public function, and inside the calling cmd_button - and outside - still no joy. Basically, I want to be able to access...
  5. eargo

    Declaring a public array

    Hiya, how do you declare a public array? exactly? I can find no code snippets - and when I try: public dim colorarray(1 To 15) As Long I get an error. I've tried it inside a public function, and inside the calling cmd_button - and outside - still no joy. Basically, I want to be able to access...
  6. eargo

    Excel VBA OnEvent_Change Problem...

    Right, not quite sure how I'd go about this. Based on what you've said, I've created a new column - which calculates the length of the data validation box I'm having problems with. I've then added a Worksheet_Calculate Method, which checks the value of the active cell. PRoblem is, how to I call...
  7. eargo

    Deleting Rows in Excel

    Thanks guys - much appericated the help! Peter.
  8. eargo

    Deleting Rows in Excel

    One more thing, is it possible to delete a selection of cells instead of the entire row. I ask because I have embedded command buttons at the edge of the sheet, and their position is messed up when rows are purged... I want to delete Cells *current row, column 1 to *currentrow, column 13 -...
  9. eargo

    Deleting Rows in Excel

    Thanks xlbo & Andrew, That bit works Andrew.
  10. eargo

    Deleting Rows in Excel

    Tried replacing the : with ,'s but, while that compiles it fails to execute. Get the error: 'Application Defined or Object Defined Error' Code is: Private Sub CommandButton4_Click() ' Delete a record Rows(1, 1).EntireRow.Delete shift:=xlUp End Sub I can't see why...
  11. eargo

    Deleting Rows in Excel

    Using Rows(4:8).entirerow.delete shift:=xlup I receive a syntax error - the code won't even compile. I tried defining the sheet it was acting on first, so I had MySheet.Rows(4:8).entirerow.delete shift:=xlup - no luck tho yet
  12. eargo

    Deleting Rows in Excel

    I'm pretty new to VBA, but I am having problems getting a macro to delete any rows. I have a command button, with the following code: Private Sub CommandButton4_Click() ' Delete a record Set MySheet = Worksheets("Sheet1")...
See more

Part and Inventory Search

Back
Top