Thread: Range Reference Problem
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Claus Busch Claus Busch is offline
external usenet poster
  
Posts: 3,872
Default Range Reference Problem
Hi,

Am Tue, 18 Oct 2011 10:49:37 -0700 (PDT) schrieb sylink:

Range("B2:D & Z & ")

try:
Range("B2:D" & Z)

Regards
Claus Busch
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2
Reply With QuoteReply With Quote