Posted to microsoft.public.excel.programming

salgud

external usenet poster

Posts: 219

false VBA cues

On Thu, 9 Oct 2008 14:43:03 -0700, The Code Cage Team wrote:

If you only want to reference 1 cell rather than a range just use cells!
Set rClient = wsTribalHist.Cells(3, lHistDataFinalCol + 1)

Regards,
The Code Cage Team
www.thecodecage.com/forumz

Thanks for your reply. That worked!

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Hybrid Mode Switch to 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
What's the best way to toggle between true and false in Excel? Hiall, My excel work involves a lot of toggling between true and false (booleantypes) ... and it's very repetitive... Is there a way to select a bunch ofcells, and press a key short-cu	LunaMoon	Excel Discussion (Misc queries)	9	July 29th 08 12:28 AM
What's the best way to toggle between true and false in Excel? Hiall, My excel work involves a lot of toggling between true and false (booleantypes) ... and it's very repetitive... Is there a way to select a bunch ofcells, and press a key short-cu	LunaMoon	Excel Programming	9	July 29th 08 12:28 AM
VBA always creates linked chart even when using PasteExcelTable False, False, False in Office 2007	Matt Simpson	Excel Programming	0	August 6th 07 08:11 PM
$C$1972,2,FALSE, $C$1972,3,FALSE is ok, But $C$1972,4,FALSE Give #	Steved	Excel Worksheet Functions	6	July 3rd 06 01:49 AM
True Or False, no matter what... it still displays the false statement	rocky640[_2_]	Excel Programming	2	May 13th 04 04:57 PM

All times are GMT +1. The time now is 10:37 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us