PC Review


Reply
Thread Tools Rate Thread

How can you change cell attributes in a function??

 
 
naxo
Guest
Posts: n/a
 
      19th Nov 2008
How can you edit cell attributes (other cells that the one you are editing)
in a function.
The problem arises when the function returns an array and I want to display
the answer in the adjacent cells automaticly instead of the user to pres ctrl
+ shift + enter
 
Reply With Quote
 
 
 
 
Gary''s Student
Guest
Posts: n/a
 
      19th Nov 2008
no
--
Gary''s Student - gsnu200814


"naxo" wrote:

> How can you edit cell attributes (other cells that the one you are editing)
> in a function.
> The problem arises when the function returns an array and I want to display
> the answer in the adjacent cells automaticly instead of the user to pres ctrl
> + shift + enter

 
Reply With Quote
 
naxo
Guest
Posts: n/a
 
      20th Nov 2008
I know you can´t but there must be a way to do that, as a matter of fact I´ve
found my own way. But thanks for your help

"Gary''s Student" wrote:

> no
> --
> Gary''s Student - gsnu200814
>
>
> "naxo" wrote:
>
> > How can you edit cell attributes (other cells that the one you are editing)
> > in a function.
> > The problem arises when the function returns an array and I want to display
> > the answer in the adjacent cells automaticly instead of the user to pres ctrl
> > + shift + enter

 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
change the color of a cell as a function of the cell value Gary F Microsoft Excel Programming 1 9th Jan 2008 06:07 PM
Can function in one cell change value or function in another cell? me Microsoft Excel Worksheet Functions 4 27th Feb 2006 01:04 PM
Can I modify cell attributes (font,color etc.) based on function . =?Utf-8?B?VGlja2xlUGln?= Microsoft Excel Misc 4 4th Dec 2005 04:23 AM
How do I change the color of a cell depending on the result of the function in that cell Mo Childs Microsoft Excel Programming 4 1st Nov 2005 09:30 PM
Using a function result in one cell to change a format in another cell =?Utf-8?B?QW5kcmV3IEJhcm5lcw==?= Microsoft Excel Misc 4 28th Jan 2004 12:16 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 12:19 AM.