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

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

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 tarunmondal1...@gmail.comwrote:

 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

$$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
narbhaviwithsatishku...@gmail.comwrote:

 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 samde...@gmail.comwrote:

 *=G91*1440*

 Regards,

 Sam Mathai Chacko




 On Fri, Feb 24, 2012 at 4:53 PM, satish narbhaviwithsatishku...@gmail.com
  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

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 krishnak...@gmail.com 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 noorain.ans...@gmail.comwrote:

 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/
 *http://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/





-- 
Thanks  regards,
Noorain Ansari
 *http://noorainansari.com/* http://excelmacroworld.blogspot.com/
*http://excelmacroworld.blogspot.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 - 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
kassi.re...@gmail.comwrote:

 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/
*http://excelmacroworld.blogspot.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]

Hi Noorain,

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

thanks,
Amar

On 08/02/2012, Kasireddy Amarender kassi.re...@gmail.com wrote:
 Thanks Noorain!

 Simple and Superb!

 On 08/02/2012, NOORAIN ANSARI noorain.ans...@gmail.com 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.comwrote:

 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/
 *http://excelmacroworld.blogspot.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

[STDEV(i)]

i think  mr. bhanu needs

000999  tobe 999  not 00999


On Mon, Apr 4, 2011 at 11:45 AM, §»VIPER«§ viper@gmail.com 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

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

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 bhanu...@gmail.com 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 bhanu...@gmail.com

 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 bhanu...@gmail.com 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 bhanu...@gmail.com 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 bhanu...@gmail.com 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) setiyowati.d...@gmail.com 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 bhanu...@gmail.com 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

[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 bhanu...@gmail.com 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) setiyowati.d...@gmail.com 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

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

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 preeti86v...@gmail.com 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

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

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 villager.g...@gmail.com 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 nsund...@gmail.com 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 : 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 nsund...@gmail.com 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

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

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 shivyn...@gmail.com 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

[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

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

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

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 karthikeyansankar...@gmail.com 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

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

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

[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

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