date:20140404

$$Excel-Macros$$ Re: How to define the uppercase, lowercase and proper()

2014-04-04 Thread Falina Gan

To Whom It May Concern,

In VBA please. thanks.

On Saturday, April 5, 2014 1:38:03 PM UTC+8, Falina Gan wrote:
>
> To Whom It May Concern,
>
> We would like to know if we are creating a column for uppercase, lowercase 
> and initial case like the image as below:
>
>
> 
>
>
> Hope to hear from you soon.
>
> Thanks.
>

-- 
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 http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

$$Excel-Macros$$ How to define the uppercase, lowercase and proper()

2014-04-04 Thread Falina Gan

To Whom It May Concern,

We would like to know if we are creating a column for uppercase, lowercase 
and initial case like the image as below:




Hope to hear from you soon.

Thanks.

-- 
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 http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

$$Excel-Macros$$ Delete button on Sequence Column

2014-04-04 Thread Falina Gan

To Whom It May Concern,

Could you guide me with VBA codes, on these steps:-

1) Create a sequence column as image below ( all in alphabets )
2) Delete button to delete the sequence column
3) Then the pattern column is in "A" column. ( refer to your right side )

Hope to hear from you. Thanks


  
 

-- 
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 http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

$$Excel-Macros$$ Re: How to identify which is text, integers, date, time in a table?

2014-04-04 Thread Falina Gan

Thanks Basole,

The codes are running well but can I ask from your codes for my 
understanding as a learner. Could you explain as below:-

1)   z = sheet1.Range("a1").Offset(sheet1.Rows.Count - 1, 0).End(xlUp).Row 

2)  Set cl = .Cells(i, 1)

3) Case IsEmpty(cl)
Case InStr(cl.NumberFormat, ":mm") > 0
Range("e" & sheet1.Range("e1").Offset(sheet1.Rows.Count - 
1, 0).End(xlUp).Row + 1) = cl

4) Range("c" & sheet1.Range("c1").Offset(sheet1.Rows.Count - 1, 
0).End(xlUp).Row + 1) = cl

5) If a user key in a data, for example, today's date, does it affect the 
codes as well?

Hope to hear from your good solutions.

On Friday, April 4, 2014 11:41:19 PM UTC+8, Falina Gan wrote:
>
> To Whom It May Concern,
>
> May I ask, how to you create a vba to identify whether the text or integer 
> or date or time in a table such as:-
>
> Thanks.
>
>

-- 
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 http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

Re: $$Excel-Macros$$ Re: Need help for repetative formatting - Repair my code

2014-04-04 Thread Suyog Kulkarni

Hi Basole,

It's working fine now following are the only problems remaining.
1. While creating macro, I have assigned "ctrl+q" shortcut which is not 
working now
2. How can we save the code as "Add In" or can we add any buttom in 
existing toolbar ? so I that I can share the same with my co-workers.

I can't see, save as option in vba window. Pl help.
Thanks to all group members, because of you all I made this code. 

With Regards,
Suyog

*Below is the modified code. *

Sub ReportWriter()
' Format Macro
'
' Keyboard Shortcut: Ctrl+q
'
' This lines are two fill white color
Cells.Select
With Selection.Interior
.Pattern = xlSolid
.PatternColorIndex = xlAutomatic
.ThemeColor = xlThemeColorDark1
.TintAndShade = 0
.PatternTintAndShade = 0
End With

' This is range for Report Headings
Range("A1:I4").Select
Selection.ClearContents
With Selection
.HorizontalAlignment = xlCenter
.VerticalAlignment = xlCenter
End With
Selection.Merge
   
' This is range for Report Header Line
Range("A5:I5").Select
With Selection.Interior
.Color = 13434879
Selection.Font.Bold = True
End With
   
