How can I return a Cell reference to a variable.

Posted to microsoft.public.excel.programming

tolgag[_8_] tolgag[_8_] is offline

external usenet poster

Posts: 1

How can I return a Cell reference to a variable.

Hi, it's possible in several ways. I use the following method :

Dim rngCurrent as Range

Set rngCurrent = Selection

then you can format this range like this :

rngCurrent.Font.Size = 8

But if you put this code in selection change event and make a drop'n
drag, selection will change and probably you'll create an error.

---
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
Linear Mode Switch to 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
Using variable for cell reference	bmurlidhar	Excel Discussion (Misc queries)	3	July 17th 09 07:16 AM
vba variable value via cell reference	Bill (Unique as my name)	Excel Discussion (Misc queries)	3	November 29th 06 12:40 AM
Variable Cell Reference	0-0 Wai Wai ^-^	Excel Worksheet Functions	2	June 27th 06 07:05 PM
problem with cell reference in =sum(offset(cell reference,x,y,z,a)). Want cell ref to be variable.	[email protected]	Excel Worksheet Functions	2	December 11th 04 12:05 AM
Problem with =sum(offset(cell reference,w,x,y,z). I want cell reference to be variable	[email protected]	Excel Worksheet Functions	2	December 11th 04 12:00 AM

All times are GMT +1. The time now is 03:48 PM.

Menu

About Us