Cannot execute multiple Range in a Sub

[techissue2008]

Hi

I tried the following code but it shows an error:

Sub test2col()
Sheets("Sheet6").Cells.ClearContents
Sheets("Sheet6").Range("A:B").Value = Sheets("Sheet1").Range("A:B").Value
Sheets("Sheet6").Range("D").Value = Sheets("Sheet1").Range("C").Value
End Sub

It said

Sheets("Sheet6").Range("D").Value = Sheets("Sheet1").Range("C").Value
End Sub

has error.

Does a Sub not support to use Range more than one time? If so, do I need to write many Sub to do it?

Thanks for advance.

 

[dafan]

_ is used to cut long lines of code in smaller parts, this is purely functional so you can show the code in one window without having to scroll from left to right.

E.g.

Dim Text as String

String = "As you can see this string is very very very very very very very very" _
"very very very long and therefore i cut this into pieces"

:= is used (correct me if I'm wrong, other readers) for commands that use multiple arguments, like for example msgbox.
You can use Msgbox in multiple ways:

' Like this

Msgbox "Beep - messagebox!"

'Or

Msgbox("Beep - messagebox!",vbOK)

'Or

Msgbox Prompt:="Beep - messagebox!" Buttons:=vbOK

Not 100% sure of the syntax on that last one, but should give you an idea of what it does.

 

[jindon]

:= is used (correct me if I'm wrong, other readers) for commands that use multiple arguments

Named arguments.