' This is "total non blank area of any report. Or Cell range with Text/value
x = Cells(Rows.Count, "A").End(xlUp).Row
y = Cells(x, Columns.Count).End(xlToLeft).Column
Range("A1:" & Cells(x, y).Address).Select
With Selection.Borders
.LineStyle = xlContinuous
.Weight = xlThin
End With
Cells.Select
With Selection.Interior
Selection.Font.Name = "Calibri"
Selection.Font.Size = 11
Selection.Font.ThemeFont = xlThemeFontMinor
End With
Cells.Select
Selection.Columns.AutoFit
With Selection
.VerticalAlignment = xlCenter
.HorizontalAlignment = xlCenter
.VerticalAlignment = xlCenter
End With
Range("A5").Select
ActiveWorkbook.Save
MsgBox "Formatting is done. Only add project details properly.", 
vbOKOnly, "Code by Suyog Kulkarni"
End Sub
 



On Saturday, 5 April 2014 02:32:12 UTC+5:30, Basole wrote:
>
> Hi, try this:
>
> x = Cells(Rows.Count, "A").End(xlUp).Row
> y = Cells(x, Columns.Count).End(xlToLeft).Column
> Range("A1:" & Cells(x, y).Address).Select
>
>
> Regards,
>
> Basole.
>
>
>
>
>
>
> 2014-04-04 11:17 GMT-03:00 Suyog Kulkarni 
> >:
>
>> Hello All,
>>
>> I made my first macro code. Kindly review. Now only problem remain is 
>> instead of *Range("A1:I100"), I want excel to choose "last row & last 
>> column" which contain text/value.*
>>
>> PL help.
>>
>> Regards,
>> Suyog
>>
>> " Below is my code"
>>
>> *Sub Format()*
>>
>> ' Format Macro
>> ' Keyboard Shortcut: Ctrl+q
>> ' This is range for Report Headings
>> Range("A1:I4").Select
>> Selection.ClearContents
>> With Selection
>> .HorizontalAlignment = xlCenter
>> .VerticalAlignment = xlCenter
>> End With
>> Selection.Merge
>> 
>> ' This is range for Report Header Line
>> Range("A5:I5").Select
>> With Selection.Interior
>> .Color = 13434879
>> Selection.Font.Bold = True
>> End With
>> 
>> ' This is "total non blank area of any report. Or Cell range with 
>> Text/value 
>> *Range("A1:I100").Select*
>> With Selection.Borders
>> .LineStyle = xlContinuous
>> .Weight = xlThin
>> End With
>> Cells.Select
>> With Selection.Interior
>> Selection.Font.Name = "Calibri"
>> Selection.Font.Size = 11
>> Selection.Font.ThemeFont = xlThemeFontMinor
>> End With
>> Cells.Select
>> Selection.Columns.AutoFit
>> With Selection
>> .VerticalAlignment = xlCenter
>> .HorizontalAlignment = xlCenter
>> .VerticalAlignment = xlCenter
>> End With
>> Range("A5").Select
>> ActiveWorkbook.Save
>> MsgBox "Formatting is done. Only add project details properly.", 
>> vbOKOnly, "Made by Suyog Kulkarni"
>> *End Sub*
>>
>>
>>
>>
>>
>> On Friday, 4 April 2014 15:11:52 UTC+5:30, Suyog Kulkarni wrote:
>>>
>>> Hello All,
>>>
>>> Refer attached excel, I've tried to develop macro using recording for 
>>> repetitive formatting. Now my problem is how can I assign range for all 
>>> "Non-blank" cell. Because my current will work only upto "Row 13 & Column 
>>> I". 
>>>
>>> How can assign the code which can work till last row & column which 
>>> contain text / value. Short cut for macro is Ctrl+q. I need this to improve 
>>> productivity & you all can save my lot of time. I generate daily more than 
>>> 50 reports of 100+ rows. This formatting takes time. 
>>>
>>> Regards,
>>> Suyog
>>>
>>  -- 
>> 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 @ 
>> htt

$$Excel-Macros$$ Compare two worksheet Trial Balance

2014-04-04 Thread Sandeep Kumar Chhajer

Dear Excel gurus,

Every day I have to compare two identical formatted worksheet trial balance. I 
want macro to compare both the trial balance.
Macro should work as below:
It will give me an option to choose which two workbook contains (workbook only 
contains one worksheet containing trial balance).
Both Work book contains data like below: 
TB 1st April
G/L code.  Amount
10005632.   -100
20004128.  50
30008721. -50
40007214. 100

