RE: $$Excel-Macros$$ Help with micro

[Daniel]

Hi,

Try :

 

Private Sub CommandButton1_Click()

Dim rg As Range

If [B5].HasFormula Then Exit Sub

Dim inCalculationMode As Integer

Application.ScreenUpdating = False

inCalculationMode = Application.Calculation

Application.Calculation = xlCalculationManual

Set rg = Range([B5], Cells(Rows.Count, 2).End(xlUp))

rg.FormulaR1C1 = "=24400*RC7/RC6"

rg.Offset(, 1).FormulaR1C1 = "=690.9*RC7/RC6"

rg.Offset(, 2).FormulaR1C1 = "=300*RC7/RC6"

rg.Offset(, 3).FormulaR1C1 = "=1000*RC7/RC6"

Application.Calculation = inCalculationMode

Application.ScreenUpdating = True

End Sub

 

HTH

Daniel

 

De : excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] De
la part de N.Shivkumar
Envoyé : dimanche 17 avril 2011 09:01
À : excel-macros@googlegroups.com
Objet : $$Excel-Macros$$ Help with micro

 

Dear friends

 

Please find enclosed attached file. Request for a solution for the same

 

Bye

 


 

 

N.SHIVKUMAR
Mobile : +919422613567
Office  : +912332301775
Alternate Email: shiv1...@yahoo.com

 

Please consider the environment before printing this email.

 

-- 

--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at  
http://exceldailytip.blogspot.com

To post to this group, send email to  
excel-macros@googlegroups.com
 
<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
  http://www.facebook.com/discussexcel

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

$$Excel-Macros$$ Deploying Excel 2003 updates

[BJthebear]

I have a spreadsheet with multiple macros and userforms running perfectly in 
Excel 2003 across 10 different sites with 10 different sets of information 
in the tables - but there are various improvements that have been requested 
and I was looking for some advice on redeploying a revised spreadsheet to 
each of the sites:-

1.  Are there any links which would point me in the right direction

2.  Is there a developers pack that makes this sort of thing easy - I am 
concerned about reformatting certain things in certain Worksheets - 
rewriting macros etc and ensuring that all the information is deployed 
correctly to all sites

Any help and advice would be truly appreciated

thanks

Brian 

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

$$Excel-Macros$$ Hyperlink embedded object in excel

[C.G.Kumar]

Sir,


I have 12 picture embedded in Sheet 1 and i intend to create a hyper link in
Sheet 2 for each picture. Is it possible to do without Macro run.
Referencing to nearby cell is not worthy.

Regards,

C.G.Kumar

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

Fwd: $$Excel-Macros$$ Re:Data - text to date format

[Mohd Sanusi Mohd Noor]

Dear all,

Would like to seek your kind assistance/help on the date format.
I've a data on date derive from SAP, when transfer to excel the date is in
text format.
Is there any way/method to change the dates from text to date format.

Attached is the sample data for reference.

The assistance on the above is highly appreciated.

Tq

Sanusi

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel


date from text to date format.xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet

Re: $$Excel-Macros$$ Re:Data - text to date format

[ashish koul]

try this

=SUBSTITUTE(B3,".","-")-SUBSTITUTE(A3,".","-")

On Sun, Apr 17, 2011 at 5:41 PM, Mohd Sanusi Mohd Noor
wrote:

>
> Dear all,
>
> Would like to seek your kind assistance/help on the date format.
> I've a data on date derive from SAP, when transfer to excel the date is in
> text format.
> Is there any way/method to change the dates from text to date format.
>
> Attached is the sample data for reference.
>
> The assistance on the above is highly appreciated.
>
> Tq
>
> Sanusi
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>



-- 
*Regards*
* *
*Ashish Koul*
*akoul*.*blogspot*.com 
*akoul*.wordpress.com 
My Linkedin Profile 


P Before printing, think about the environment.

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

Re: $$Excel-Macros$$ Re:Data - text to date format

[JYH]

That solution, although not entirely wrong, would not work on all
computers.

This is mainly caused because there are many potential problems :
1) the date items separator (here ".")
2) the date structure of the text field (here it is "ddmm")
3) the date structure as used by your system (could be mmddyy, yymmdd,
ddmmyy, mmdd, etc.)

If you know for sure the structure of the text value provided to you
(in this case, "dd.mm."), I always suggest you make sure you build
the right excel internal date structure like that:
=DATE(RIGHT(B3;4);MID(B3;4;2);LEFT(B3;2))-
DATE(RIGHT(A3;4);MID(A3;4;2);LEFT(A3;2))


On 17 avr, 10:21, ashish koul  wrote:
> try this
>
> =SUBSTITUTE(B3,".","-")-SUBSTITUTE(A3,".","-")
>
> On Sun, Apr 17, 2011 at 5:41 PM, Mohd Sanusi Mohd Noor
> wrote:
>
>
>
>
>
>
>
>
>
>
>
> > Dear all,
>
> > Would like to seek your kind assistance/help on the date format.
> > I've a data on date derive from SAP, when transfer to excel the date is in
> > text format.
> > Is there any way/method to change the dates from text to date format.
>
> > Attached is the sample data for reference.
>
> > The assistance on the above is highly appreciated.
>
> > Tq
>
> > Sanusi
>
> > --
>
> > --
> > Some important links for excel users:
> > 1. Follow us on TWITTER for tips tricks and links :
> >http://twitter.com/exceldailytip
> > 2. Join our LinkedIN group @http://www.linkedin.com/groups?gid=1871310
> > 3. Excel tutorials athttp://www.excel-macros.blogspot.com
> > 4. Learn VBA Macros athttp://www.quickvba.blogspot.com
> > 5. Excel Tips and Tricks athttp://exceldailytip.blogspot.com
>
> > To post to this group, send email to excel-macros@googlegroups.com
>
> > <><><><><><><><><><><><><><><><><><><><><><>
> > Like our page on facebook , Just follow below link
> >http://www.facebook.com/discussexcel
>
> --
> *Regards*
> * *
> *Ashish Koul*
> *akoul*.*blogspot*.com 
> *akoul*.wordpress.com 
> My Linkedin Profile 
>
> P Before printing, think about the environment.

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel