RE: $$Excel-Macros$$ Column Reference based on changes in Raw reference
So what do you need ?? From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Amit Desai (MERU) Sent: 16 April 2013 11:02 To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Column Reference based on changes in Raw reference Dear Group, I need your help... I am using SUMIFS formula got a simpler solution. I have listed dates in raws say from 1st Apr to 30th Apr. I also prepared columns with the same date as header in next sheet. I want that if I move from raw 1 to raw 2, I get a reference of column 2 so on... Best Regards, Amit Desai +91 98672 32534 _ Disclaimer: This message and its attachments contain confidential information and may also contain legally privileged information. This message is intended solely for the named addressee. If you are not the addressee indicated in this message (or authorized to receive for addressee), you may not copy or deliver any part of this message or its attachments to anyone or use any part of this message or its attachments. Rather, you should permanently delete this message and its attachments (and all copies) from your system and kindly notify the sender by reply e-mail. Any content of this message and its attachments that does not relate to the official business of Meru Cab Company Pvt. Ltd. must be taken not to have been sent or endorsed by any of them. Email communications are not private and no warranty is made that e-mail communications are timely, secure or free from computer virus or other defect. -- 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?hl=en. For more options, visit https://groups.google.com/groups/opt_out. -- 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?hl=en. For more options, visit https://groups.google.com/groups/opt_out.
Re: $$Excel-Macros$$ Column Reference based on changes in Raw reference
Dear Amit, Pl share the workbook Warm Regards, Gawli Anil. On Tue, Apr 16, 2013 at 11:30 AM, Priti_verma pritiverma1...@gmail.comwrote: So what do you need ?? ** ** *From:* excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com] *On Behalf Of *Amit Desai (MERU) *Sent:* 16 April 2013 11:02 *To:* excel-macros@googlegroups.com *Subject:* $$Excel-Macros$$ Column Reference based on changes in Raw reference ** ** Dear Group, ** ** I need your help... I am using SUMIFS formula got a simpler solution.*** * ** ** I have listed dates in raws say from 1st Apr to 30th Apr. I also prepared columns with the same date as header in next sheet. I want that if I move from raw 1 to raw 2, I get a reference of column 2 so on... ** ** Best Regards, Amit Desai +91 98672 32534 ** ** ** ** -- Disclaimer: This message and its attachments contain confidential information and may also contain legally privileged information. This message is intended solely for the named addressee. If you are not the addressee indicated in this message (or authorized to receive for addressee), you may not copy or deliver any part of this message or its attachments to anyone or use any part of this message or its attachments. Rather, you should permanently delete this message and its attachments (and all copies) from your system and kindly notify the sender by reply e-mail. Any content of this message and its attachments that does not relate to the official business of Meru Cab Company Pvt. Ltd. must be taken not to have been sent or endorsed by any of them. Email communications are not private and no warranty is made that e-mail communications are timely, secure or free from computer virus or other defect. -- 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?hl=en. For more options, visit https://groups.google.com/groups/opt_out. -- 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?hl=en. For more options, visit https://groups.google.com/groups/opt_out. -- Thanks Regards, Gawli Anil Narayan Software Developer, Abacus Software Services Pvt Ltd -- 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
Re: $$Excel-Macros$$ Click Option for Multiple Criteria
Follow steps and try this. Hope this will work for you: 1. *Right Click on Cell C5* 2. *Create a hyperlink with cell refrence C5 in the same (output sheet )* 3. *Do same for Cell D5 and create hyperlink with cell refrence D5 in the same (output sheet )* 4. *Right click on output sheet and view code and copy-paste below code to get the output you want.* * * *Private Sub Worksheet_FollowHyperlink(ByVal Target As Hyperlink)* * * *Dim wksSht As Worksheet* *Dim rngRangeAs Range* *Dim varData() As Variant* ** *Const strOutPutShtName As String = Output* *Const strDataStartCell As String = K7* *Const strOutPutDataStartCellAs String = B9* *Const lngTotalDataCol As Long = 5* ** *Set rngRange = Nothing* *On Error Resume Next* *Set rngRange = Worksheets(strOutPutShtName).Range(Target.SubAddress)* *On Error GoTo -1: On Error GoTo 0: Err.Clear* *If Not rngRange Is Nothing Then* *If Len(Trim(rngRange.Value)) 0 Then* *Set wksSht = Nothing* *On Error Resume Next* *Set wksSht = Worksheets(Trim(rngRange.Value))* *On Error GoTo -1: On Error GoTo 0: Err.Clear* *If Not wksSht Is Nothing Then* *With wksSht* *Set rngRange = .Range(strDataStartCell)* *Set rngRange = rngRange.Resize(.Cells(.Rows.Count, rngRange.Column).End(xlUp).Row - rngRange.Row + 1)* *Set rngRange = rngRange.Resize(, .Cells(rngRange.Row, .Columns.Count).End(xlToLeft).Column - rngRange.Column + 1)* *If rngRange.Rows.Count 1 Then* *Set rngRange = Intersect(rngRange, rngRange.Offset(1))* *varData = rngRange.Value* *With Worksheets(strOutPutShtName)* *Set rngRange = .Range(strOutPutDataStartCell).CurrentRegion* *Set rngRange = Intersect(rngRange, rngRange.Offset(1, 1))* *rngRange.ClearContents* *rngRange.Resize(1, 1).Resize(UBound(varData), UBound(varData, 2)).Value = varData* *End With* *End If* *End With* *End If* *End If* *End If* ** *Set wksSht = Nothing* *Set rngRange = Nothing* *Erase varData* ** *End Sub* On Tuesday, 16 April 2013 12:14:42 UTC+5:30, amar takale wrote: Dear Chaya Thanks very much for Struggle for my Solution but yet not got output as I wish.You know that Yesterday I attached Sheet (Final+3) for Remove NA error in that sheet I want click Option for output not Data validation.I attached sheet here.Pls see it Regards Amar On Tue, Apr 16, 2013 at 11:48 AM, Chaya chaya...@gmail.com javascript:wrote: Dear Amar, PFA... Like this you are expecting right ? Regards, Chaya On Tue, Apr 16, 2013 at 11:43 AM, amar takale amart...@gmail.comjavascript: wrote: Dear Chaya It's working good Good one attempt also useful for me. But exact which I want to solution not attempt.I want only click on criteria name then show data as like any webpage show.So Pls try to understand me give Only click solution. Regards Amar On Tue, Apr 16, 2013 at 11:05 AM, Chaya chaya...@gmail.comjavascript: wrote: Dear Amit, PFA, i hope it will meet your requirement. Regards, Chaya On Tue, Apr 16, 2013 at 10:36 AM, amar takale amart...@gmail.comjavascript: wrote: Dear Experts I want help all our members of group who solved my issue of Click option. We also use Data validation.But I required Click option on criteria. Appreciate the help 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...@googlegroups.com javascript:. To post to this group, send email to excel-...@googlegroups.comjavascript: .
Re: $$Excel-Macros$$ Sum on the basis of colour formula
Hi Noorain, Can you please share all stuff for get. function . Enjoy Team XLS On Thu, Apr 11, 2013 at 5:45 PM, NOORAIN ANSARI noorain.ans...@gmail.comwrote: Dear LK, Please try it.. =GET.CELL(63,INDIRECT(RC[-1],)) On Thu, Apr 11, 2013 at 4:48 PM, L.K. Modi ca.mod...@gmail.com wrote: Dear All I need formula for this particular query so please provide me any any formula instead of macro Dear All In the given sheet i want sum on the basis of colour , is there any formula to solve my problem regards L.K.Modi -- 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?hl=en. For more options, visit https://groups.google.com/groups/opt_out. -- 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?hl=en. For more options, visit https://groups.google.com/groups/opt_out. -- With Regards, Noorain Ansari http:// http://www.noorainansari.comnoorainansari.comhttp://www.noorainansari.com http:// http://www.excelvbaclinic.blogspot.comexcelvbaclinic.comhttp://www.excelvbaclinic.blogspot.comhttp://accesssqclinic.blogspot.in/ -- 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?hl=en. For more options, visit https://groups.google.com/groups/opt_out. -- 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
Re: $$Excel-Macros$$ Click Option for Multiple Criteria
Dear Lalit Thats amazing,Perfect,mind blowing.Which I want I got it.Brother thank very much. you are great. Also Thanks others members like Chaya,Priti,Anil who struggle for my solution. Once agian Thanks very much all. Regards Amar On Tue, Apr 16, 2013 at 12:52 PM, Lalit Mohan Pandey mohan.pande...@gmail.com wrote: Follow steps and try this. Hope this will work for you: 1. *Right Click on Cell C5* 2. *Create a hyperlink with cell refrence C5 in the same (output sheet )* 3. *Do same for Cell D5 and create hyperlink with cell refrence D5 in the same (output sheet )* 4. *Right click on output sheet and view code and copy-paste below code to get the output you want.* * * *Private Sub Worksheet_FollowHyperlink(ByVal Target As Hyperlink)* * * *Dim wksSht As Worksheet* *Dim rngRangeAs Range* *Dim varData() As Variant* ** *Const strOutPutShtName As String = Output* *Const strDataStartCell As String = K7* *Const strOutPutDataStartCellAs String = B9* *Const lngTotalDataCol As Long = 5* ** *Set rngRange = Nothing* *On Error Resume Next* *Set rngRange = Worksheets(strOutPutShtName).Range(Target.SubAddress)* *On Error GoTo -1: On Error GoTo 0: Err.Clear* *If Not rngRange Is Nothing Then* *If Len(Trim(rngRange.Value)) 0 Then* *Set wksSht = Nothing* *On Error Resume Next* *Set wksSht = Worksheets(Trim(rngRange.Value))* *On Error GoTo -1: On Error GoTo 0: Err.Clear* *If Not wksSht Is Nothing Then* *With wksSht* *Set rngRange = .Range(strDataStartCell)* *Set rngRange = rngRange.Resize(.Cells(.Rows.Count, rngRange.Column).End(xlUp).Row - rngRange.Row + 1)* *Set rngRange = rngRange.Resize(, .Cells(rngRange.Row, .Columns.Count).End(xlToLeft).Column - rngRange.Column + 1)* *If rngRange.Rows.Count 1 Then* *Set rngRange = Intersect(rngRange, rngRange.Offset(1))* *varData = rngRange.Value* *With Worksheets(strOutPutShtName)* *Set rngRange = .Range(strOutPutDataStartCell).CurrentRegion* *Set rngRange = Intersect(rngRange, rngRange.Offset(1, 1))* *rngRange.ClearContents* *rngRange.Resize(1, 1).Resize(UBound(varData), UBound(varData, 2)).Value = varData* *End With* *End If* *End With* *End If* *End If* *End If* ** *Set wksSht = Nothing* *Set rngRange = Nothing* *Erase varData* ** *End Sub* On Tuesday, 16 April 2013 12:14:42 UTC+5:30, amar takale wrote: Dear Chaya Thanks very much for Struggle for my Solution but yet not got output as I wish.You know that Yesterday I attached Sheet (Final+3) for Remove NA error in that sheet I want click Option for output not Data validation.I attached sheet here.Pls see it Regards Amar On Tue, Apr 16, 2013 at 11:48 AM, Chaya chaya...@gmail.com wrote: Dear Amar, PFA... Like this you are expecting right ? Regards, Chaya On Tue, Apr 16, 2013 at 11:43 AM, amar takale amart...@gmail.comwrote: Dear Chaya It's working good Good one attempt also useful for me. But exact which I want to solution not attempt.I want only click on criteria name then show data as like any webpage show.So Pls try to understand me give Only click solution. Regards Amar On Tue, Apr 16, 2013 at 11:05 AM, Chaya chaya...@gmail.com wrote: Dear Amit, PFA, i hope it will meet your requirement. Regards, Chaya On Tue, Apr 16, 2013 at 10:36 AM, amar takale amart...@gmail.comwrote: Dear Experts I want help all our members of group who solved my issue of Click option. We also use Data validation.But I required Click option on criteria. Appreciate the help 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/**discussexcelhttps://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
RE: $$Excel-Macros$$ print current file to pdf
Hello Ashish, We are using MS office 2007. I have attached sample sheet. -- Regards Santosh santoshkumar.subu...@gmail.com -- From: koul.ash...@gmail.com Date: Mon, 15 Apr 2013 20:14:02 +0530 Subject: Re: $$Excel-Macros$$ print current file to pdf To: excel-macros@googlegroups.com which version of excel r u using .. can u share a sample file On Sun, Apr 14, 2013 at 7:23 PM, santosh subudhi santoshkumar.subu...@gmail.com wrote: Hello Team I am looking for VBA code to print a active sheet into pdf without user interface. Suppose the cell AA1 contains the address where the pdf to be stored and Cell AA2 contains the name by which the pdf to be stored. -- Regards Santosh santoshkumar.subu...@gmail.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?hl=en. For more options, visit https://groups.google.com/groups/opt_out. -- *Regards* * * *Ashish Koul* *Visit* *My Excel Blog http://www.excelvbamacros.com/* Like Us on Facebookhttp://www.facebook.com/pages/Excel-VBA-Codes-Macros/15180389897 Join Us on Facebook http://www.facebook.com/groups/163491717053198/ P Before printing, think about the environment. -- 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?hl=en. For more options, visit https://groups.google.com/groups/opt_out. -- 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?hl=en. For more options, visit https://groups.google.com/groups/opt_out. temp.xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
$$Excel-Macros$$
-- 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?hl=en. For more options, visit https://groups.google.com/groups/opt_out.
$$Excel-Macros$$ Re: cell formula
thx On Monday, April 15, 2013 9:58:30 AM UTC+2, colmkav wrote: Hi, I am trying to set the formula of a cell to be the following: =D6 YEAR(MonthEndDate) . MONTH(MonthEndDate) . \Outputs\ However the following code gives this forumula instead: = 'D6' YEAR(MonthEndDate) . rg.value . \Outputs\ How can I correct this to give the formula I want? Sub test() Dim sMonthEnd As String Dim iMonthEnd As Integer Dim rg As Range sMonthEnd = Month(Range(MonthEndDate)) Set rg = Range(MonthlyFolders).Find(What:=sMonthEnd).Offset(0, 1) Range(OutputFolder).FormulaR1C1 = =D6 YEAR(MonthEndDate) . rg.value . \Outputs\ End Sub -- 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?hl=en. For more options, visit https://groups.google.com/groups/opt_out.
Fwd: $$Excel-Macros$$ Time Tracking Tracker
Hi team, Awaiting ur valuable response on my below email. Regards, Kaushik Savla -- Forwarded message -- From: KAUSHIK SAVLA savla.kaus...@gmail.com Date: Apr 15, 2013 8:21 PM Subject: Fwd: $$Excel-Macros$$ Time Tracking Tracker To: excel-macros@googlegroups.com Hi All, I am getting error message when I am trying to apply the below macro code:- Option Explicit Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean) Dim pwd pwd = Test If (Target.Count = 1) Then If (Target.Value X = X) Then If (Target.Column = 5) Or (Target.Column = 6) Then ActiveSheet.Unprotect Password:=pwd ActiveCell.Value = Now() ActiveSheet.Protect DrawingObjects:=True, _ Contents:=True, _ Scenarios:=True, _ AllowFormattingCells:=True, _ AllowFormattingColumns:=True, _ AllowFormattingRows:=True, _ AllowSorting:=True, _ AllowFiltering:=True, _ Password:=pwd End If End If End If End Sub Pls suggest on it. Regards, Kaushik Savla -- Forwarded message -- From: KAUSHIK SAVLA savla.kaus...@gmail.com Date: Sat, Apr 6, 2013 at 1:15 PM Subject: Re: $$Excel-Macros$$ Time Tracking Tracker To: excel-macros@googlegroups.com excel-macros@googlegroups.com Hi Paul, I am able to use your VBA Code properly. Just have one quick question, I need to send this to team members and do not want them to know the Password to unprotect so there will be no tampering of data. In your code you have mentioned pwd = Test in 4th line which can be accessible by anyone. Is there any way I will be only knowing the password to unprotect without getting displayed to all. Regards, Kaushik Savla On Fri, Apr 5, 2013 at 8:41 PM, KAUSHIK SAVLA savla.kaus...@gmail.comwrote: Thank You for the help. On Friday, April 5, 2013, Paul Schreiner schreiner_p...@att.net wrote: Here's what I did: In the Sheet module, create a double-click event: Option Explicit Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean) Dim pwd pwd = Test If (Target.Count = 1) Then If (Target.Value X = X) Then If (Target.Column = 4) Or (Target.Column = 5) Then ActiveSheet.Unprotect Password:=pwd ActiveCell.Value = Now() ActiveSheet.Protect DrawingObjects:=True, _ Contents:=True, _ Scenarios:=True, _ AllowFormattingCells:=True, _ AllowFormattingColumns:=True, _ AllowFormattingRows:=True, _ AllowSorting:=True, _ AllowFiltering:=True, _ Password:=pwd End If End If End If End Sub --- I changed the display format of columns D-F to display time. In column F, I entered the formula: =IF(AND(D2,E2),E2-D2,) and copied it down the column. I then changed the format of all cells in the sheet to locked and protected the sheet. As you can see in the macro, I used the password test If you use something else, change the value in the macro. hope this helps Paul - “Do all the good you can, By all the means you can, In all the ways you can, In all the places you can, At all the times you can, To all the people you can, As long as ever you can.” - John Wesley - From: KAUSHIK SAVLA savla.kaus...@gmail.com To: excel-macros@googlegroups.com Sent: Fri, April 5, 2013 5:25:11 AM Subject: $$Excel-Macros$$ Time Tracking Tracker Hi Team, I need Time Management Tracker which does the following:- If anyone double click in start time column the time of system get capture automatically which cannot be edited , similarly for end time. Need password protected to enable changes my myself. Regards, Kaushik -- 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
Re: Fwd: $$Excel-Macros$$ Time Tracking Tracker
You didn't mention what error you're getting, or where the error occurs. I tested it and I think I found it: Let's take a look at how Excel operates: If you didn't have an Event macro, when you double-click a cell, what normally happens? If you still have the default edit in cell option available, your type-in bar is placed in the cell, and you're editing the cell, correct? Well, if you have an Event macro, when you double-click a cell, this double-click event fires off. regardless of what cell you double-click, or if the cell is empty, when the macro finishes, your double-click action STILL attempts to edit in the cell! since your macro protects the sheet, you get a protection error when you try to edit in the cell. In an Event macro, if you want to cancel the normal action, you need to add: Cancel = true to your macro. I'd place it right after pwd=Test. = Paul - “Do all the good you can, By all the means you can, In all the ways you can, In all the places you can, At all the times you can, To all the people you can, As long as ever you can.” - John Wesley - From: KAUSHIK SAVLA savla.kaus...@gmail.com To: excel-macros@googlegroups.com excel-macros@googlegroups.com Sent: Tue, April 16, 2013 8:39:32 AM Subject: Fwd: $$Excel-Macros$$ Time Tracking Tracker Hi team, Awaiting ur valuable response on my below email. Regards, Kaushik Savla -- Forwarded message -- From: KAUSHIK SAVLA savla.kaus...@gmail.com Date: Apr 15, 2013 8:21 PM Subject: Fwd: $$Excel-Macros$$ Time Tracking Tracker To: excel-macros@googlegroups.com Hi All, I am getting error message when I am trying to apply the below macro code:- Option Explicit Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean) Dim pwd pwd = Test If (Target.Count = 1) Then If (Target.Value X = X) Then If (Target.Column = 5) Or (Target.Column = 6) Then ActiveSheet.Unprotect Password:=pwd ActiveCell.Value = Now() ActiveSheet.Protect DrawingObjects:=True, _ Contents:=True, _ Scenarios:=True, _ AllowFormattingCells:=True, _ AllowFormattingColumns:=True, _ AllowFormattingRows:=True, _ AllowSorting:=True, _ AllowFiltering:=True, _ Password:=pwd End If End If End If End Sub Pls suggest on it. Regards, Kaushik Savla -- Forwarded message -- From: KAUSHIK SAVLA savla.kaus...@gmail.com Date: Sat, Apr 6, 2013 at 1:15 PM Subject: Re: $$Excel-Macros$$ Time Tracking Tracker To: excel-macros@googlegroups.com excel-macros@googlegroups.com Hi Paul, I am able to use your VBA Code properly. Just have one quick question, I need to send this to team members and do not want them to know the Password to unprotect so there will be no tampering of data. In your code you have mentioned pwd = Test in 4th line which can be accessible by anyone. Is there any way I will be only knowing the password to unprotect without getting displayed to all. Regards, Kaushik Savla On Fri, Apr 5, 2013 at 8:41 PM, KAUSHIK SAVLA savla.kaus...@gmail.com wrote: Thank You for the help. On Friday, April 5, 2013, Paul Schreiner schreiner_p...@att.net wrote: Here's what I did: In the Sheet module, create a double-click event: Option Explicit Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean) Dim pwd pwd = Test If (Target.Count = 1) Then If (Target.Value X = X) Then If (Target.Column = 4) Or (Target.Column = 5) Then ActiveSheet.Unprotect Password:=pwd ActiveCell.Value = Now() ActiveSheet.Protect DrawingObjects:=True, _ Contents:=True, _ Scenarios:=True, _ AllowFormattingCells:=True, _ AllowFormattingColumns:=True, _ AllowFormattingRows:=True, _ AllowSorting:=True, _ AllowFiltering:=True, _ Password:=pwd End If End If End If End Sub --- I changed the display format of columns D-F to display time. In column F, I entered the formula: =IF(AND(D2,E2),E2-D2,) and copied it down the column. I then changed the format of all cells in the sheet to locked and protected the sheet. As you can see in
Re: $$Excel-Macros$$ Required Roundup Formula.............
Here's what I would do: since you're wanting to round to 5 or 10's, I'd multiply the number by 2, then you're technically rounding by 10's or 20's, which, is the same as rounding by 10's. Then, divide the number by 10 (which moves the decimal point) and round the number to an even integer. By multiplying by 10, your result is the number rounded to 10's. Dividing by 2 returns the value to the base you started with. so, your formula looks like: =ROUND((A2*2)/10,0)*10/2 Paul - “Do all the good you can, By all the means you can, In all the ways you can, In all the places you can, At all the times you can, To all the people you can, As long as ever you can.” - John Wesley - From: Kuldeep Singh naukrikuld...@gmail.com To: excel-macros@googlegroups.com excel-macros@googlegroups.com; excelvbacli...@googlegroups.com; excel-vba-h...@googlegroups.com Sent: Tue, April 16, 2013 10:47:45 AM Subject: $$Excel-Macros$$ Required Roundup Formula. Hi Experts, I want to roundup formula but according to my requirement. requirement is attached If value is digit 2,3,4 output 5 Other value is digit 6,7,8,9 output 10 Thanks in Advance. Regards, Kuldeep Singh-- 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?hl=en. For more options, visit https://groups.google.com/groups/opt_out. -- 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?hl=en. For more options, visit https://groups.google.com/groups/opt_out.
Re: $$Excel-Macros$$ Required Roundup Formula.............
Thanks paul but it's not working. On Tue, Apr 16, 2013 at 8:32 PM, Paul Schreiner schreiner_p...@att.netwrote: Here's what I would do: since you're wanting to round to 5 or 10's, I'd multiply the number by 2, then you're technically rounding by 10's or 20's, which, is the same as rounding by 10's. Then, divide the number by 10 (which moves the decimal point) and round the number to an even integer. By multiplying by 10, your result is the number rounded to 10's. Dividing by 2 returns the value to the base you started with. so, your formula looks like: =ROUND((A2*2)/10,0)*10/2 *Paul* - *“Do all the good you can, By all the means you can, In all the ways you can, In all the places you can, At all the times you can, To all the people you can, As long as ever you can.” - John Wesley *- -- *From:* Kuldeep Singh naukrikuld...@gmail.com *To:* excel-macros@googlegroups.com excel-macros@googlegroups.com; excelvbacli...@googlegroups.com; excel-vba-h...@googlegroups.com *Sent:* Tue, April 16, 2013 10:47:45 AM *Subject:* $$Excel-Macros$$ Required Roundup Formula. Hi Experts, I want to roundup formula but according to my requirement. requirement is attached *If value is digit 2,3,4 output 5 Other value is digit 6,7,8,9 output 10* Thanks in Advance. Regards, Kuldeep Singh -- 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?hl=en. For more options, visit https://groups.google.com/groups/opt_out. -- 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?hl=en. For more options, visit https://groups.google.com/groups/opt_out. -- Regards, Kuldeep Singh Info Edge India Limited (naukri.com) Phone.: +91-0120-4841100, Extn.: 2467, 9716615535 naukrikuld...@gmail.com || www.naukri.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
Re: $$Excel-Macros$$ Required Roundup Formula.............
What's not working? I placed this formula in your worksheet, copied it down, and the results exactly matched what you listed as expected results. Paul - “Do all the good you can, By all the means you can, In all the ways you can, In all the places you can, At all the times you can, To all the people you can, As long as ever you can.” - John Wesley - From: Kuldeep Singh naukrikuld...@gmail.com To: excel-macros@googlegroups.com excel-macros@googlegroups.com Sent: Tue, April 16, 2013 11:12:18 AM Subject: Re: $$Excel-Macros$$ Required Roundup Formula. Thanks paul but it's not working. On Tue, Apr 16, 2013 at 8:32 PM, Paul Schreiner schreiner_p...@att.net wrote: Here's what I would do: since you're wanting to round to 5 or 10's, I'd multiply the number by 2, then you're technically rounding by 10's or 20's, which, is the same as rounding by 10's. Then, divide the number by 10 (which moves the decimal point) and round the number to an even integer. By multiplying by 10, your result is the number rounded to 10's. Dividing by 2 returns the value to the base you started with. so, your formula looks like: =ROUND((A2*2)/10,0)*10/2 Paul - “Do all the good you can, By all the means you can, In all the ways you can, In all the places you can, At all the times you can, To all the people you can, As long as ever you can.” - John Wesley - From: Kuldeep Singh naukrikuld...@gmail.com To: excel-macros@googlegroups.com excel-macros@googlegroups.com; excelvbacli...@googlegroups.com; excel-vba-h...@googlegroups.com Sent: Tue, April 16, 2013 10:47:45 AM Subject: $$Excel-Macros$$ Required Roundup Formula. Hi Experts, I want to roundup formula but according to my requirement. requirement is attached If value is digit 2,3,4 output 5 Other value is digit 6,7,8,9 output 10 Thanks in Advance. Regards, Kuldeep Singh-- 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?hl=en. For more options, visit https://groups.google.com/groups/opt_out. -- 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?hl=en. For more options, visit https://groups.google.com/groups/opt_out. -- Regards, Kuldeep Singh Info Edge India Limited (naukri.com) Phone.: +91-0120-4841100, Extn.: 2467, 9716615535 naukrikuld...@gmail.com || www.naukri.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
RE: $$Excel-Macros$$ Required Roundup Formula.............
Hi Kuldeep I think this formula fullfil your requirement. =ROUNDUP((A2*2)/10,0)*10/2 Regards Priti verma From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Kuldeep Singh Sent: 16 April 2013 8:17 To: excel-macros@googlegroups.com; excelvbacli...@googlegroups.com; excel-vba-h...@googlegroups.com Subject: $$Excel-Macros$$ Required Roundup Formula. Hi Experts, I want to roundup formula but according to my requirement. requirement is attached If value is digit 2,3,4 output 5 Other value is digit 6,7,8,9 output 10 Thanks in Advance. Regards, Kuldeep Singh -- 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?hl=en. For more options, visit https://groups.google.com/groups/opt_out. -- 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?hl=en. For more options, visit https://groups.google.com/groups/opt_out.
Re: $$Excel-Macros$$ Required Roundup Formula.............
Since you've ruled out 5 and 10, I would've thought =MROUND(C1+5/2,5) should be fine Regards, Sam Mathai Chacko On Tue, Apr 16, 2013 at 8:46 PM, Priti_verma pritiverma1...@gmail.comwrote: Hi Kuldeep I think this formula fullfil your requirement. =ROUNDUP((A2*2)/10,0)*10/2 Regards Priti verma ** ** *From:* excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com] *On Behalf Of *Kuldeep Singh *Sent:* 16 April 2013 8:17 *To:* excel-macros@googlegroups.com; excelvbacli...@googlegroups.com; excel-vba-h...@googlegroups.com *Subject:* $$Excel-Macros$$ Required Roundup Formula. ** ** Hi Experts, ** ** I want to roundup formula but according to my requirement. requirement is attached ** ** *If value is digit 2,3,4 output 5 Other value is digit 6,7,8,9 output 10** *** ** ** Thanks in Advance. Regards, Kuldeep Singh -- 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?hl=en. For more options, visit https://groups.google.com/groups/opt_out. -- 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?hl=en. For more options, visit https://groups.google.com/groups/opt_out. -- Sam Mathai Chacko -- 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?hl=en. For more options, visit https://groups.google.com/groups/opt_out.
Re: $$Excel-Macros$$ VBA to Open Access When User Has Runtime Access Installed
For the sake of you opening up your options for a response, why don't you tell us why you want to open the access database using code? On Mon, Apr 15, 2013 at 6:01 PM, neilstewa...@sky.com wrote: Hi all, I am stuck, hope someone can help me... I a using the following code in Excel, to open an Access database. It works fine for users with Full Version Access installed however I get an Activex cannot create object error for users who only have Access runtime installed (most users). Is there a way to overcome this issue? I have this golbal declaration... Global appAccess As Object An then this code resides in an onButtonCLick function... Set appAccess = CreateObject(Access.Application) Application.DisplayAlerts = False Set appAccess = GetObject(K:\Folder\Database.mdb) Thanks in advance for your 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?hl=en. For more options, visit https://groups.google.com/groups/opt_out. -- Sam Mathai Chacko -- 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?hl=en. For more options, visit https://groups.google.com/groups/opt_out.
Re: $$Excel-Macros$$ Required Roundup Formula.............
Thanks *Paul Sam*, your formula is working fine. Regards, Kuldeep Singh On Tue, Apr 16, 2013 at 11:23 PM, Sam Mathai Chacko samde...@gmail.comwrote: Since you've ruled out 5 and 10, I would've thought =MROUND(C1+5/2,5) should be fine Regards, Sam Mathai Chacko On Tue, Apr 16, 2013 at 8:46 PM, Priti_verma pritiverma1...@gmail.comwrote: Hi Kuldeep I think this formula fullfil your requirement. =ROUNDUP((A2*2)/10,0)*10/2 Regards Priti verma ** ** *From:* excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com] *On Behalf Of *Kuldeep Singh *Sent:* 16 April 2013 8:17 *To:* excel-macros@googlegroups.com; excelvbacli...@googlegroups.com; excel-vba-h...@googlegroups.com *Subject:* $$Excel-Macros$$ Required Roundup Formula. ** ** Hi Experts, ** ** I want to roundup formula but according to my requirement. requirement is attached ** ** *If value is digit 2,3,4 output 5 Other value is digit 6,7,8,9 output 10* ** ** Thanks in Advance. Regards, Kuldeep Singh -- 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?hl=en. For more options, visit https://groups.google.com/groups/opt_out. -- 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?hl=en. For more options, visit https://groups.google.com/groups/opt_out. -- Sam Mathai Chacko -- 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?hl=en. For more options, visit https://groups.google.com/groups/opt_out. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s