TB 2nd April
G/L code.  Amount
10005632.   -100
10009841. -10
20004128.  60
30008721. -50
40007214. 100

I used to compare both the sheet with vlookup and prepare report like below

Changes in TB
G/L code.   Amount.  Mode 
  Change
10009841.  -10.   New code
20004128.10.  Change in amount

(sorry for reason of confidentiality I can't share file with you all. I hope 
you all understand)

If any one can help me out to automate the report I will be highly grateful.

Thanks in advance.
 
Thanks & Regards,
Sandeep Kumar Chhajer
Mumbai
India 

Sent on my BlackBerry(R) from Vodafone

-- 
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 http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

Re: $$Excel-Macros$$

2014-04-04 Thread Ricardo®

Below attached my suggestions:

1 - A small application (A-PDF Text Extractor) to convert pdf to txt.
2 - Macro that imports the file (M & M Price list.txt) to excel.


https://www.dropbox.com/s/y0xtlhgjbjgy0qb/Files.rar

Regards,

Basole.





2014-04-04 6:37 GMT-03:00 Neeraj Chauhan :

>  Dear ,
>
>
>
> Given information sites are not working.
>
>
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On Behalf Of *Kuldeep Singh
> *Sent:* Friday, April 04, 2014 2:31 PM
> *To:* excel-macros@googlegroups.com
> *Subject:* Re: $$Excel-Macros$$
>
>
>
>
>
> http://www.doc2pdf.net/Excel2PDF/
>
> http://www.pdftoexcel.org/
>
> http://www..pdfconverter.com/pdf-to-excel-online-free/
>
> https://www.pdftoexcelonline.com/
>
>
>
> On Fri, Apr 4, 2014 at 2:27 PM, Neeraj Chauhan 
> wrote:
>
>
>
> Dear expert,
>
>
>
> I want to convert from PDF to Excel we have some more attachment
>
>
>
> Kindly provide any softerware to convert.
>
>
>
>
>
> [image: Description: Description: image001]
>
> *Neeraj Chauhan*
>
> *+91-9756706350 <%2B91-9756706350>*
>
>
>
>
>  --
>
> 
>
> This email is free from viruses and malware because avast! 
> Antivirusprotection is active.
>
>
>
> --
> 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 http://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/d/optout.
>
>
>
>
>
> --
>
> Regards,
>
> Kuldeep Singh
>
> Assistant Manager Quality
>
> Game Zone India Limited
>
> Phone.: +91-8586978644
> || naukrikuld...@gmail.com ||
> *Please* *Consider the environment. Please don't print this e-mail unless
> you really need to.*
>
> --
> 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 
> http://groups.google..com/group/excel-macros
> .
>
> For more options, visit https://groups.google.com/d/optout.
>
>
>
> --
>
>
> This email is free from viruses and malware because avast! 
> Antivirusprotection is active.
>
>  --
> 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.

Re: $$Excel-Macros$$ Copy Data from next Column and Repeat Paste as per the Values

2014-04-04 Thread Bipin Singh

Rashid Sir,

I have made some changes. Now you can change your input column to any
column in the sheet and output will be 3 column forward and 1 row down from
the input data.. If you require data in different column other then this
then change offset value as per your requirement inside the loop.

Also please ensure that you data should always start from first row i.e. in
first row headings and then required data.


Hope this helps.

Regards,



On Thu, Apr 3, 2014 at 6:40 PM, prkhan56  wrote:

> Hello Vicky,
> Your solution works as per the current set of Data. (Col G & H for input)
> & (Col L & M for output)
> I was looking for a solution which should work for any two adjacent
> columns.
> Is that possible?
> I will run the macro from say Values in Col A then it should work for Cols
> A and B...if Col S then it should work for Col S and T...
> The output, if required can be on a new sheet
> Thanks for your time and help
>
>
> On Thursday, April 3, 2014 12:03:07 AM UTC+4, Vicky wrote:
>
>> Rashid Sir, Hope attached will help?
>>
>>
>> On Wed, Apr 2, 2014 at 4:39 PM, Rashid Khan  wrote:
>>
>>> Dear All,
>>> I am using Excel 2010.
>>> I have attached a sample file with my problem.
>>> Please see before and after
>>>
>>> Any macro help would be appreciate.
>>> Regards
>>> Rashid
>>>
>>> --
>>> 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...@googlegroups.com.
>>> To post to this group, send email to excel-...@googlegroups.com.
>>>
>>> Visit this group at http://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 http://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-ma

