Posted to microsoft.public.excel.programming

Patty2005[_4_] Patty2005[_4_] is offline

external usenet poster

Posts: 1

Activecell address

Code
-------------------
Do... delete columns ................loop until(Activecell.address= "$B$ "
-------------------

In place of # I want to use a variable called "R" which a Value 16

I know I can directly write $B$16 but the objective is to find th
number of rows and dynamically checking for address.

Any help would be appreciated!!Thanks!!!

--
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
If activecell.column = variable then activecell,offset (0,1)	Battykoda via OfficeKB.com	Excel Discussion (Misc queries)	1	October 2nd 07 08:05 PM
ActiveCell.Address	Todd Huttenstine	Excel Programming	3	July 27th 04 04:45 PM
use of activecell	inquirer	Excel Programming	8	May 16th 04 06:39 AM
Activecell value	Shamsul Islam	Excel Programming	5	April 30th 04 10:10 PM
how to set activecell?	ljb[_2_]	Excel Programming	2	November 18th 03 04:49 PM

All times are GMT +1. The time now is 10:47 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us