dim not working on multiple ranges

[gary flynn]

I must be doing something basic wrong.

Please Login or Register  to view this content.

I get an error only for c, that the object variable or with block variable is not set.

if I change the dim line to
dim a, b, c, d as range and never use variable d, then the macro runs as I expect with no errors.

Can anyone explain? Visual Basic 6.5 in Excel 2003.

[royUK]

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code. Posting code without them makes your code hard to read and difficult to be copied for testing. Highlight your code and click the # at the top of your post window. For more information about these and other tags, found here

[royUK]

You use Set with Objects

Please Login or Register  to view this content.

I have added Code Tags in your post

[mdbct]

Only the last Variable is being designated as a Range. The preceding variables are variants by default. the whole Dim line does not receive the designation at the end of the line.
Because of this, a=Cells(1,1) is assigning the value of the cell to the variable. To assign a range to a variable, you have to use Set as in: Set c= Cells(1,1).

[romperstomper]

In other words, your complete code should be:

Please Login or Register  to view this content.