PC Review


Reply
Thread Tools Rate Thread

Apply Formula to Selected cells

 
 
ca.ankitgarg
Guest
Posts: n/a
 
      18th Jan 2007
hi everyone.

i have very complex worksheet and i want to apply a same formula to
some cell that i select. what is the solution for this. can it be done
through a macro. if yes can anybody write the VBA Script for me.

Thanks in advance.

 
Reply With Quote
 
 
 
 
ca.ankitgarg
Guest
Posts: n/a
 
      19th Jan 2007
simply i want data in C1:F2500 to be divided by 100000. i have names in
A1:A2500 and dates in B1:B2500 which should not be affected due to
this.

thanks for response.
Ankit Garg
Chartered Accountant
INDIA


Martin Fishlock wrote:
> Hi,
>
> Can you give every a little more information on the type of formua and what
> you want to do with it.
>
> --
> Hope this helps
> Martin Fishlock, Bangkok, Thailand
> Please do not forget to rate this reply.
>
>
> "ca.ankitgarg" wrote:
>
> > hi everyone.
> >
> > i have very complex worksheet and i want to apply a same formula to
> > some cell that i select. what is the solution for this. can it be done
> > through a macro. if yes can anybody write the VBA Script for me.
> >
> > Thanks in advance.
> >
> >


 
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
How do i apply the same formula for different cells in excel? =?Utf-8?B?VHJpc3Rhbg==?= Microsoft Excel New Users 1 8th Jun 2007 10:21 AM
How to apply a formula to all cells in a column Gillian White Microsoft Excel Worksheet Functions 3 29th Mar 2006 09:02 PM
apply a formula to multiple cells =?Utf-8?B?Rml4aXRGcm9n?= Microsoft Excel Misc 3 23rd Jun 2005 11:54 AM
apply formula to multiple cells James Microsoft Excel Worksheet Functions 6 4th Sep 2004 11:46 AM
Apply a macro to a pre-selected range of cells tim knowles Microsoft Excel Programming 2 13th Jan 2004 01:12 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 03:47 PM.