$$Excel-Macros$$ EXCEL HELP

[Tarun Mondal]

Sir ,

I have entered values 200 and o in one single column and i want generate a
report how many 200 and how many 0 are there in the same column.please sir
reply quickly ...it's urgent...


-- 
Tarun Mondal
Postal Assistant
Katwa Head Post Office
Burdwan,West Bengal
(9474810276)

-- 
FORUM RULES (986+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com

help.xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet

$$Excel-Macros$$ EXCEL HELP

[somasekhar duvvapu]

hi,

Can anybody help me for writing excel macro.

plz find the attached excel sheet for the problem,


with regards,
sekhar

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
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
If you find any spam message in the group, please send an email to:
Ayush Jain  @ jainayus...@gmail.com
<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 6,700 subscribers worldwide and receive many nice notes about the 
learning and support from the group.Let friends and co-workers know they can 
subscribe to group at http://groups.google.com/group/excel-macros/subscribe


Test.xls
Description: MS-Excel spreadsheet

$$Excel-Macros$$ EXCEL HELP

[karthikeyan]

HI,

I HAVE 500 PERSONS NAME IN SHEET1.
LIKE:-BOX
 BAT
 BALL
 BLACK
 AXE
IN SHEET2 AND SELECT CELL A1 WHEN I ENTER FIRST LETTER (AVAILABLE IN
SHEET1) LIKE "B" COLUMN "C" SHOWS LIST OF AVAILABLE NAMES STARTING
WITH "B"-LETTER.ITS LIKE GOOGLE SEARCH.WITHOUT MACRO.
HELP ME ABOVE THIS QUERY.

THANKS,
KARTHIK

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678
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

<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 6,800 subscribers worldwide and receive many nice notes about the 
learning and support from the group.Let friends and co-workers know they can 
subscribe to group at http://groups.google.com/group/excel-macros/subscribe

$$Excel-Macros$$ excel help

[preeti vora]

Hi team,

when we do vlookup is that possible without col_index_num and range_lookup
for use vlookup..or can we use any other function instead of vlookup...

-- 
Regards,

Preeti Vora.

-- 
--
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

<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 7000 subscribers worldwide and receive many nice notes about the 
learning and support from the group.Let friends and co-workers know they can 
subscribe to group at http://groups.google.com/group/excel-macros/subscribe

$$Excel-Macros$$ Excel Help

[How Do you?]

I'm using excel to do weekly time sheet and I created another page/tab
with in the same workbook and I'm trying to post job numbers between
the two sheets. If I post a new Job number and it's not already on the
control sheet I want to add, not + but include it in the job numbers.
Anybody?

--~--~-~--~~~---~--~~
Visit the blog to download Excel tutorials at 
http://www.excel-macros.blogspot.com

To post to this group, send email to excel-macros@googlegroups.com
For more options, visit this group at 
http://groups.google.com/group/excel-macros?hl=en

Visit & Join Our Orkut Community at 
http://www.orkut.com/Community.aspx?cmm=22913620

To Learn VBA Macros Please visit http://www.vbamacros.blogspot.com

To see the Daily Excel Tips, Go to:
http://exceldailytip.blogspot.com
 
If you find any spam message in the group, please send an email to Ayush @ 
jainayus...@gmail.com
-~--~~~~--~~--~--~---

$$Excel-Macros$$ Excel Help...

[Ashkaran Badlani]

Hi Team,

I have a list of numbers in an excel columns.  I need to open a site and
enter the numbers one by one in the search field of Open site and hit
enter.  I also need to capture the some information from the screen after
clickling enter and then get back to the search page.  Can anyone please
help me with this.

I also need to know about some good books which will help me to learn
advanced VBA language.  Can anyone suggest me any books.

-- 
Thanks & Regards
Ashkaran Badlani

--~--~-~--~~~---~--~~
-
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 

To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain  @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com
-
-~--~~~~--~~--~--~---

$$Excel-Macros$$ Excel-Help

[raafi barey]

Hi,

I have a data which is more than the capacity of excel 2002..how can i
retrieve the complete data..ny possibilty of loading into seperate
sheets..

Regards
Raafi

--~--~-~--~~~---~--~~
-
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 

To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain  @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com
-
-~--~~~~--~~--~--~---

$$Excel-Macros$$ Excel Help

[karthikeyan]

HI,

How can i fillter the colored cells in excel. Except 2007

Txs
karthik

--~--~-~--~~~---~--~~
--
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 

To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain  @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com
<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 6,500 subscribers worldwide and receive many nice notes about the 
learning and support from the group. Our goal is to have 10,000 subscribers by 
the end of 2009. Let friends and co-workers know they can subscribe to group at 
http://groups.google.com/group/excel-macros/subscribe
-~--~~~~--~~--~--~---

$$Excel-Macros$$ excel help

[karthikeyan]

Hi,

A particular sheet in excel file doesn't allow cut/copy/paste.

txs

-- 
--
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 

To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain  @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com
<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 6,500 subscribers worldwide and receive many nice notes about the 
learning and support from the group. Our goal is to have 10,000 subscribers by 
the end of 2009. Let friends and co-workers know they can subscribe to group at 
http://groups.google.com/group/excel-macros/subscribe

$$Excel-Macros$$ Excel Help

[DavidG]

Hi

I am trying to build a system for a hairdressers to manage their
contacts and activity. I have tried using access which is the obvious
answer but I am struggling with the relationships. So i thought excel
might do the job. I need a new page per client, but am unsure if excel
will do this?

Any ideas or help will be greatly appreciated.

Thanks

-- 
--
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$$ Excel help

[bhanu prakash]

Hi - need it help excel. Removing zeros in alpha numeric data, ex ,,07855a
need help in removing zeros in every cell. Regards ,- bhanu

-- 
--
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$$ excel help me

[Deepu Raj]

how to remove 1025 to 25 or 140 to 40 ie hundred and thousand removing 
using excel 

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at https://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

Re: $$Excel-Macros$$ EXCEL HELP

[NOORAIN ANSARI]

Dear Tarun,

Please use..

=COUNTIF($E$1:$E$19,0)
=COUNTIF($E$1:$E$19,200)
On Thu, May 31, 2012 at 11:46 AM, Tarun Mondal wrote:

> Sir ,
>
> I have entered values 200 and o in one single column and i want generate a
> report how many 200 and how many 0 are there in the same column.please sir
> reply quickly ...it's urgent...
>
>
> --
> Tarun Mondal
> Postal Assistant
> Katwa Head Post Office
> Burdwan,West Bengal
> (9474810276)
>
>
>  --
> FORUM RULES (986+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>
> To unsubscribe, send a blank email to
> excel-macros+unsubscr...@googlegroups.com




-- 
Thanks & regards,
Noorain Ansari
www.noorainansari.com
www.excelmacroworld.blogspot.com

-- 
FORUM RULES (986+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com

Re: $$Excel-Macros$$ EXCEL HELP

[somasekhar duvvapu]

Hi Group,

I want to learn excel macros. so can anybody
have excel macro learning document for easily learning.

with regards,
sekhar

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
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
If you find any spam message in the group, please send an email to:
Ayush Jain  @ jainayus...@gmail.com
<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 6,700 subscribers worldwide and receive many nice notes about the 
learning and support from the group.Let friends and co-workers know they can 
subscribe to group at http://groups.google.com/group/excel-macros/subscribe

Re: $$Excel-Macros$$ EXCEL HELP

[shannu shannu]

Excellent peice of work
 
need one more help what if it was vice versa, we can take the same example 
taking A61 USA and its repeating 3 times till A18, and I want one consolidated 
file which will give a summary of unique items which has USA in column A and 
the result should be year like 2001, 2002, 2003.
 
same like vlookup but the result is unique then keep on adding with a comma for 
that look up.
 
Regards,
Shan

--- On Wed, 2/10/10, ayush jain  wrote:


From: ayush jain 
Subject: Re: $$Excel-Macros$$ EXCEL HELP
To: excel-macros@googlegroups.com
Cc: somasekhar2...@gmail.com
Date: Wednesday, February 10, 2010, 8:43 AM


Hi Somasekhar,

Attached is the solution for your reference. Use the below macro to implement 
the task. Let me know if any further assistance is required.

Sub distribute()

copystartrow = 16
Beginrow = 4
Endrow = 9

Sheets("Sheet1").Range("A3:D3").Copy
Sheets("Sheet1").Range("A" & copystartrow - 1 & ":" & "A" & copystartrow - 
1).PasteSpecial
    
For i = Beginrow To Endrow
    For j = 1 To Sheets("Sheet1").Range("B" & i)
    Sheets("Sheet1").Range("A" & i & ":" & "D" & i).Copy
    Sheets("Sheet1").Range("A" & copystartrow & ":" & "A" & 
copystartrow).PasteSpecial
    copystartrow = copystartrow + 1
    Next
Next

End Sub

Best regards,
Ayush Jain
Group Owner




On Tue, Feb 9, 2010 at 10:35 PM, somasekhar duvvapu  
wrote:


hi,
 
Can anybody help me for writing excel macro.
 
plz find the attached excel sheet for the problem,
 
 
with regards,
sekhar
-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
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
If you find any spam message in the group, please send an email to:
Ayush Jain @ jainayus...@gmail.com
<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!
 
We reach over 6,700 subscribers worldwide and receive many nice notes about the 
learning and support from the group.Let friends and co-workers know they can 
subscribe to group at http://groups.google.com/group/excel-macros/subscribe



-- 
Best regards,
Ayush Jain


-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
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
If you find any spam message in the group, please send an email to:
Ayush Jain @ jainayus...@gmail.com
<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!
 
We reach over 6,700 subscribers worldwide and receive many nice notes about the 
learning and support from the group.Let friends and co-workers know they can 
subscribe to group at http://groups.google.com/group/excel-macros/subscribe



  

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
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
If you find any spam message in the group, please send an email to:
Ayush Jain  @ jainayus...@gmail.com
<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 6,700 subscribers worldwide and receive many nice notes about the 
learning and support from the group.Let friends and co-workers know they can 
subscribe to group at http://groups.google.com/group/excel-macros/subscribe

Re: $$Excel-Macros$$ Excel Help

[rf1234 rf1234]

dear shiv
i think you can use a simple way pivot table and pivote grapgh.
 if more help required please send me me your sample sheet,and
offcourse image file for required graph.



hope it will help.
happy to help.
:)
shyam

On Wed, Mar 3, 2010 at 10:05 AM, Shiv Goel  wrote:

> Hi
>
>
> I try to make option payoff charts from this excel sheet.
> But somewhere I am doing mistake.
> Please solve this problem
> I have also attached chart which I try to make
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our Facebook Group @
> http://www.facebook.com/group.php?gid=287779555678
> 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
>
> <><><><><><><><><><><><><><><><><><><><><><>
> HELP US GROW !!
>
> We reach over 6,800 subscribers worldwide and receive many nice notes about
> the learning and support from the group.Let friends and co-workers know they
> can subscribe to group at
> http://groups.google.com/group/excel-macros/subscribe
>

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678
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

<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 6,800 subscribers worldwide and receive many nice notes about the 
learning and support from the group.Let friends and co-workers know they can 
subscribe to group at http://groups.google.com/group/excel-macros/subscribe

Re: $$Excel-Macros$$ excel help

[Dilip Pandey]

Hi Preeti,

Vlookup requires col_index_num and range_lookup to function properly,
If reqd., instead of Vlookup you can use Index, Match, Offset, SumIf,
Sumproduct etc as well.  :)


-- 
Thanks & Regards,

DILIP KUMAR PANDEY
  MBA-HR,B.Com(Hons),BCA
Mobile: +91 9810929744
dilipan...@gmail.com
dilipan...@yahoo.com
New Delhi - 62, India


On Wed, Jul 21, 2010 at 9:01 PM, preeti vora  wrote:

> Hi team,
>
> when we do vlookup is that possible without col_index_num and range_lookup
> for use vlookup..or can we use any other function instead of vlookup...
>
> --
> Regards,
>
> Preeti Vora.
>
> --
>
> --
> 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
>
> <><><><><><><><><><><><><><><><><><><><><><>
> HELP US GROW !!
>
> We reach over 7000 subscribers worldwide and receive many nice notes about
> the learning and support from the group.Let friends and co-workers know they
> can subscribe to group at
> http://groups.google.com/group/excel-macros/subscribe
>

-- 
--
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

<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 7000 subscribers worldwide and receive many nice notes about the 
learning and support from the group.Let friends and co-workers know they can 
subscribe to group at http://groups.google.com/group/excel-macros/subscribe

Re: $$Excel-Macros$$ excel help

[Dilip Pandey]

Dear Karthik,

Check if that sheet is protected.

Best Regards,
-- 
DILIP KUMAR PANDEY
   MBA-HR,B COM(Hons.),BCA
Mobile: +91 9810929744
dilipan...@gmail.com
dilipan...@yahoo.com
New Delhi - 110062


On 12/1/09, karthikeyan  wrote:
>
> Hi,
>
> A particular sheet in excel file doesn't allow cut/copy/paste.
>
> txs
>
> --
>
> --
> Some important links for excel users:
> 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at
> http://www.excelitems.com
> 2. Excel tutorials at http://www.excel-macros.blogspot.com
> 3. Learn VBA Macros at http://www.vbamacros.blogspot.com
> 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
>
> To post to this group, send email to excel-macros@googlegroups.com
> If you find any spam message in the group, please send an email to:
> Ayush Jain  @ jainayus...@gmail.com or
> Ashish Jain @ 26may.1...@gmail.com
> <><><><><><><><><><><><><><><><><><><><><><>
> HELP US GROW !!
>
> We reach over 6,500 subscribers worldwide and receive many nice notes about
> the learning and support from the group. Our goal is to have 10,000
> subscribers by the end of 2009. Let friends and co-workers know they can
> subscribe to group at
> http://groups.google.com/group/excel-macros/subscribe

-- 
--
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 

To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain  @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com
<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 6,500 subscribers worldwide and receive many nice notes about the 
learning and support from the group. Our goal is to have 10,000 subscribers by 
the end of 2009. Let friends and co-workers know they can subscribe to group at 
http://groups.google.com/group/excel-macros/subscribe

RE: $$Excel-Macros$$ excel help

[Dave Bonallack]

Check to see if there is a SheetActivate event macro for that particular sheet.

Regards - Dave.
 
> Date: Tue, 1 Dec 2009 08:06:15 -0800
> Subject: $$Excel-Macros$$ excel help
> From: karthikeyansankar...@gmail.com
> To: excel-macros@googlegroups.com
> 
> Hi,
> 
> A particular sheet in excel file doesn't allow cut/copy/paste.
> 
> txs
> 
> -- 
> --
> Some important links for excel users:
> 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
> http://www.excelitems.com
> 2. Excel tutorials at http://www.excel-macros.blogspot.com
> 3. Learn VBA Macros at http://www.vbamacros.blogspot.com
> 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
> 
> 
> To post to this group, send email to excel-macros@googlegroups.com
> If you find any spam message in the group, please send an email to:
> Ayush Jain @ jainayus...@gmail.com or
> Ashish Jain @ 26may.1...@gmail.com
> <><><><><><><><><><><><><><><><><><><><><><>
> HELP US GROW !!
> 
> We reach over 6,500 subscribers worldwide and receive many nice notes about 
> the learning and support from the group. Our goal is to have 10,000 
> subscribers by the end of 2009. Let friends and co-workers know they can 
> subscribe to group at http://groups.google.com/group/excel-macros/subscribe
  
_
A world FIRST in property search has arrived! Check out Domain Radar NOW!
http://clk.atdmt.com/NMN/go/157631292/direct/01/

-- 
--
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 

To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain  @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com
<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 6,500 subscribers worldwide and receive many nice notes about the 
learning and support from the group. Our goal is to have 10,000 subscribers by 
the end of 2009. Let friends and co-workers know they can subscribe to group at 
http://groups.google.com/group/excel-macros/subscribe

Re: $$Excel-Macros$$ Excel help

[STDEV(i)]

run this macro

Sub RemoveAllZeros()
   Dim xCell As Range
   For Each xCell In ActiveSheet.UsedRange
  xCell = Replace(xCell, "0", "")
   Next
End Sub

since you ask for  "REMOVING ZERO IN EVERY CELL"
1500   will be 15
2100500  will be 215
and so on




On Sun, Apr 3, 2011 at 9:55 PM, bhanu prakash  wrote:

> Hi - need it help excel. Removing zeros in alpha numeric data, ex ,,07855a
> need help in removing zeros in every cell. Regards ,- bhanu
>

-- 
--
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$$ Excel help

[ChilExcel]

Please attach file, so see what you need
There are many ways, row or column or range

I answer what you need to pair







2011/4/3 bhanu prakash 

> Hi - need it help excel. Removing zeros in alpha numeric data, ex ,,07855a
> need help in removing zeros in every cell. Regards ,- bhanu
>
> --
>
> --
> 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
>



-- 
Visita ; http://sites.google.com/site/chilexcel/Home
Visita ; http://www.youtube.com/user/timextag41

-- 
--
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$$ Excel help

[Mahesh parab]

Hi

Use
=SUBSTITUTE(A1,"0","")

On Sun, Apr 3, 2011 at 8:25 PM, bhanu prakash  wrote:

> Hi - need it help excel. Removing zeros in alpha numeric data, ex ,,07855a
> need help in removing zeros in every cell. Regards ,- bhanu
>
> --
>
> --
> 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

Re: $$Excel-Macros$$ Excel help

[Dhananjay Pinjan]

u can use the following formula

=SUBSTITUTE(A1,0,"")
(where Cell A1 is target data)



Regards,
Dhananjay
On Sun, Apr 3, 2011 at 8:25 PM, bhanu prakash  wrote:

> Hi - need it help excel. Removing zeros in alpha numeric data, ex ,,07855a
> need help in removing zeros in every cell. Regards ,- bhanu
>
> --
>
> --
> 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

Re: $$Excel-Macros$$ Excel help

[Shreedar Pandurangaiah]

Hi Bhanu,

Select all the cells where you want to remove zeros and select control + H,
and type 0 and replace with blank and then click on* Replace All.*
*
*
*
*
Thank you,
Shreedar

On Sun, Apr 3, 2011 at 8:25 PM, bhanu prakash  wrote:

> Hi - need it help excel. Removing zeros in alpha numeric data, ex ,,07855a
> need help in removing zeros in every cell. Regards ,- bhanu
>
> --
>
> --
> 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

Re: $$Excel-Macros$$ Excel help

[bhanu prakash]

Guys thanks a ton for  responses ,i need to remove only first  letter in
cell if it is zero in alpha numeric data - regards - bhanu

On 04-Apr-2011 3:45 AM, "STDEV(i)"  wrote:

run this macro

Sub RemoveAllZeros()
   Dim xCell As Range
   For Each xCell In ActiveSheet.UsedRange
  xCell = Replace(xCell, "0", "")
   Next
End Sub

since you ask for  "REMOVING ZERO IN EVERY CELL"
1500   will be 15
2100500  will be 215
and so on






On Sun, Apr 3, 2011 at 9:55 PM, bhanu prakash  wrote:
>
> Hi - need it help...



-- 
--
Some import...

-- 
--
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$$ Excel help

[ashish koul]

try this made some changes in the code

Sub RemoveAllZeros()
   Dim xCell As Range
   For Each xCell In ActiveSheet.UsedRange
 If Left(xCell.Value, 1) = 0 Then
 xCell.Value = Right(xCell.Value, Len(xCell.Value) - 1)
 End If

   Next
End Sub


On Mon, Apr 4, 2011 at 6:04 AM, bhanu prakash  wrote:

> Guys thanks a ton for  responses ,i need to remove only first  letter in
> cell if it is zero in alpha numeric data - regards - bhanu
>
>  On 04-Apr-2011 3:45 AM, "STDEV(i)"  wrote:
>
> run this macro
>
>  Sub RemoveAllZeros()
>Dim xCell As Range
>For Each xCell In ActiveSheet.UsedRange
>   xCell = Replace(xCell, "0", "")
>Next
> End Sub
>
> since you ask for  "REMOVING ZERO IN EVERY CELL"
> 1500   will be 15
> 2100500  will be 215
> and so on
>
>
>
>
>
>
> On Sun, Apr 3, 2011 at 9:55 PM, bhanu prakash  wrote:
> >
> > Hi - need it help...
>
>
>
> --
>
> --
> Some import...
>
>   --
>
> --
> 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$$ Excel help

[STDEV(i)]

then the macro should be modified like this

Sub RemoveLeadingZeros()
   Dim xCell As Range, i As Integer, s As String
   For Each xCell In ActiveSheet.UsedRange
  s = CStr(xCell)
  For i = 1 To Len(xCell)
 If Mid(xCell, i, 1) = "0" Then
s = Right(s, Len(s) - 1)
 Else
Exit For
 End If
  Next i
  xCell = s
   Next xCell
End Sub


On Mon, Apr 4, 2011 at 7:34 AM, bhanu prakash  wrote:

> Guys thanks a ton for  responses ,i need to remove only first  letter in
> cell if it is zero in alpha numeric data - regards - bhanu
>

>
> On 04-Apr-2011 3:45 AM, "STDEV(i)"  wrote:
>
> run this macro
> Sub RemoveAllZeros()
>Dim xCell As Range
>For Each xCell In ActiveSheet.UsedRange
>   xCell = Replace(xCell, "0", "")
>Next
> End Sub
> since you ask for  "REMOVING ZERO IN EVERY CELL"
> 1500   will be 15
> 2100500  will be 215
> and so on

-- 
--
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$$ Excel help

[§»VIPER«§]

if your data in a1 type the below formula on anywhere in the same worksheet
=IF(AND(ISTEXT(A1),LEFT(A1,1)="0"),RIGHT(A1,LEN(A1)-1),A1)


-- 
*Thanks & Regards

Thamu
*


On Mon, Apr 4, 2011 at 6:04 AM, bhanu prakash  wrote:

> Guys thanks a ton for  responses ,i need to remove only first  letter in
> cell if it is zero in alpha numeric data - regards - bhanu
>
> On 04-Apr-2011 3:45 AM, "STDEV(i)"  wrote:
>
> run this macro
>
> Sub RemoveAllZeros()
>Dim xCell As Range
>For Each xCell In ActiveSheet.UsedRange
>   xCell = Replace(xCell, "0", "")
>Next
> End Sub
>
> since you ask for  "REMOVING ZERO IN EVERY CELL"
> 1500   will be 15
> 2100500  will be 215
> and so on
>
>
>
>
>
>
> On Sun, Apr 3, 2011 at 9:55 PM, bhanu prakash  wrote:
> >
> > Hi - need it help...
>
>
>
> --
>
> --
> Some import...
>
>  --
>
> --
> 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

Re: $$Excel-Macros$$ Excel help

[STDEV(i)]

i think  mr. bhanu needs

"000999"  tobe "999"  not "00999"


On Mon, Apr 4, 2011 at 11:45 AM, §»VIPER«§  wrote:

> if your data in a1 type the below formula on anywhere in the same worksheet
> =IF(AND(ISTEXT(A1),LEFT(A1,1)="0"),RIGHT(A1,LEN(A1)-1),A1)
> --
> *Thanks & Regards
> Thamu
> *
>
>

-- 
--
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$$ excel help me

[Mangesh Vimay]

You can use left or right function by converting number to text..

On Jan 6, 2018 21:26, "Deepu Raj"  wrote:

> how to remove 1025 to 25 or 140 to 40 ie hundred and thousand removing
> using excel
>
> --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at https://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/d/optout.
>

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at https://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

$$Excel-Macros$$ Excel help : Remove Page Breaks Using VBA code

[Sundarvelan N]

Hello Friends,

Can anyone help me to remove Page Breaks in Excel sheets Using VBA code.

Thanks,
N.Sundarvelan

-- 
--
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

<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 6,800 subscribers worldwide and receive many nice notes about the 
learning and support from the group.Let friends and co-workers know they can 
subscribe to group at http://groups.google.com/group/excel-macros/subscribe

Re: $$Excel-Macros$$ Excel help : Remove Page Breaks Using VBA code

[siti Vi]

I think, removing VPageBreaks and HPageBreaks can be done
by setting  FitToPage /Wide/Tall properties to : 1

Sub ClearPgBreasks()
   With ActiveSheet.PageSetup
  .Zoom = False
  .FitToPagesWide = 1
  .FitToPagesTall = 1
   End With
End Sub


On May 12, 8:33 pm, Sundarvelan N  wrote:
> Hello Friends,
> Can anyone help me to remove Page Breaks in Excel sheets Using VBA code.
> Thanks,
> N.Sundarvelan

-- 
--
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

<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 6,800 subscribers worldwide and receive many nice notes about the 
learning and support from the group.Let friends and co-workers know they can 
subscribe to group at http://groups.google.com/group/excel-macros/subscribe

Re: $$Excel-Macros$$ Excel help : Remove Page Breaks Using VBA code

[Sundarvelan N]

Hi Siti,

Thanks for your reply,

But the below said is not working

Below is the recorded code for removing pagebreaks

ActiveSheet.VPageBreaks(1).DragOff Direction:=xlToRight, RegionIndex:=1

is any other code to remove page breaks

*I need to set the Page break to end of the used last column.*
**
*Please help me*

Thanks,
Sundarvelan

On Thu, May 13, 2010 at 6:56 AM, siti Vi  wrote:

> I think, removing VPageBreaks and HPageBreaks can be done
> by setting  FitToPage /Wide/Tall properties to : 1
>
> Sub ClearPgBreasks()
>   With ActiveSheet.PageSetup
>  .Zoom = False
>  .FitToPagesWide = 1
>  .FitToPagesTall = 1
>   End With
> End Sub
>
>
> On May 12, 8:33 pm, Sundarvelan N  wrote:
> > Hello Friends,
> > Can anyone help me to remove Page Breaks in Excel sheets Using VBA code.
> > Thanks,
> > N.Sundarvelan
>
> --
>
> --
> 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
>
> <><><><><><><><><><><><><><><><><><><><><><>
> HELP US GROW !!
>
> We reach over 6,800 subscribers worldwide and receive many nice notes about
> the learning and support from the group.Let friends and co-workers know they
> can subscribe to group at
> http://groups.google.com/group/excel-macros/subscribe
>



-- 
N.Sundarvelan

-- 
--
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

<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 6,800 subscribers worldwide and receive many nice notes about the 
learning and support from the group.Let friends and co-workers know they can 
subscribe to group at http://groups.google.com/group/excel-macros/subscribe

$$Excel-Macros$$ Excel Help - using value of one procedure into other

[Kasireddy Amarender]

Hi Team,

I would like to know if I can use the value of one procedure as input
to the other procedure.

For example:

I have a user form, it has two command buttons, the first one is
requesting for a file location(address/path) and the second does also
requesting another file  location (address/path).

And in my next procedure I would like to open the file which is stored
in my first command button, similarly would like to open second
command buttion file.

Here is the code I have...

Public Sub IButton_Click()

Dim IFileName As Variant
IFileName = Application.GetOpenFilename("Excel Files (*.xls),*.xls")

MsgBox IFileName

End Sub

Public Sub IIButton_Click()

Dim SFileName As Variant
SFileName = Application.GetOpenFilename("Excel Files (*.xls),*.xls")
MsgBox SFileName

End Sub


Public Sub StartButton_Click()

Workbooks.Open IFileName
Workbooks.Open SFileName

End Sub

Thanks in advance.

Best regards,
Amar

-- 
FORUM RULES (986+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

Re: $$Excel-Macros$$ Excel Help - using value of one procedure into other

[NOORAIN ANSARI]

Dear Amarender,

Please use it..

Public Sub Lfile_Name()
Dim IFileName As Variant
IFileName = Application.GetOpenFilename("Excel Files (*.xls),*.xls")
MsgBox IFileName
End Sub
Public Sub SFile_Name()
Dim SFileName As Variant
SFileName = Application.GetOpenFilename("Excel Files (*.xls),*.xls")
MsgBox SFileName
End Sub

Public Sub StartButton_Click()
On Error Resume Next
Call Lfile_Name
Workbooks.Open IFileName
Call SFile_Name
Workbooks.Open SFileName
End Sub


On Wed, Feb 8, 2012 at 1:49 PM, Kasireddy Amarender
wrote:

> Hi Team,
>
> I would like to know if I can use the value of one procedure as input
> to the other procedure.
>
> For example:
>
> I have a user form, it has two command buttons, the first one is
> requesting for a file location(address/path) and the second does also
> requesting another file  location (address/path).
>
> And in my next procedure I would like to open the file which is stored
> in my first command button, similarly would like to open second
> command buttion file.
>
> Here is the code I have...
>
> Public Sub IButton_Click()
>
> Dim IFileName As Variant
> IFileName = Application.GetOpenFilename("Excel Files (*.xls),*.xls")
>
> MsgBox IFileName
>
> End Sub
>
> Public Sub IIButton_Click()
>
> Dim SFileName As Variant
> SFileName = Application.GetOpenFilename("Excel Files (*.xls),*.xls")
> MsgBox SFileName
>
> End Sub
>
>
> Public Sub StartButton_Click()
>
> Workbooks.Open IFileName
> Workbooks.Open SFileName
>
> End Sub
>
> Thanks in advance.
>
> Best regards,
> Amar
>
> --
> FORUM RULES (986+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5)  Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE  : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>



-- 
Thanks & regards,
Noorain Ansari
 *http://noorainansari.com/* 
*http://excelmacroworld.blogspot.com/*

-- 
FORUM RULES (986+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

Re: $$Excel-Macros$$ Excel Help - using value of one procedure into other

[Kasireddy Amarender]

Thanks Noorain!

Simple and Superb!

On 08/02/2012, NOORAIN ANSARI  wrote:
> Dear Amarender,
>
> Please use it..
>
> Public Sub Lfile_Name()
> Dim IFileName As Variant
> IFileName = Application.GetOpenFilename("Excel Files (*.xls),*.xls")
> MsgBox IFileName
> End Sub
> Public Sub SFile_Name()
> Dim SFileName As Variant
> SFileName = Application.GetOpenFilename("Excel Files (*.xls),*.xls")
> MsgBox SFileName
> End Sub
>
> Public Sub StartButton_Click()
> On Error Resume Next
> Call Lfile_Name
> Workbooks.Open IFileName
> Call SFile_Name
> Workbooks.Open SFileName
> End Sub
>
>
> On Wed, Feb 8, 2012 at 1:49 PM, Kasireddy Amarender
> wrote:
>
>> Hi Team,
>>
>> I would like to know if I can use the value of one procedure as input
>> to the other procedure.
>>
>> For example:
>>
>> I have a user form, it has two command buttons, the first one is
>> requesting for a file location(address/path) and the second does also
>> requesting another file  location (address/path).
>>
>> And in my next procedure I would like to open the file which is stored
>> in my first command button, similarly would like to open second
>> command buttion file.
>>
>> Here is the code I have...
>>
>> Public Sub IButton_Click()
>>
>> Dim IFileName As Variant
>> IFileName = Application.GetOpenFilename("Excel Files (*.xls),*.xls")
>>
>> MsgBox IFileName
>>
>> End Sub
>>
>> Public Sub IIButton_Click()
>>
>> Dim SFileName As Variant
>> SFileName = Application.GetOpenFilename("Excel Files (*.xls),*.xls")
>> MsgBox SFileName
>>
>> End Sub
>>
>>
>> Public Sub StartButton_Click()
>>
>> Workbooks.Open IFileName
>> Workbooks.Open SFileName
>>
>> End Sub
>>
>> Thanks in advance.
>>
>> Best regards,
>> Amar
>>
>> --
>> FORUM RULES (986+ members already BANNED for violation)
>>
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>> will not get quick attention or may not be answered.
>>
>> 2) Don't post a question in the thread of another member.
>>
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>>
>> 4) Acknowledge the responses you receive, good or bad.
>>
>> 5)  Cross-promotion of, or links to, forums competitive to this forum in
>> signatures are prohibited.
>>
>> NOTE  : Don't ever post personal or confidential data in a workbook. Forum
>> owners and members are not responsible for any loss.
>>
>>
>> --
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>
>
>
> --
> Thanks & regards,
> Noorain Ansari
>  *http://noorainansari.com/* 
> *http://excelmacroworld.blogspot.com/*
>
> --
> FORUM RULES (986+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will
> not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5)  Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE  : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>

