[beethoven]

I have the following code:

Sub Quicky()
If Worksheets("Daily").Range("B13").Value = 4 Then
Range("B13:H13").Merge
Range("B13") = "Due " & Range("B13").Value & " times"
End If
End Sub


This code works just fine, but if I change Range("B13") in the first line to Range("B11:B13") I get a type mismatch error. I don't know why. Any suggestions?

[Advertisements]

You want:
Range("B11:B13")

Try:
Range("C13:B13")

If that does work, you might know the problem.
Sorry that I'm not giving more detailed suggestions, but I don't know if your a student that wants to skip work or a worker that wants to skip learning.

Good luck.

[IO-error]

You want:
Range("B11:B13")

Try:
Range("C13:B13")

If that does work, you might know the problem.
Sorry that I'm not giving more detailed suggestions, but I don't know if your a student that wants to skip work or a worker that wants to skip learning.

Good luck.

[beethoven]

I do not really understand the problem, apart from Range not working with multiple cells (why I don't know). I would just like the code given to work with more than one cell at a time. I am a student who is learning VBA and sometimes aspiring a bit too high too fast and getting stuck. I'm not trying to skip either work or learning but would like to solve this problem. ("C13:B13") same problem.

[IO-error]

Okay, you now know that merging doesn't work on cells.
But something that could work is reading the cells and giving it a variable and then get this kind of idea.

VarA = B13.Value
VarB = B11.Value
VarC = VarA+VarB
VarD = "Due " & VarC.Value & " times"

***EDIT
If it doesn't work, don't give up, just come for help again.

Edited by IO-error, 09 March 2007 - 06:12 AM.

[beethoven]

Okay, you now know that merging doesn't work on cells.
But something that could work is reading the cells and giving it a variable and then get this kind of idea.

VarA = B13.Value
VarB = B11.Value
VarC = VarA+VarB
VarD = "Due " & VarC.Value & " times"

***EDIT
If it doesn't work, don't give up, just come for help again.

The merging works just fine, but the whole code breaks down if I try to apply it to more than one cell at a time.

[ChrisWright]

I think part of the problem is similar to one I was experiencing once.


The problem as I see it is that you are trying to compare a single value, vs a range.


I'm quite a beginner with VB and VBA myself, but if you PM me general information on what you are trying to do, I will get back to you as soon as possible, and will likely find a solution (even if it is long winded!)

Chris

[beethoven]

Thanks for your offer, but I actually just got the problem solved over at Ozgrid. Thanks anyway though for everybody's help!

Edited by beethoven, 12 March 2007 - 06:12 PM.