Posted to microsoft.public.excel.programming

morry[_21_] morry[_21_] is offline

external usenet poster

Posts: 1

Variable in range

Can a variable be put into a range? If so could somebody tell me wha
is wrong with this code. (Cell B6 hold a numeric value.)

Dim x As Range

x = Range("B6").Value

Rows("1:x").Select
Selection.Insert Shift:=xlDown

Thank you for the help

Morr

--
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
Use Sum() with variable range	Jeff	Excel Worksheet Functions	4	April 7th 09 05:26 AM
Variable Range	James C.	Excel Discussion (Misc queries)	3	April 2nd 09 12:41 AM
How to use a variable for a range	Jeff Lowenstein	Excel Worksheet Functions	1	July 26th 05 02:14 AM
variable range: l just can't get there!	ste mac	Excel Programming	2	October 27th 03 06:43 PM
Problem trying to us a range variable as an array variable	TBA[_2_]	Excel Programming	4	September 27th 03 02:56 PM

All times are GMT +1. The time now is 01:21 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us