Re: $$Excel-Macros$$ Re: Need help for repetative formatting - Repair my code

2014-04-04 Thread Ricardo®

Hi, try this:

x = Cells(Rows.Count, "A").End(xlUp).Row
y = Cells(x, Columns.Count).End(xlToLeft).Column
Range("A1:" & Cells(x, y).Address).Select


Regards,

Basole.






2014-04-04 11:17 GMT-03:00 Suyog Kulkarni :

> Hello All,
>
> I made my first macro code. Kindly review. Now only problem remain is
> instead of *Range("A1:I100"), I want excel to choose "last row & last
> column" which contain text/value.*
>
> PL help.
>
> Regards,
> Suyog
>
> " Below is my code"
>
> *Sub Format()*
>
> ' Format Macro
> ' Keyboard Shortcut: Ctrl+q
> ' This is range for Report Headings
> Range("A1:I4").Select
> Selection.ClearContents
> With Selection
> .HorizontalAlignment = xlCenter
> .VerticalAlignment = xlCenter
> End With
> Selection.Merge
>
> ' This is range for Report Header Line
> Range("A5:I5").Select
> With Selection.Interior
> .Color = 13434879
> Selection.Font.Bold = True
> End With
>
> ' This is "total non blank area of any report. Or Cell range with
> Text/value
> *Range("A1:I100").Select*
> With Selection.Borders
> .LineStyle = xlContinuous
> .Weight = xlThin
> End With
> Cells.Select
> With Selection.Interior
> Selection.Font.Name = "Calibri"
> Selection.Font.Size = 11
> Selection.Font.ThemeFont = xlThemeFontMinor
> End With
> Cells.Select
> Selection.Columns.AutoFit
> With Selection
> .VerticalAlignment = xlCenter
> .HorizontalAlignment = xlCenter
> .VerticalAlignment = xlCenter
> End With
> Range("A5").Select
> ActiveWorkbook.Save
> MsgBox "Formatting is done. Only add project details properly.",
> vbOKOnly, "Made by Suyog Kulkarni"
> *End Sub*
>
>
>
>
>
> On Friday, 4 April 2014 15:11:52 UTC+5:30, Suyog Kulkarni wrote:
>>
>> Hello All,
>>
>> Refer attached excel, I've tried to develop macro using recording for
>> repetitive formatting. Now my problem is how can I assign range for all
>> "Non-blank" cell. Because my current will work only upto "Row 13 & Column
>> I".
>>
>> How can assign the code which can work till last row & column which
>> contain text / value. Short cut for macro is Ctrl+q. I need this to improve
>> productivity & you all can save my lot of time. I generate daily more than
>> 50 reports of 100+ rows. This formatting takes time.
>>
>> Regards,
>> Suyog
>>
>  --
> 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 http://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 http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

$$Excel-Macros$$ How to identify which is text, integers, date, time in a table?

2014-04-04 Thread Falina Gan



To Whom It May Concern,

May I ask, how to you create a vba to identify whether the text or integer 
or date or time in a table such as:-

Thanks.

-- 
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 http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

$$Excel-Macros$$ Re: Need help for repetative formatting - Repair my code

2014-04-04 Thread Suyog Kulkarni

Hello All,

I made my first macro code. Kindly review. Now only problem remain is 
instead of *Range("A1:I100"), I want excel to choose "last row & last 
column" which contain text/value.*

PL help.

Regards,
Suyog

" Below is my code"

*Sub Format()*

' Format Macro
' Keyboard Shortcut: Ctrl+q
' This is range for Report Headings
Range("A1:I4").Select
Selection.ClearContents
With Selection
.HorizontalAlignment = xlCenter
.VerticalAlignment = xlCenter
End With
Selection.Merge

' This is range for Report Header Line
Range("A5:I5").Select
With Selection.Interior
.Color = 13434879
Selection.Font.Bold = True
End With

