Posted to microsoft.public.excel.programming

NetWave128[_3_] NetWave128[_3_] is offline

external usenet poster

Posts: 1

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

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
resizing a range of cells	ckane	Excel Discussion (Misc queries)	4	May 3rd 07 06:08 PM
Resizing a range of cells in a column	ckane	Excel Discussion (Misc queries)	0	May 3rd 07 02:38 PM
Resizing cells in a selection without resizing entire sheet	Danielle via OfficeKB.com	Excel Discussion (Misc queries)	4	August 11th 06 10:06 PM
Resizing Ranges	Chip Pearson	Excel Programming	1	August 13th 03 03:56 PM
missing items in sheet's activex list/combobox after resizing range	Tim Zych[_2_]	Excel Programming	1	August 11th 03 10:48 PM

All times are GMT +1. The time now is 06:30 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us