$$Excel-Macros$$ Re: Required Macro for changing the font colour
Hi Mallikarjun,
Can you please eloborate on your requirement? I have prepared the
following macro assuming that the characters will be selected from
left to right and the font colour desired is red:
Sub Macro1()
Dim number As Integer
number = InputBox("Please enter the number of characters for which you
would like to change the colour:")
ActiveCell.Characters(Start:=1, Length:=number).Font.Color = 255
End Sub
On Jun 2, 5:36 pm, Torli Mallik wrote:
> Hi All,
>
> I'm need to change the colour of the seleted text/ part of the text in
> a cell.
>
> The above can be achived by selecting the required text and then by
> clicking the font colour icon.
>
> But, I'm unable to geneate the macro for the same.
>
> Please help me.
>
> Thanks & Regards,
> Mallikarjun
--~--~-~--~~~---~--~~
-
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$$ Re: need macro
Hi Vaibhav I want to see the code can you please provide the password for the file. On Thursday, July 24, 2014 4:05:55 PM UTC+5:30, SUDHIR VERMA wrote: > > Dear Experts, > > I need macro, which can encrypt with password after defined no of days. > > Example- i make file today, after 20 days it will password protect > automatically. So someone couldn't open in my absence. > > Thanking You > > Regard > > Sudhir > -- 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 macro
Hi Vibhav, The password "password" is not working. When I enter it first time, I get a window asking for write password. Whether you enter "password" or click read only the file automatically closes. I have set macro security to "enable all macros" mode. Can you tell me what I'm doing wrong here. If not can you just post the code in the a text file. Thanks in advance. On Thursday, July 24, 2014 4:05:55 PM UTC+5:30, SUDHIR VERMA wrote: > > Dear Experts, > > I need macro, which can encrypt with password after defined no of days. > > Example- i make file today, after 20 days it will password protect > automatically. So someone couldn't open in my absence. > > Thanking You > > Regard > > Sudhir > -- 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$$ Abridged summary of excel-macros@googlegroups.com - 4 updates in 3 topics
Hi I have a simple question I'm trying to declare a public array myarray which can be used by either of PublicArrayExample() & TestPublicArrayExample(). But while executing the macro I'm facing compiler error. Can you please what is wrong with my declaration. Please see the attached files On Tue, Mar 24, 2015 at 5:06 AM, wrote: > excel-macros@googlegroups.com > <https://groups.google.com/forum/?utm_source=digest&utm_medium=email#!forum/excel-macros/topics> > Google > Groups > <https://groups.google.com/forum/?utm_source=digest&utm_medium=email/#!overview> > <https://groups.google.com/forum/?utm_source=digest&utm_medium=email/#!overview> > Today's topic summary > View all topics > <https://groups.google.com/forum/?utm_source=digest&utm_medium=email#!forum/excel-macros/topics> > >- Tips and Tricks <#14c48feab238800e_group_thread_0> - 1 Update >- how to run SQL Query in Excel to retrive a set of Data. ><#14c48feab238800e_group_thread_1> - 1 Update >- Query in code of email send with attachment from excel ><#14c48feab238800e_group_thread_2> - 2 Updates > > Tips and Tricks > <http://groups.google.com/group/excel-macros/t/fda971b10be88449?utm_source=digest&utm_medium=email> > Sanjeev Banerjee : Mar 23 09:31AM -0700 > > Hi > > Some Tips & Tricks of Excel > > Attaching some Files > > Thanks and Regards > Sanjeev Banerjee > ...more > <http://groups.google.com/group/excel-macros/msg/8961e565af095311?utm_source=digest&utm_medium=email> > Back to top <#14c48feab238800e_digest_top> > how to run SQL Query in Excel to retrive a set of Data. > <http://groups.google.com/group/excel-macros/t/4abbb7154f6f2df1?utm_source=digest&utm_medium=email> > Rakesh kumar : Mar 23 08:08PM +0530 > > Hi, > > I want to run SQL Query in Excel to retrive a set of Data. > > Currently i am executing a query in Sql then copied the output and pasted > into excel. > > Now i want to direct Execution of query ...more > <http://groups.google.com/group/excel-macros/msg/8f7aebec9494325f?utm_source=digest&utm_medium=email> > Back to top <#14c48feab238800e_digest_top> > Query in code of email send with attachment from excel > <http://groups.google.com/group/excel-macros/t/35938998bb63993e?utm_source=digest&utm_medium=email> > Ashish Bhalara : Mar 23 05:00PM +0530 > > Dear experts, > > See the attached file of email sending from excel. Normally mail send > successfully to all together from database. I need attached file to some of > party so I add column 'Attachment ...more > <http://groups.google.com/group/excel-macros/msg/16db303475b09f39?utm_source=digest&utm_medium=email> > Vaibhav Joshi : Mar 23 06:30PM +0530 > > Before adding att check if attachment exists or not, if its null then you > will get error... > > Cheers!! > > On Mon, Mar 23, 2015 at 5:00 PM, Ashish Bhalara > > wrote: > > ...more > <http://groups.google.com/group/excel-macros/msg/466039c4aef07f4d?utm_source=digest&utm_medium=email> > Back to top <#14c48feab238800e_digest_top> >You received this digest because you're subscribed to updates for this > group. You can change your settings on the group membership page > <https://groups.google.com/forum/?utm_source=digest&utm_medium=email#!forum/excel-macros/join> > . > To unsubscribe from this group and stop receiving emails from it send an > email to excel-macros+unsubscr...@googlegroups.com. > -- With Regards, Rohit Jadhav. -- 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. Book1.xlsm Description: application/vnd.ms-excel.sheet.macroenabled.12
$$Excel-Macros$$ How to declare public array
Hi I have a simple question I'm trying to declare a public array myarray which can be used by either of PublicArrayExample() & TestPublicArrayExample(). But while executing the macro I'm facing compiler error. Can you please what is wrong with my declaration. Please see the attached files -- With Regards, Rohit Jadhav. -- 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. Book1.xlsm Description: application/vnd.ms-excel.sheet.macroenabled.12
$$Excel-Macros$$ Re: How to declare public array
Thanks a lot. It definitely solves my problem. Can you please tell me how to declare array using public keyword. On Wednesday, March 25, 2015 at 4:10:48 PM UTC+5:30, Rohit Jadhav wrote: > > > Hi > I have a simple question > I'm trying to declare a public array myarray which can be used by either > of PublicArrayExample() & TestPublicArrayExample(). But while executing the > macro I'm facing compiler error. Can you please what is wrong with my > declaration. Please see the attached files > > > > -- > With Regards, > Rohit Jadhav. > -- 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: Please help with Activex "cannot insert object". error
Hi Paul I have read the solution you have provided but when I go to the C:\Users\[username]\AppData\ Local\Temp\Excel8.0 folder there is no file called MSForms.exd. I tried searching my computer for *.exd files and there is none present. I also tried to install one of the updates from Microsoft site but the problem still persists. So now I'm don't know what is wrong. On Thursday, April 23, 2015 at 1:28:05 PM UTC+5:30, Rohit Jadhav wrote: > > Hi > I have been experiencing this error recently in Excel 2007. Whenever try > to add any ACTIVEX buttons to my worksheet I get an error "cannot insert > object". The screenshot is attached here. I have reinstalled office but the > error is still present. I also searched online but nothing seems to work. > The Form buttons on the other hand work perfectly fine. Please help me. > -- 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: Please help with Activex "cannot insert object". error
The Appdata folder in itself is hidden. So you can see that i have already unhidden the files from the folder options view tab. Any ways thanks for the reply. On Thursday, April 23, 2015 at 1:28:05 PM UTC+5:30, Rohit Jadhav wrote: > > Hi > I have been experiencing this error recently in Excel 2007. Whenever try > to add any ACTIVEX buttons to my worksheet I get an error "cannot insert > object". The screenshot is attached here. I have reinstalled office but the > error is still present. I also searched online but nothing seems to work. > The Form buttons on the other hand work perfectly fine. Please help me. > -- 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$$ Help for error :Excel help viewer has encountered a problem & cannot continue.
Hi I'm not able to access any help from Excel 2007. I have attached the error snap shot here. I tried reinstalling Excel but after sometime it comes back. I also downloaded latest updates from MS site but it did not make any difference. Has any one faced & solved this problem successfully. Also its weird that this problem exists only in excel & all other MS Office application help runs without any error. Please help. -- 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$$ is it possible to reduce this sorting code
Hi
I want to sort a range say a1 to j15 containing various details of one's
mutual fund portfolio like company name, fund name, fund type, no of units
held, NAV , dividend received etc.
I have created sorting code from excel but is it possible to reduce this
code. I am using a separate function for sorting as shown below & passing
it 2 parameters viz. name of the sheet containing data & how to sort the
data i.e. by value or by fund name.
Also if anyone can explain the 2nd part of the sorting code & is it
necessary to do this part, I would be very thankful.
-
Sub sorting_Needs()
Dim i As String, j As Integer
abb: i = InputBox("Do you want to" & Chr(10) _
& "1. sort data by value" & Chr(10) _
& "2. Sort data by name", "Choice", 1)
Select Case i
Case Is = "1"
j = sort_data("Sheet1", Range("I:I"))
Case Is = "2"
j = sort_data("Sheet1", Range("b:b"))
Case Else
i = MsgBox("Please select a valid choice", vbRetryCancel, "Error
Massage")
If i = 4 Then
GoTo abb
End If
End Select
End Sub
Public Function sort_data(sh As String, col As Range)
'activate the data sheet
Sheets(sh).Activate
'select the entire data table in the sheet
Range("A1").Select
Selection.CurrentRegion.Select
'code generated by excel for sorting a range
ActiveWorkbook.Worksheets(sh).Sort.SortFields.Clear
ActiveWorkbook.Worksheets(sh).Sort.SortFields.Add Key:=col _
, SortOn:=xlSortOnValues, Order:=xlAscending,
DataOption:=xlSortNormal
'2nd part
With ActiveWorkbook.Worksheets(sh).Sort
.SetRange Range("A1:j12")
.Header = xlYes
.MatchCase = False
.Orientation = xlTopToBottom
.SortMethod = xlPinYin
.Apply
End With
End Function
--
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$$ Please Point error in following UDF
Hi I had made this UDF based on the needs of a question asked in this forum. However when i change anything in VBA code (as minute as adding comments or add a point to debug etc. ) the calculated value becomes zero on the worksheet. Also the function does not update automatically when input data is changed. The function value becomes zero when i change the input to function. Please let me know what I have done wrong in this coding. Thank you -- 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. customized average.xlsm Description: application/vnd.ms-excel.sheet.macroenabled.12
$$Excel-Macros$$ Re: Query
Hi Soumyendu Paul I'm not exactly sure what you want. So here's my understanding "If user makes any changes in the file he/she has to click the Send mail button before closing the file and you have code for sending the mail " A simple way is to use activex control button instead of the shape you have used. I have included both shape based & activex based code in the file. choose what you want. Hope this is useful On Tuesday, June 30, 2015 at 7:02:44 AM UTC+5:30, Soumyendu Paul wrote: > > In attachment; sheet1 we are sending a mail on clicking a shape. My query > is to give an alert(like popup message box) when shape is not cliked > -- 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. Copy of Test.xlsm Description: application/vnd.ms-excel.sheet.macroenabled.12
$$Excel-Macros$$ Need a Macro code for file automatically corrupt after a specific date
Hi Experts i need a vba macro code for the excel sheet got corrupt after a specific period. Regards Rohit Badola -- 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$$ Remove me from mailing list
Hi.. Kindly remove my name from mailing list. Thanks Rohit rohit...@yahoo.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
$$Excel-Macros$$ Re: pls help for dis
On Thu, Apr 16, 2009 at 10:46 AM, rohit patel wrote: > i just want to link dis 1 sheet (Vendor April .09 demo) to Receiving > status(supplier)mar.09 demo, i just want dat if we entered the data > in Receiving status(supplier)mar.09 demo the effect should be show in dis > file (Vendor April .09 demo) > > -- > Thanks & Regards > > Roh!t > -- Thanks & Regards Roh!t -- 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
$$Excel-Macros$$ pls help
hiii, kindly let me know what are the benifits of ADVANCE FILER in Excel 2003. wating for reply... Thanks in advance... Regards, -- -- 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$$ Need Help
Dear, pls let me know how i can create excel macros in MS ACESS 2003. thanks in advance... regards, -- -- 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$$ Project Manager with Capacity Planning West Norristown PA
Send me your References @ s...@hmgamerica.com * Project Manager with Capacity Planning West Norristown PA 6 Months Plus* One of our Direct Client is looking for Project Manager with Capacity Planning experience The job description is as follows: It is desired that the capacity candidate know how to construct capacity models that reflect trend growth of current resources and project long term KPIs. The candidate must also know how to construct consolidation models taking many servers and consolidating them on to a fewer number of resources. These models will be constructed using BMC Best1 and Hyperformix. - System administration background - SQL server knowledge desired - Oracle understanding (Enterprise as well as RAC) - Business Objects user knowledge desired - Experience with BMC / patrol and Best1 (perform / Predict) - Knowledge of Hyperformix - Experience in large scale server consolidation projects - Able to utilize capacity planning tools to model changes in workloads, system configurations and model server - consolidations. - Understanding of EMC SAN environments. - Understanding of Virtual environments VMWARE as well as Power VM - Understanding of SAN and high performance EMC Arrays - Good oral and written communication skills Best Regards, Sam Martin E: sam.ultimateli...@gmail.com PH: 732-659-8219 -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ 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. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or 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 post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com.
$$Excel-Macros$$ Java Developer
*Send me your resume@ sam.ultimateli...@gmail.com* * * *Position: *Java Developer** *Location:* Cleveland, Ohio *Duration:* : 6-12 months + * * *Skills Required* · Spring, · MVC · JQuery · Netbeans, · SVN, · Glassfish server (nice to have) -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ 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. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or 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 post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com.
RE: $$Excel-Macros$$ Not getting the VB Editor in Excel
Yes, I am sure about that. I am using MS Excel 2007 Rohit From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Sam Mathai Chacko Sent: 09 November 2011 20:47 To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Not getting the VB Editor in Excel Are you sure you are not using the Excel Viewer? Regards, Sam On Wed, Nov 9, 2011 at 5:45 PM, Rohit Tikhe wrote: Can you please help me, as I not getting the VB Editor in Excel 2007 Rohit -- FORUM RULES (925+ 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 (925+ 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 (925+ 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$$ Re: Sales File
Hi Prince , On Thu, Dec 27, 2012 at 10:55 AM, Prince wrote: > Hi Rohit, > > Pls Check my file as i have put sumif formula in ptd & ytd & suggest me > wht should be possible for me . > > I hope this may help you, Otherwise let me know. > > =TEXT(NOW(),"dd-mmm-") > > Regards > Prince > > > On Thursday, December 27, 2012 11:58:21 AM UTC+5:30, tharwani.rohit wrote: >> >> Hie Experts , >> PFA of Daily Consumer daily sales & i need urgent help from your side >> ..in report sheet i have put formulas & in PTD 15feb 2012 in this i need to >> everytime change date so the amounts changes automaticaly is there any way >> so without changing date i can get the answer aur any suitable thing which >> i can do & YTD 2012 ...kindly check revert me back .. >> >> -- > 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 post to this group, send email to excel-macros@googlegroups.com. > To unsubscribe from this group, send email to > excel-macros+unsubscr...@googlegroups.com. > Visit this group at http://groups.google.com/group/excel-macros?hl=en. > > > -- 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 post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en.
RE: $$Excel-Macros$$ Help: powerpoint shortcut
Powerpnt Regards, Rohit Garg-Original Message- From: janet dickson Sent: 24/06/2010, 9:51 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Help: powerpoint shortcut Hi Team *Sorry for asking this in excel group.* Does any one know the Shortcut for opening a MS Powerpoint using run box (Winkey + R) ?? I can open several programs in run box (winkey + R) as shown below*:* MS Excel is *excel* MS Word is *winword* MS Access is *msaccess* MS Outlook is *outlook* ** MS Powerpoint ..*I don't know!! please help* ** ** ** *Hugs & Love...* -- -- 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
