About Us

Cassy

Hi all,

I made a calculator for a client of mine in a MS Excel Workbook (Office2k)
so far so good ...

Now they want to put the MS Excel file online, as an intranet
application. But then the users get an error message saying:
"Run-time error '91' Object variable or With block variable not set"
on this line of code:

Code:

ActiveCell.Offset(1, 0).Select

Using the Range("A1").Select for example works, but I want to run over
50 cells containing parameters for the calculator.

I should be able to use it like this:

Code:

Dim i
For i=1 to 5
	Range("A" & Cstr(i)).Select
Next 'i

But changing every ActiveCell in my code would be very difficult. Is
there another solution possible?

Thx in advance

-Cassy-
http://users.skynet.be/cassy

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

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
GET PAID $2000 PER WEEK FROM ONLINE MONEY MAKING PROGRAMME.THEREALPROGRAMME IN ONLINE	mark sheder	Excel Worksheet Functions	0	October 6th 08 12:01 PM
If activecell.column = variable then activecell,offset (0,1)	Battykoda via OfficeKB.com	Excel Discussion (Misc queries)	1	October 2nd 07 08:05 PM
Can't open online Help - get "Register for My Office Online"	Blue-eyed girl	Excel Discussion (Misc queries)	0	April 24th 07 04:04 PM
use of activecell	inquirer	Excel Programming	8	May 16th 04 06:39 AM
how to set activecell?	ljb[_2_]	Excel Programming	2	November 18th 03 04:49 PM

Menu

About Us