input of single value into multiple cells simultaneously

Posted to microsoft.public.excel.programming

Joe[_42_]

external usenet poster

Posts: 27

input of single value into multiple cells simultaneously

Hi,

I'm trying to enter a bunch of asterisks into a range of cells (columns
A through I) in a row "i" in a worksheet that has been defined as SHD.
The macro has already "read" the value of i correctly. However, when I
use the following code, it gives me an error code. Could you tell me
what is wrong with this ?

SHD.Range(Cells(i, 1), Cells(i, 9)) = "********"

Appreciate any help.

Thanks,

Joe.

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
How to clear multiple cells of input data in Excel simultaneously	sstea	Excel Worksheet Functions	12	May 2nd 09 08:47 PM
In Excel how do I update cells in multiple sheets simultaneously?	kjh1210	Excel Discussion (Misc queries)	1	April 22nd 09 11:01 PM
How do I use multiple worksheets as input for a single pivot tab	Larry D Watts	Excel Worksheet Functions	1	December 29th 05 05:37 PM
Simultaneously change values in multiple cells?	Jaclyn	Excel Worksheet Functions	4	July 20th 05 05:24 PM
Pasting single cells from Word to multiple cells in Excel	ASBiss	Excel Worksheet Functions	1	February 15th 05 11:47 AM

All times are GMT +1. The time now is 08:09 PM.

Menu

About Us