Search results for query: *

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

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.

nope - no joy

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...

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...

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...

Thanks guys - much appericated the help! Peter.

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 -...

Thanks xlbo & Andrew, That bit works Andrew.

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...

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

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")...