' This is "total non blank area of any report. Or Cell range with 
Text/value 
*Range("A1:I100").Select*
With Selection.Borders
.LineStyle = xlContinuous
.Weight = xlThin
End With
Cells.Select
With Selection.Interior
Selection.Font.Name = "Calibri"
Selection.Font.Size = 11
Selection.Font.ThemeFont = xlThemeFontMinor
End With
Cells.Select
Selection.Columns.AutoFit
With Selection
.VerticalAlignment = xlCenter
.HorizontalAlignment = xlCenter
.VerticalAlignment = xlCenter
End With
Range("A5").Select
ActiveWorkbook.Save
MsgBox "Formatting is done. Only add project details properly.", 
vbOKOnly, "Made by Suyog Kulkarni"
*End Sub*

On Friday, 4 April 2014 15:11:52 UTC+5:30, Suyog Kulkarni wrote:
>
> Hello All,
>
> Refer attached excel, I've tried to develop macro using recording for 
> repetitive formatting. Now my problem is how can I assign range for all 
> "Non-blank" cell. Because my current will work only upto "Row 13 & Column 
> I". 
>
> How can assign the code which can work till last row & column which 
> contain text / value. Short cut for macro is Ctrl+q. I need this to improve 
> productivity & you all can save my lot of time. I generate daily more than 
> 50 reports of 100+ rows. This formatting takes time. 
>
> Regards,
> Suyog
>

-- 
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 http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

$$Excel-Macros$$ Re: Need help for repetative formatting - Repair my code

2014-04-04 Thread Suyog Kulkarni

Hello All,

I made my first macro code. Kindly review. Now only problem remain is 
instead of *Range("A1:I100"), I want excel to choose "last row & last 
column" which contain text/value.*

PL help.

Regards,
Suyog

" Below is my code"

*Sub Format()*

' Format Macro
' Keyboard Shortcut: Ctrl+q
' This is range for Report Headings
Range("A1:I4").Select
Selection.ClearContents
With Selection
.HorizontalAlignment = xlCenter
.VerticalAlignment = xlCenter
End With
Selection.Merge

' This is range for Report Header Line
Range("A5:I5").Select
With Selection.Interior
.Color = 13434879
Selection.Font.Bold = True
End With

' This is "total non blank area of any report. Or Cell range with 
Text/value 
*Range("A1:I100").Select*
With Selection.Borders
.LineStyle = xlContinuous
.Weight = xlThin
End With
Cells.Select
With Selection.Interior
Selection.Font.Name = "Calibri"
Selection.Font.Size = 11
Selection.Font.ThemeFont = xlThemeFontMinor
End With
Cells.Select
Selection.Columns.AutoFit
With Selection
.VerticalAlignment = xlCenter
.HorizontalAlignment = xlCenter
.VerticalAlignment = xlCenter
End With
Range("A5").Select
ActiveWorkbook.Save
MsgBox "Formatting is done. Only add project details properly.", 
vbOKOnly, "Made by Suyog Kulkarni"
*End Sub*

On Friday, 4 April 2014 15:11:52 UTC+5:30, Suyog Kulkarni wrote:
>
> Hello All,
>
> Refer attached excel, I've tried to develop macro using recording for 
> repetitive formatting. Now my problem is how can I assign range for all 
> "Non-blank" cell. Because my current will work only upto "Row 13 & Column 
> I". 
>
> How can assign the code which can work till last row & column which 
> contain text / value. Short cut for macro is Ctrl+q. I need this to improve 
> productivity & you all can save my lot of time. I generate daily more than 
> 50 reports of 100+ rows. This formatting takes time. 
>
> Regards,
> Suyog
>

-- 
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 http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

$$Excel-Macros$$ Coordinating questions for today's Q&A with the Excel Developers. Let's ask for VBA!

2014-04-04 Thread pcuaron

Hello! Today there's a Q&A with the Excel developers in Reddit (Friday, 
April 4 at 1:00pm PDT/4:00pm EDT on reddit). We don't usually have a chance 
to give feedback since the Microsoft Connect initiative doesn't contemplate 
Office, and they won't even take bug reports from users; their attention is 
mostly on the big corporate users and no the analysts. So I though we 
should try to coordinate some questions about the worst parts of Excel. 
Here's what I think are the things that need the most attention, presented 
as questions for the Excel Dev team:

