Excel help

Need some excel help. Need to exclude a specific column from a range when copying from one sheet to another. Here's what I have:

Private Sub Worksheet_Change(ByVal Target As Range)
  If Target.Address = "$G$1" Then
    Range("A2:P570").Value = Sheets(Target.Value).Range("A2:P570").Value
  End If
End Sub

Need to figure out how to leave out the entirety of column K.

Thanks in advance

Ask Stack Overflow.

http://stackoverflow.com

An actual programming question is my /prog/, WELL HAX MY ANUS.



  Range("A2:J570").Value = Sheets(Target.Value).Range("A2:J570").Value
  Range("K2:P570").Value = Sheets(Target.Value).Range("K2:P570").Value

Whoops meant L.


  Range("A2:J570").Value = Sheets(Target.Value).Range("A2:J570").Value
  Range("L2:P570").Value = Sheets(Target.Value).Range("L2:P570").Value

You are awesome thanks.

>>4
Nice try, /g/ro.

>>4
Excel is far from programming. Back to /g/ ``please!^!!''

>>4
That's not even how the HMA faggot uses HMA.

>>8
Trying way too hard to fit in. You know where to go back to. WHILE your at it, TRY and [b][u][i]HAX MY ANUS[i][/u][/b]

>>4,5
Can a ^BB_CO^DE EXPERT explain why the last ``Value'' is black instead of purple in these two posts?

>>10 need not reply.

>>12
Ok maybe I can help.

.............................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................

>>13
Did you just have a heart attack?

Excel has a language?

.............................................................................................................................................sorry, I'm back.

>>14
Yes. What was the question again?

nigger

http://mrscount.wikispaces.com/8th+Grade+-+Let%27s+Excel!