View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Claus Busch Claus Busch is offline
external usenet poster
 
Posts: 3,872
Default Resize a row but copy but skip columns I don't want to copy

Hi Howard,

Am Fri, 30 Aug 2013 01:44:45 -0700 (PDT) schrieb Howard:

Dim myArr As Range
Dim j As Range
Dim i As Long


try:
Dim myArr As Variant
Dim i As Integer

j is not needed


Regards
Claus B.
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2