-- 
FORUM RULES (986+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

Re: $$Excel-Macros$$ Excel Help - using value of one procedure into other

[Kasireddy Amarender]

Hi Noorain,

I'm getting error ... Can you please try your code and check?

thanks,
Amar

On 08/02/2012, Kasireddy Amarender  wrote:
> Thanks Noorain!
>
> Simple and Superb!
>
> On 08/02/2012, NOORAIN ANSARI  wrote:
>> Dear Amarender,
>>
>> Please use it..
>>
>> Public Sub Lfile_Name()
>> Dim IFileName As Variant
>> IFileName = Application.GetOpenFilename("Excel Files (*.xls),*.xls")
>> MsgBox IFileName
>> End Sub
>> Public Sub SFile_Name()
>> Dim SFileName As Variant
>> SFileName = Application.GetOpenFilename("Excel Files (*.xls),*.xls")
>> MsgBox SFileName
>> End Sub
>>
>> Public Sub StartButton_Click()
>> On Error Resume Next
>> Call Lfile_Name
>> Workbooks.Open IFileName
>> Call SFile_Name
>> Workbooks.Open SFileName
>> End Sub
>>
>>
>> On Wed, Feb 8, 2012 at 1:49 PM, Kasireddy Amarender
>> wrote:
>>
>>> Hi Team,
>>>
>>> I would like to know if I can use the value of one procedure as input
>>> to the other procedure.
>>>
>>> For example:
>>>
>>> I have a user form, it has two command buttons, the first one is
>>> requesting for a file location(address/path) and the second does also
>>> requesting another file  location (address/path).
>>>
>>> And in my next procedure I would like to open the file which is stored
>>> in my first command button, similarly would like to open second
>>> command buttion file.
>>>
>>> Here is the code I have...
>>>
>>> Public Sub IButton_Click()
>>>
>>> Dim IFileName As Variant
>>> IFileName = Application.GetOpenFilename("Excel Files (*.xls),*.xls")
>>>
>>> MsgBox IFileName
>>>
>>> End Sub
>>>
>>> Public Sub IIButton_Click()
>>>
>>> Dim SFileName As Variant
>>> SFileName = Application.GetOpenFilename("Excel Files (*.xls),*.xls")
>>> MsgBox SFileName
>>>
>>> End Sub
>>>
>>>
>>> Public Sub StartButton_Click()
>>>
>>> Workbooks.Open IFileName
>>> Workbooks.Open SFileName
>>>
>>> End Sub
>>>
>>> Thanks in advance.
>>>
>>> Best regards,
>>> Amar
>>>
>>> --
>>> FORUM RULES (986+ members already BANNED for violation)
>>>
>>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>>> will not get quick attention or may not be answered.
>>>
>>> 2) Don't post a question in the thread of another member.
>>>
>>> 3) Don't post questions regarding breaking or bypassing any security
>>> measure.
>>>
>>> 4) Acknowledge the responses you receive, good or bad.
>>>
>>> 5)  Cross-promotion of, or links to, forums competitive to this forum in
>>> signatures are prohibited.
>>>
>>> NOTE  : Don't ever post personal or confidential data in a workbook.
>>> Forum
>>> owners and members are not responsible for any loss.
>>>
>>>
>>> --
>>> To post to this group, send email to excel-macros@googlegroups.com
>>>
>>
>>
>>
>> --
>> Thanks & regards,
>> Noorain Ansari
>>  *http://noorainansari.com/* 
>> *http://excelmacroworld.blogspot.com/*
>>
>> --
>> FORUM RULES (986+ members already BANNED for violation)
>>
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>> will
>> not get quick attention or may not be answered.
>>
>> 2) Don't post a question in the thread of another member.
>>
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>>
>> 4) Acknowledge the responses you receive, good or bad.
>>
>> 5)  Cross-promotion of, or links to, forums competitive to this forum in
>> signatures are prohibited.
>>
>> NOTE  : Don't ever post personal or confidential data in a workbook.
>> Forum
>> owners and members are not responsible for any loss.
>>
>> --
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>

