View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
NetWave128[_3_] NetWave128[_3_] is offline
external usenet poster
 
Posts: 1
Default Resizing a Range

This line in my code keeps crashing it says:" Object Variable or Wit
block variable not set"

HERE IS THE LINE:


Dim MyRange as Range

MyRange
ThisWorkbook.Worksheets("Sheet1").Range("a1").Curr entRegion.Resize(MyRange.Rows.Count
1)


Thank you for your help

--
Message posted from http://www.ExcelForum.com