Posted to microsoft.public.excel.programming

Learner[_3_] Learner[_3_] is offline

external usenet poster

Posts: 14

VBA : Excel Range Selection Problem

I am experiencing a unique situation about the Excel Range. This is the
code :

Range(Cells(7, 6), Cells(7, intLastColumn).End(xlDown)).Select
Selection.NumberFormat = "0"

Its working most of the time and changing the format to "0" as desired.
(Columns will contain numerics only) But some times, For some wiered
reason, it wont reach till the last row. Anyone has similar experience.

Appreciate help.

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
How do you do a range selection dialog like those many in Excel?	LunaMoon	Excel Discussion (Misc queries)	2	July 31st 08 04:22 PM
Range selection problem	Brian	Excel Programming	3	February 4th 05 01:56 PM
range selection problem	derekc[_12_]	Excel Programming	2	June 18th 04 04:41 PM
Excel VBA - Range(Selection, Selection.End(xlDown)).Name issue.	jonH	Excel Programming	3	June 7th 04 09:13 PM
Range selection problem	SotjeRuud	Excel Programming	1	August 27th 03 12:41 PM

All times are GMT +1. The time now is 02:16 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us