*1. When will you update the 20 years old VBA Editor to something more 
modern? *The need for VBA won’t go again even if you ignore it!

*2. When do you plan to improve the scripting tools, adding things like 
modern .net operators, string and table methods, etc? *Apps for Office, 
VSTO and ExcelDNA all address different needs than those of the vast VBA 
community, which is mostly comprised of analysts scripting solving for 
special cases, or SMBs in which the switch to another technology wouldn’t 
make sense cost-wise (and who you won’t hear given the lack ways of 
providing feedback for Excel). We can't use "Apps for Office" for the kind 
of problems we solve here! Proprietary coding for multiple users in a large 
enterprise = bad, proprietary coding for analysis = GREAT!

*3. When will you begin accepting bug reports and feature requests from the 
whole Excel community?* There’s no way to provide feedback for the 
Excel/Office team unless you’re a big MSFT partner; Excel/Office is one of 
the products without presence in Microsoft Connect. There’s little software 
that won’t take feedback from its community, and Excel’s is large!

4. Will you add new worksheet functions? Even if Excel is the superior 
product, there are a lot of community UDFs and functions introduced by 
Google Spreadsheets that are great additions. For instance, see some of the 
formulas that Google has and we're missing out: the REGEXEXTRACT, REGEX*, 
SPLIT... text formulas, the filter formulas (UNIQUE, SORT….), the XPath 
scrapping functions (IMPORTHTML), the data sources functions (IMPORTDATA...)

*5. When will you improve Excel’s charting abilities for analysts and fix 
the old, old bugs that have yet to get attention? *They are lacking, often 
requiring a lot of manual “hacking” to achieve results; look at the amount 
of MVPs that dedicate themselves at explaining such hacks in their blogs. 
The Excel community has documented over the years TONS of bugs and 
shortcomings of Excel charting but instead of addressing those you only 
take care of the big partners requests which are biased towards only a part 
of the user base.There’s a lot of stuff that comes to mind: LINE CHART GAPS 
FOR ERRORS OR “”!!!, cycle plots, dynamic data ranges, pattern fills, 
labelling that stays in its place even if you change the data range, fixing 
the many problems with date category axis, the inability to accurately 
select a specific point in a time series where many are drawn, such as a 
daily series spanning years; the impossibility of easily applying filters 
to charts such as displaying a level series as a % change over a year ago; 
the incredible difficulty of highlighting specific time spans in charts; 
candle charts; the manual labour required to display chart labels to the 
right of the last observation of a series with the proper formatting; the 
difficulty in going from a series to the source data range etc etc.


I hope you agree that this is an opportunity we shouldn't pass. Thanks!

-- 
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 http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

Re: $$Excel-Macros$$ Arrow solution

2014-04-04 Thread amar takale

Dear friends
any solution?

On Thu, Apr 3, 2014 at 12:46 PM, amar takale  wrote:
> Dear Ganesh
> I want Thick arrow like H column in excel.
> Regards
>
> On Thu, Apr 3, 2014 at 12:40 PM, Ganesh N  wrote:
>> Hi Amar,
>>
>> Please find the attachment. Let me know it helps you.
>>
>> Regards,
>> Ganesh N
>>
>>
>> On Thu, Apr 3, 2014 at 12:28 PM, amar takale  wrote:
>>>
>>> Dear Ravinder
>>> Thanks for reply but this is not as per my solution,I want arrow like
>>> H column in excel.
>>> Regards
>>> Amar
>>>
>>> --
>>> 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 http://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 http://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 http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

RE: $$Excel-Macros$$

2014-04-04 Thread Neeraj Chauhan

Dear ,

 

Given information sites are not working.

 

From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Kuldeep Singh
Sent: Friday, April 04, 2014 2:31 PM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$

 

 

http://www.doc2pdf.net/Excel2PDF/

http://www.pdftoexcel.org/

http://www.pdfconverter.com/pdf-to-excel-online-free/

https://www.pdftoexcelonline.com/

 

On Fri, Apr 4, 2014 at 2:27 PM, Neeraj Chauhan 
wrote:

 

