Excel query

[RandBlade]

Been given a (very complicated!) Excel spreadsheet that's not working. Its been changed here, there and everywhere and normally when I write one I do it from scratch - trying to fix what someone else wrote is complicated. A lot of features written originally linked in with a piece of software we don't have so they've been commented out etc and its all a bit confusing.

I'm trying to get my head around it, looking at the macro code and I'm puzzled by this definition:

Dim dtime(11, 4) As Variant

I thought variant was open-ended, I've never really used it. What does the (11, 4) mean? There are more examples throughout of variables being defined as variant with two numbers in brackets, not seen that before.

In the context its used it appears to be a two-dimensional array of references from 0 - 11 across and 0-4 down.

[Wraith]

It's what you think it is. A declaration of a 12x5 array of variants, indexes starting with 0 in both dimensions.

[RandBlade]

Thanks. I'm sure this is going to sound stupid but if I want a macro to delete an array, in this instance the range cd15:cd50 how do I do that? Having a mind fart right now.

[Wraith]

http://msdn.microsoft.com/en-us/libr...(v=VS.80).aspx

edit: wait, did you want to delete the array, or the sheet range? Are you asking about deleting a matrix?

[RandBlade]

The sheet range

[Wraith]

Range("CD15:CD50").Select
Selection.ClearContents

[RandBlade]

OK, that's worked but its leaving the range visibly highlights when you return to the spreadsheet.

Tried simply Range("CD15:CD50").ClearContents but its not working either as its causing an error due to it trying to change part of a merged cell.

[RandBlade]

Fixed it.

dim blank as range
Set blank = Range("CD15:CI51")
blank.ClearContents

[Dreadnaught]

Sometimes I can't tell if I should get an MBA or just take an Excel course. I've heard they are very similar.

[CitizenCain]

Excel course won't teach you what the formulas mean, just how to use MS macros to calculate the result of... all those squigglies.

But, don't take an Excel course. If you wanna go that route, take a broader programming course. That way you can write up Office Macros for silly banks and dinosaur businesses that use Excel for everything, and also have useful skills for businesses that actually use reasonable tools for the jobs they want done.