Thread: How do I convert a user defined selection into an array?
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
keepITcool keepITcool is offline
external usenet poster
  
Posts: 2,253
Default How do I convert a user defined selection into an array?
Tom, yep. thx, rest ok? :)

keepITcool


"Tom Ogilvy" wrote:

Think you had a typo here

set rngData = rngData.Resize(10,2) '< changes it from a2:az2 to a12:b12



? range("a2:az2").Resize(10,2).Address
$A$2:$B$11

Reply With QuoteReply With Quote