-- 
FORUM RULES (986+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

Re: $$Excel-Macros$$ Excel Help - using value of one procedure into other

[Kris]

Hi
 
Have you tred mine ?
 
 

-- 
FORUM RULES (986+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

Re: $$Excel-Macros$$ Excel Help - using value of one procedure into other

[Kasireddy Amarender]

Hi Kris,

I don't have your code, Can you please forward?

Thanks,
Amar

On 09/02/2012, Kris  wrote:
> Hi
>
> Have you tred mine ?
>
>
>
> --
> FORUM RULES (986+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will
> not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5)  Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE  : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>

-- 
FORUM RULES (986+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

Re: $$Excel-Macros$$ Excel Help - using value of one procedure into other

[NOORAIN ANSARI]

Dear Amar,

Use below code with little bit correction in red color
This code has been modify as per Krish's solution.

Hope it will help to you
See attached sheet...

Dim IFileName As Variant
Dim SFileName As Variant
Public Sub Lfile_Name()
 IFileName = Application.GetOpenFilename("Excel Files (*.xls),*.xls")
MsgBox IFileName
End Sub
Public Sub SFile_Name()
 SFileName = Application.GetOpenFilename("Excel Files (*.xls),*.xls")
MsgBox SFileName
End Sub

Public Sub StartButton_Click()
On Error Resume Next
Call Lfile_Name
Workbooks.Open IFileName
Call SFile_Name
Workbooks.Open SFileName
End Sub


On Wed, Feb 8, 2012 at 2:11 PM, NOORAIN ANSARI wrote:

> Dear Amarender,
>
> Please use it..
>
> Public Sub Lfile_Name()
>  Dim IFileName As Variant
> IFileName = Application.GetOpenFilename("Excel Files (*.xls),*.xls")
> MsgBox IFileName
> End Sub
> Public Sub SFile_Name()
>  Dim SFileName As Variant
> SFileName = Application.GetOpenFilename("Excel Files (*.xls),*.xls")
> MsgBox SFileName
> End Sub
>
> Public Sub StartButton_Click()
> On Error Resume Next
> Call Lfile_Name
> Workbooks.Open IFileName
> Call SFile_Name
> Workbooks.Open SFileName
> End Sub
>
>
>  On Wed, Feb 8, 2012 at 1:49 PM, Kasireddy Amarender <
> kassi.re...@gmail.com> wrote:
>
>> Hi Team,
>>
>> I would like to know if I can use the value of one procedure as input
>> to the other procedure.
>>
>> For example:
>>
>> I have a user form, it has two command buttons, the first one is
>> requesting for a file location(address/path) and the second does also
>> requesting another file  location (address/path).
>>
>> And in my next procedure I would like to open the file which is stored
>> in my first command button, similarly would like to open second
>> command buttion file.
>>
>> Here is the code I have...
>>
>> Public Sub IButton_Click()
>>
>> Dim IFileName As Variant
>> IFileName = Application.GetOpenFilename("Excel Files (*.xls),*.xls")
>>
>> MsgBox IFileName
>>
>> End Sub
>>
>> Public Sub IIButton_Click()
>>
>> Dim SFileName As Variant
>> SFileName = Application.GetOpenFilename("Excel Files (*.xls),*.xls")
>> MsgBox SFileName
>>
>> End Sub
>>
>>
>> Public Sub StartButton_Click()
>>
>> Workbooks.Open IFileName
>> Workbooks.Open SFileName
>>
>> End Sub
>>
>> Thanks in advance.
>>
>> Best regards,
>> Amar
>>
>> --
>> FORUM RULES (986+ members already BANNED for violation)
>>
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>> will not get quick attention or may not be answered.
>>
>> 2) Don't post a question in the thread of another member.
>>
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>>
>> 4) Acknowledge the responses you receive, good or bad.
>>
>> 5)  Cross-promotion of, or links to, forums competitive to this forum in
>> signatures are prohibited.
>>
>> NOTE  : Don't ever post personal or confidential data in a workbook.
>> Forum owners and members are not responsible for any loss.
>>
>>
>> --
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>
>
>
> --
> Thanks & regards,
> Noorain Ansari
>  *http://noorainansari.com/* 
> *http://excelmacroworld.blogspot.com/*
>
>
>