Dear expert,

 

I want to convert from PDF to Excel we have some more attachment 

 

Kindly provide any softerware to convert.

 

 

Description: Description: image001

Neeraj Chauhan

+91-9756706350  

 

 

  _  


  

This email is free from viruses and malware because avast! Antivirus
  protection is active. 

 

-- 
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 http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.





 

-- 

Regards,

Kuldeep Singh

Assistant Manager Quality

Game Zone India Limited

Phone.: +91-8586978644
|| naukrikuld...@gmail.com ||
Please Consider the environment. Please don't print this e-mail unless you
really need to.

-- 
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 http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.



---
This email is free from viruses and malware because avast! Antivirus protection 
is active.
http://www.avast.com

-- 
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 http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.
<>

$$Excel-Macros$$ Re: Question on My Menu !!

2014-04-04 Thread Suyog Kulkarni

Ashish Sir,

In My menu -> Select Range
Can you please add "Select non-blank" option. Actually I've posted a 
question on "repetitive formatting" & I'm not getting any reply. If I've 
that option in My Menu probably I could have asked the same. Attached is 
the excel which I've shared with group members.

Kindly help me to solve this issue. 

With Regards,
Suyog

On Sunday, 28 October 2012 13:10:35 UTC+5:30, Suyog Kulkarni wrote:
>
> Hello All,
>
> I'm using Ashish Sir's "My Menu ver 1.6" very frequently & that increased 
> my working speed in excel. I'm really thankful for same.
> Please refer attached my question regarding "insert" option of my menu.
>
> Please advice on my question. 
>
> With Best Regards,
> Suyog
>

-- 
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 http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

Steps for Good look.xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet

Re: $$Excel-Macros$$

2014-04-04 Thread Kuldeep Singh

http://www.doc2pdf.net/Excel2PDF/
http://www.pdftoexcel.org/
http://www.pdfconverter.com/pdf-to-excel-online-free/
https://www.pdftoexcelonline.com/

On Fri, Apr 4, 2014 at 2:27 PM, Neeraj Chauhan
wrote:

>
>
> Dear expert,
>
>
>
> I want to convert from PDF to Excel we have some more attachment
>
>
>
> Kindly provide any softerware to convert.
>
>
>
>
>
> [image: Description: Description: image001]
>
> *Neeraj Chauhan*
>
> *+91-9756706350 <%2B91-9756706350>*
>
>
>
>
> --
>
>
> This email is free from viruses and malware because avast! 
> Antivirusprotection is active.
>
>  --
> 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 http://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/d/optout.
>



-- 
Regards,
Kuldeep Singh
Assistant Manager Quality
Game Zone India Limited
Phone.: +91-8586978644
|| naukrikuld...@gmail.com ||
*Please* *Consider the environment. Please don't print this e-mail unless
you really need to.*

-- 
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 http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.
<>

$$Excel-Macros$$ Re: How to define the uppercase, lowercase and proper()

$$Excel-Macros$$ How to define the uppercase, lowercase and proper()

$$Excel-Macros$$ Delete button on Sequence Column

$$Excel-Macros$$ Re: How to identify which is text, integers, date, time in a table?

Re: $$Excel-Macros$$ Re: Need help for repetative formatting - Repair my code

$$Excel-Macros$$ Compare two worksheet Trial Balance

Re: $$Excel-Macros$$

Re: $$Excel-Macros$$ Copy Data from next Column and Repeat Paste as per the Values

Re: $$Excel-Macros$$ Re: Need help for repetative formatting - Repair my code

$$Excel-Macros$$ How to identify which is text, integers, date, time in a table?

$$Excel-Macros$$ Re: Need help for repetative formatting - Repair my code

$$Excel-Macros$$ Re: Need help for repetative formatting - Repair my code

$$Excel-Macros$$ Coordinating questions for today's Q&A with the Excel Developers. Let's ask for VBA!

Re: $$Excel-Macros$$ Arrow solution

RE: $$Excel-Macros$$

$$Excel-Macros$$ Re: Question on My Menu !!

Re: $$Excel-Macros$$

17 matches

Site Navigation

Mail list logo

Footer information