Posted to microsoft.public.excel.programming

Rewop Eilsel[_2_] Rewop Eilsel[_2_] is offline

external usenet poster

Posts: 8

IF Activecell

I have a global matrix, 36 columns x 24 rows, made up of 6 €“ 12 x 12 sub
matrices.
I want to write a macro that will determine which 12 x 12 RANGE contains the
ACTIVECELL and then REPLACE a specific value in that sub matrix.

I have tried to write nested IF statements e.g.
IF(Activecell()<(€œM13€),Range(€œA1:L12€),IF (Activecell()<(€œY13€)€¦etc
But each variation I make still fails with syntax or compile errors.
Can anyone please help

Rewop Eilsel

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	[email protected]	Excel Programming	2	August 9th 06 01:42 PM
Name the ActiveCell	Vikxcel	Excel Programming	1	October 19th 05 01:37 AM
activecell	slikity	Excel Programming	7	December 13th 04 11:59 AM
Activecell value	Shamsul Islam	Excel Programming	5	April 30th 04 10:10 PM

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

About Us

"It's about Microsoft Excel"

Menu

About Us