-- 
Thanks & regards,
Noorain Ansari
 *http://noorainansari.com/* 
*http://excelmacroworld.blogspot.com/*

-- 
FORUM RULES (986+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com


Sample_Workbook(Amar).xlsm
Description: Binary data

$$Excel-Macros$$ Excel Help needed - To convert date format in to Decimal Min

[satish]

Hi all,

I have the data in below format, I try to convert the date format in
to decimal Minutes. It comes well when the data below 24 Hrs, as soon
as it exceed 24 Hrs, it gives a wrong fig.

I used the below formula to get answers

=HOUR(G91)*60+MINUTE(G91)+SECOND(G91)/60

gprs - national -   26:48:21168.3500 - Wrong
gprs - national 25:15:4718. - Wrong
gprs - national 21:23:051283.0833 - Correct
to other uk mobile operators19:50:071190.1167 - Correct
to other uk mobile operators14:35:19875.3167 - Correct
gprs - national 11:28:10688.1667 - Correct


Thanks for help

Rgds

Kumar

-- 
FORUM RULES (986+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

Re: $$Excel-Macros$$ Excel Help needed - To convert date format in to Decimal Min

[Sam Mathai Chacko]

*=G91*1440*

Regards,

Sam Mathai Chacko



On Fri, Feb 24, 2012 at 4:53 PM, satish
wrote:

> Hi all,
>
> I have the data in below format, I try to convert the date format in
> to decimal Minutes. It comes well when the data below 24 Hrs, as soon
> as it exceed 24 Hrs, it gives a wrong fig.
>
> I used the below formula to get answers
>
> =HOUR(G91)*60+MINUTE(G91)+SECOND(G91)/60
>
> gprs - national -   26:48:21168.3500 - Wrong
> gprs - national 25:15:4718. - Wrong
> gprs - national 21:23:051283.0833 - Correct
> to other uk mobile operators19:50:071190.1167 - Correct
> to other uk mobile operators14:35:19875.3167 - Correct
> gprs - national 11:28:10688.1667 - Correct
>
>
> Thanks for help
>
> Rgds
>
> Kumar
>
> --
> FORUM RULES (986+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5)  Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE  : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>



-- 
Sam Mathai Chacko

-- 
FORUM RULES (986+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

Re: $$Excel-Macros$$ Excel Help needed - To convert date format in to Decimal Min

[Sam Mathai Chacko]

If you insist on using your original formula, try a more lengthier

*=QUOTIENT(G91,1)*1440+HOUR(**G9**1)*60+MINUTE(**G9**1)+SECOND(**G9**1)/60*

But *=G91*1440 will give the same answer*

Regards,
Sam Mathai Chacko

On Fri, Feb 24, 2012 at 10:19 PM, Sam Mathai Chacko wrote:

> *=G91*1440*
>
> Regards,
>
> Sam Mathai Chacko
>
>
>
>
> On Fri, Feb 24, 2012 at 4:53 PM, satish  > wrote:
>
>> Hi all,
>>
>> I have the data in below format, I try to convert the date format in
>> to decimal Minutes. It comes well when the data below 24 Hrs, as soon
>> as it exceed 24 Hrs, it gives a wrong fig.
>>
>> I used the below formula to get answers
>>
>> =HOUR(G91)*60+MINUTE(G91)+SECOND(G91)/60
>>
>> gprs - national -   26:48:21168.3500 - Wrong
>> gprs - national 25:15:4718. - Wrong
>> gprs - national 21:23:051283.0833 - Correct
>> to other uk mobile operators19:50:071190.1167 - Correct
>> to other uk mobile operators14:35:19875.3167 - Correct
>> gprs - national 11:28:10688.1667 - Correct
>>
>>
>> Thanks for help
>>
>> Rgds
>>
>> Kumar
>>
>> --
>> FORUM RULES (986+ members already BANNED for violation)
>>
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>> will not get quick attention or may not be answered.
>>
>> 2) Don't post a question in the thread of another member.
>>
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>>
>> 4) Acknowledge the responses you receive, good or bad.
>>
>> 5)  Cross-promotion of, or links to, forums competitive to this forum in
>> signatures are prohibited.
>>
>> NOTE  : Don't ever post personal or confidential data in a workbook.
>> Forum owners and members are not responsible for any loss.
>>
>>
>> --
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>
>
>
> --
> Sam Mathai Chacko
>



-- 
Sam Mathai Chacko

-- 
FORUM RULES (986+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com