Re: $$Excel-Macros$$ 2 Values in the same cell
Thanks Rajan, I am seeing a runtime error while selecting the range for the rngOutput..Could you please advice on this.I have selected range from A1:C14 *Set rngOutput = Application.InputBox(Please select Output Cells, , , , , , , 8)* Cheers, Prabhakar On Wed, May 16, 2012 at 6:23 PM, Rajan_Verma rajanverma1...@gmail.comwrote: *Are you looking for this* ** ** See the attached Sheet ** ** *Sub ManageThem()* ** *Dim rngRange As Range* *Dim rngOutput As Range* *Dim rngCell As Range* *Dim lngLoopCounter As Long* *Dim rngBorders As Range* *Set rngRange = Application.InputBox(Please select value(s), , , , , , , 8)* *If rngRange.Columns.Count 2 Or rngRange.Columns.Count 2 Then* *MsgBox Please Select Correct Range, vbInformation* *End* *End If* ** *lngLoopCounter = 0* *Set rngOutput = Application.InputBox(Please select Output Cells, , , , , , , 8)* ** *For Each rngCell In rngRange* *If rngCell.Value Then* *rngOutput.Offset(lngLoopCounter).Offset(-1, -1).Value = rngCell.Value* *rngOutput.Offset(lngLoopCounter).Offset(1, 1).Value = rngCell.Value* *Set rngBorders = Range(rngOutput.Offset(lngLoopCounter).Offset(-1, -1), rngOutput.Offset(lngLoopCounter).Offset(1, 1))* *With rngBorders* *.Borders(xlEdgeLeft).Weight = xlThin* *.Borders(xlEdgeRight).Weight = xlThin* *.Borders(xlEdgeTop).Weight = xlThin* *.Borders(xlEdgeBottom).Weight = xlThin* *End With* *lngLoopCounter = lngLoopCounter + 3* ** *Else* *End* *End If* *Next* ** *End Sub* * * * * *Regards* *Rajan verma* *+91 7838100659 [IM-Gtalk]* ** ** *From:* excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com] *On Behalf Of *David Grugeon *Sent:* 16 May 2012 11:59 *To:* excel-macros@googlegroups.com *Subject:* Re: $$Excel-Macros$$ 2 Values in the same cell ** ** The answer is No AFAICS ** ** However you could use two columns (one formatted left top and one right bottom). Put borders around the two but no border between them. If you want the gridlines to disappear you can give both cells a fill colour of white. ** ** Regards David Grugeon On 16 May 2012 05:44, joseph camill joseph.cam...@gmail.com wrote: ** ** On Wed, May 16, 2012 at 1:08 AM, joseph camill joseph.cam...@gmail.com wrote: Attached is an example ** ** On Wed, May 16, 2012 at 12:48 AM, joseph.cam...@gmail.com wrote: Hi, Is it possible to concatenate two values in one cell and seperate the first value to top left and second value to bottom right of the same cell. For e.g. £25m and €12m both in cell a1. And both are clearly seperate from each other. Thanks, Joseph Sent on my BlackBerry® from Vodafone -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com ** ** ** ** -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com ** ** -- David Grugeon -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula
Re: $$Excel-Macros$$ 2 Values in the same cell
Thanks Buddy..I got... Cheers, Prabhakar On Sat, May 26, 2012 at 2:03 PM, Rajan_Verma rajanverma1...@gmail.comwrote: Only select one cell For Output ** ** * * *Regards* *Rajan verma* *+91 7838100659 [IM-Gtalk]* ** ** *From:* excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com] *On Behalf Of *rao *Sent:* 26 May 2012 1:46 *To:* excel-macros@googlegroups.com *Subject:* Re: $$Excel-Macros$$ 2 Values in the same cell ** ** Thanks Rajan, I am seeing a runtime error while selecting the range for the rngOutput..Could you please advice on this.I have selected range from A1:C14 *Set rngOutput = Application.InputBox(Please select Output Cells, , , , , , , 8)* ** ** Cheers, Prabhakar ** ** On Wed, May 16, 2012 at 6:23 PM, Rajan_Verma rajanverma1...@gmail.com wrote: *Are you looking for this* See the attached Sheet *Sub ManageThem()* ** *Dim rngRange As Range* *Dim rngOutput As Range* *Dim rngCell As Range* *Dim lngLoopCounter As Long* *Dim rngBorders As Range* *Set rngRange = Application.InputBox(Please select value(s), , , , , , , 8)* *If rngRange.Columns.Count 2 Or rngRange.Columns.Count 2 Then* *MsgBox Please Select Correct Range, vbInformation* *End* * End If* ** *lngLoopCounter = 0* *Set rngOutput = Application.InputBox(Please select Output Cells, , , , , , , 8)* ** *For Each rngCell In rngRange* *If rngCell.Value Then* *rngOutput.Offset(lngLoopCounter).Offset(-1, -1).Value = rngCell.Value* *rngOutput.Offset(lngLoopCounter).Offset(1, 1).Value = rngCell.Value* *Set rngBorders = Range(rngOutput.Offset(lngLoopCounter).Offset(-1, -1), rngOutput.Offset(lngLoopCounter).Offset(1, 1))* *With rngBorders* *.Borders(xlEdgeLeft).Weight = xlThin* *.Borders(xlEdgeRight).Weight = xlThin* *.Borders(xlEdgeTop).Weight = xlThin* *.Borders(xlEdgeBottom).Weight = xlThin* *End With* *lngLoopCounter = lngLoopCounter + 3* ** *Else* *End* *End If* *Next* ** *End Sub* * * * * *Regards* *Rajan verma* *+91 7838100659 [IM-Gtalk]* *From:* excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com] *On Behalf Of *David Grugeon *Sent:* 16 May 2012 11:59 *To:* excel-macros@googlegroups.com *Subject:* Re: $$Excel-Macros$$ 2 Values in the same cell The answer is No AFAICS However you could use two columns (one formatted left top and one right bottom). Put borders around the two but no border between them. If you want the gridlines to disappear you can give both cells a fill colour of white. Regards David Grugeon On 16 May 2012 05:44, joseph camill joseph.cam...@gmail.com wrote: On Wed, May 16, 2012 at 1:08 AM, joseph camill joseph.cam...@gmail.com wrote: Attached is an example On Wed, May 16, 2012 at 12:48 AM, joseph.cam...@gmail.com wrote: Hi, Is it possible to concatenate two values in one cell and seperate the first value to top left and second value to bottom right of the same cell. For e.g. £25m and €12m both in cell a1. And both are clearly seperate from each other. Thanks, Joseph Sent on my BlackBerry® from Vodafone -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security
Re: $$Excel-Macros$$ 2 Values in the same cell
Hi , I am not able to understand this part, could you please explain. rngOutput.Offset(lngLoopCounter).Offset(-1, -1).Value = rngCell.Value rngOutput.Offset(lngLoopCounter).Offset(1, 1).Value = rngCell.Value cheers, Prabhakar On Sat, May 26, 2012 at 2:41 PM, rao raomb...@gmail.com wrote: Thanks Buddy..I got... Cheers, Prabhakar On Sat, May 26, 2012 at 2:03 PM, Rajan_Verma rajanverma1...@gmail.comwrote: Only select one cell For Output ** ** * * *Regards* *Rajan verma* *+91 7838100659 [IM-Gtalk]* ** ** *From:* excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com] *On Behalf Of *rao *Sent:* 26 May 2012 1:46 *To:* excel-macros@googlegroups.com *Subject:* Re: $$Excel-Macros$$ 2 Values in the same cell ** ** Thanks Rajan, I am seeing a runtime error while selecting the range for the rngOutput..Could you please advice on this.I have selected range from A1:C14 *Set rngOutput = Application.InputBox(Please select Output Cells, , , , , , , 8)* ** ** Cheers, Prabhakar ** ** On Wed, May 16, 2012 at 6:23 PM, Rajan_Verma rajanverma1...@gmail.com wrote: *Are you looking for this* See the attached Sheet *Sub ManageThem()* ** *Dim rngRange As Range* *Dim rngOutput As Range* *Dim rngCell As Range* *Dim lngLoopCounter As Long* *Dim rngBorders As Range* *Set rngRange = Application.InputBox(Please select value(s), , , , , , , 8)* *If rngRange.Columns.Count 2 Or rngRange.Columns.Count 2 Then * *MsgBox Please Select Correct Range, vbInformation* *End* * End If* ** *lngLoopCounter = 0* *Set rngOutput = Application.InputBox(Please select Output Cells, , , , , , , 8)* ** *For Each rngCell In rngRange* *If rngCell.Value Then* *rngOutput.Offset(lngLoopCounter).Offset(-1, -1).Value = rngCell.Value* *rngOutput.Offset(lngLoopCounter).Offset(1, 1).Value = rngCell.Value* *Set rngBorders = Range(rngOutput.Offset(lngLoopCounter).Offset(-1, -1), rngOutput.Offset(lngLoopCounter).Offset(1, 1))* *With rngBorders* *.Borders(xlEdgeLeft).Weight = xlThin* *.Borders(xlEdgeRight).Weight = xlThin* *.Borders(xlEdgeTop).Weight = xlThin* *.Borders(xlEdgeBottom).Weight = xlThin* *End With* *lngLoopCounter = lngLoopCounter + 3* ** *Else* *End* *End If* *Next* ** *End Sub* * * * * *Regards* *Rajan verma* *+91 7838100659 [IM-Gtalk]* *From:* excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com] *On Behalf Of *David Grugeon *Sent:* 16 May 2012 11:59 *To:* excel-macros@googlegroups.com *Subject:* Re: $$Excel-Macros$$ 2 Values in the same cell The answer is No AFAICS However you could use two columns (one formatted left top and one right bottom). Put borders around the two but no border between them. If you want the gridlines to disappear you can give both cells a fill colour of white. Regards David Grugeon On 16 May 2012 05:44, joseph camill joseph.cam...@gmail.com wrote: On Wed, May 16, 2012 at 1:08 AM, joseph camill joseph.cam...@gmail.com wrote: Attached is an example On Wed, May 16, 2012 at 12:48 AM, joseph.cam...@gmail.com wrote: Hi, Is it possible to concatenate two values in one cell and seperate the first value to top left and second value to bottom right of the same cell. For e.g. £25m and €12m both in cell a1. And both are clearly seperate from each other. Thanks, Joseph Sent on my BlackBerry® from Vodafone -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use
RE: $$Excel-Macros$$ 2 Values in the same cell
These lines is just to adjust values within cells If Target Cell is rngOutput.Offset(lngLoopCounter) then rngOutput.Offset(lngLoopCounter).Offset(-1, -1).Value = rngCell.Value Put the value in TopLeft cell Target Cell rngOutput.Offset(lngLoopCounter).Offset(1, 1).Value = rngCell.Value For Put the value in BottomRight Cell from Target Cell Regards Rajan verma +91 7838100659 [IM-Gtalk] From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of rao Sent: 26 May 2012 2:44 To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ 2 Values in the same cell Hi , I am not able to understand this part, could you please explain. rngOutput.Offset(lngLoopCounter).Offset(-1, -1).Value = rngCell.Value rngOutput.Offset(lngLoopCounter).Offset(1, 1).Value = rngCell.Value cheers, Prabhakar On Sat, May 26, 2012 at 2:41 PM, rao raomb...@gmail.com wrote: Thanks Buddy..I got... Cheers, Prabhakar On Sat, May 26, 2012 at 2:03 PM, Rajan_Verma rajanverma1...@gmail.com wrote: Only select one cell For Output Regards Rajan verma +91 7838100659 [IM-Gtalk] From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of rao Sent: 26 May 2012 1:46 To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ 2 Values in the same cell Thanks Rajan, I am seeing a runtime error while selecting the range for the rngOutput..Could you please advice on this.I have selected range from A1:C14 Set rngOutput = Application.InputBox(Please select Output Cells, , , , , , , 8) Cheers, Prabhakar On Wed, May 16, 2012 at 6:23 PM, Rajan_Verma rajanverma1...@gmail.com wrote: Are you looking for this See the attached Sheet Sub ManageThem() Dim rngRange As Range Dim rngOutput As Range Dim rngCell As Range Dim lngLoopCounter As Long Dim rngBorders As Range Set rngRange = Application.InputBox(Please select value(s), , , , , , , 8) If rngRange.Columns.Count 2 Or rngRange.Columns.Count 2 Then MsgBox Please Select Correct Range, vbInformation End End If lngLoopCounter = 0 Set rngOutput = Application.InputBox(Please select Output Cells, , , , , , , 8) For Each rngCell In rngRange If rngCell.Value Then rngOutput.Offset(lngLoopCounter).Offset(-1, -1).Value = rngCell.Value rngOutput.Offset(lngLoopCounter).Offset(1, 1).Value = rngCell.Value Set rngBorders = Range(rngOutput.Offset(lngLoopCounter).Offset(-1, -1), rngOutput.Offset(lngLoopCounter).Offset(1, 1)) With rngBorders .Borders(xlEdgeLeft).Weight = xlThin .Borders(xlEdgeRight).Weight = xlThin .Borders(xlEdgeTop).Weight = xlThin .Borders(xlEdgeBottom).Weight = xlThin End With lngLoopCounter = lngLoopCounter + 3 Else End End If Next End Sub Regards Rajan verma +91 7838100659 [IM-Gtalk] From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of David Grugeon Sent: 16 May 2012 11:59 To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ 2 Values in the same cell The answer is No AFAICS However you could use two columns (one formatted left top and one right bottom). Put borders around the two but no border between them. If you want the gridlines to disappear you can give both cells a fill colour of white. Regards David Grugeon On 16 May 2012 05:44, joseph camill joseph.cam...@gmail.com wrote: On Wed, May 16, 2012 at 1:08 AM, joseph camill joseph.cam...@gmail.com wrote: Attached is an example On Wed, May 16, 2012 at 12:48 AM, joseph.cam...@gmail.com wrote: Hi, Is it possible to concatenate two values in one cell and seperate the first value to top left and second value to bottom right of the same cell. For e.g. £25m and €12m both in cell a1. And both are clearly seperate from each other. Thanks, Joseph Sent on my BlackBerry® from Vodafone -- 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
Re: $$Excel-Macros$$ 2 Values in the same cell
Thanks Rajan for your prompt reply. On Sat, May 26, 2012 at 2:48 PM, Rajan_Verma rajanverma1...@gmail.comwrote: These lines is just to adjust values within cells ** ** If Target Cell is rngOutput.Offset(lngLoopCounter) then rngOutput.Offset(lngLoopCounter).Offset(-1, -1).Value = rngCell.Value Put the value in TopLeft cell Target Cell rngOutput.Offset(lngLoopCounter).Offset(1, 1).Value = rngCell.Value For Put the value in BottomRight Cell from Target Cell ** ** * * *Regards* *Rajan verma* *+91 7838100659 [IM-Gtalk]* ** ** *From:* excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com] *On Behalf Of *rao *Sent:* 26 May 2012 2:44 *To:* excel-macros@googlegroups.com *Subject:* Re: $$Excel-Macros$$ 2 Values in the same cell ** ** Hi , I am not able to understand this part, could you please explain. rngOutput.Offset(lngLoopCounter).Offset(-1, -1).Value = rngCell.Value rngOutput.Offset(lngLoopCounter).Offset(1, 1).Value = rngCell.Value cheers, Prabhakar On Sat, May 26, 2012 at 2:41 PM, rao raomb...@gmail.com wrote: Thanks Buddy..I got... ** ** ** ** Cheers, Prabhakar ** ** On Sat, May 26, 2012 at 2:03 PM, Rajan_Verma rajanverma1...@gmail.com wrote: Only select one cell For Output * * *Regards* *Rajan verma* *+91 7838100659 [IM-Gtalk]* *From:* excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com] *On Behalf Of *rao *Sent:* 26 May 2012 1:46 *To:* excel-macros@googlegroups.com *Subject:* Re: $$Excel-Macros$$ 2 Values in the same cell Thanks Rajan, I am seeing a runtime error while selecting the range for the rngOutput..Could you please advice on this.I have selected range from A1:C14 *Set rngOutput = Application.InputBox(Please select Output Cells, , , , , , , 8)* Cheers, Prabhakar On Wed, May 16, 2012 at 6:23 PM, Rajan_Verma rajanverma1...@gmail.com wrote: *Are you looking for this* See the attached Sheet *Sub ManageThem()* ** *Dim rngRange As Range* *Dim rngOutput As Range* *Dim rngCell As Range* *Dim lngLoopCounter As Long* *Dim rngBorders As Range* *Set rngRange = Application.InputBox(Please select value(s), , , , , , , 8)* *If rngRange.Columns.Count 2 Or rngRange.Columns.Count 2 Then* *MsgBox Please Select Correct Range, vbInformation* *End* * End If* ** *lngLoopCounter = 0* *Set rngOutput = Application.InputBox(Please select Output Cells, , , , , , , 8)* ** *For Each rngCell In rngRange* *If rngCell.Value Then* *rngOutput.Offset(lngLoopCounter).Offset(-1, -1).Value = rngCell.Value* *rngOutput.Offset(lngLoopCounter).Offset(1, 1).Value = rngCell.Value* *Set rngBorders = Range(rngOutput.Offset(lngLoopCounter).Offset(-1, -1), rngOutput.Offset(lngLoopCounter).Offset(1, 1))* *With rngBorders* *.Borders(xlEdgeLeft).Weight = xlThin* *.Borders(xlEdgeRight).Weight = xlThin* *.Borders(xlEdgeTop).Weight = xlThin* *.Borders(xlEdgeBottom).Weight = xlThin* *End With* *lngLoopCounter = lngLoopCounter + 3* ** *Else* *End* *End If* *Next* ** *End Sub* * * * * *Regards* *Rajan verma* *+91 7838100659 [IM-Gtalk]* *From:* excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com] *On Behalf Of *David Grugeon *Sent:* 16 May 2012 11:59 *To:* excel-macros@googlegroups.com *Subject:* Re: $$Excel-Macros$$ 2 Values in the same cell The answer is No AFAICS However you could use two columns (one formatted left top and one right bottom). Put borders around the two but no border between them. If you want the gridlines to disappear you can give both cells a fill colour of white. Regards David Grugeon On 16 May 2012 05:44, joseph camill joseph.cam...@gmail.com wrote: On Wed, May 16, 2012 at 1:08 AM, joseph camill joseph.cam...@gmail.com wrote: Attached is an example On Wed, May 16, 2012 at 12:48 AM, joseph.cam...@gmail.com wrote: Hi, Is it possible to concatenate two values in one cell and seperate the first value to top left and second value to bottom right of the same cell. For e.g. £25m and €12m both in cell a1. And both are clearly seperate from each other. Thanks, Joseph Sent on my BlackBerry® from Vodafone
Re: $$Excel-Macros$$ 2 Values in the same cell
The answer is No AFAICS However you could use two columns (one formatted left top and one right bottom). Put borders around the two but no border between them. If you want the gridlines to disappear you can give both cells a fill colour of white. Regards David Grugeon On 16 May 2012 05:44, joseph camill joseph.cam...@gmail.com wrote: On Wed, May 16, 2012 at 1:08 AM, joseph camill joseph.cam...@gmail.comwrote: Attached is an example On Wed, May 16, 2012 at 12:48 AM, joseph.cam...@gmail.com wrote: Hi, Is it possible to concatenate two values in one cell and seperate the first value to top left and second value to bottom right of the same cell. For e.g. £25m and €12m both in cell a1. And both are clearly seperate from each other. Thanks, Joseph Sent on my BlackBerry® from Vodafone -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- David Grugeon -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
Re: $$Excel-Macros$$ 2 Values in the same cell
Hi, PFA... * * * MARIES* Excel Inspiration http://xcel-inspiration.blogspot.com/ -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com 2 values in one cell.xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
Re: $$Excel-Macros$$ 2 Values in the same cell
or, replace the values with formulas =d1”“e1. See attached Don Guillett Microsoft MVP Excel SalesAid Software dguille...@gmail.com From: Maries Sent: Wednesday, May 16, 2012 6:04 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ 2 Values in the same cell Hi, PFA... MARIES Excel Inspiration -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com 2 values in one cell.xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
RE: $$Excel-Macros$$ 2 Values in the same cell
Are you looking for this See the attached Sheet Sub ManageThem() Dim rngRange As Range Dim rngOutput As Range Dim rngCell As Range Dim lngLoopCounter As Long Dim rngBorders As Range Set rngRange = Application.InputBox(Please select value(s), , , , , , , 8) If rngRange.Columns.Count 2 Or rngRange.Columns.Count 2 Then MsgBox Please Select Correct Range, vbInformation End End If lngLoopCounter = 0 Set rngOutput = Application.InputBox(Please select Output Cells, , , , , , , 8) For Each rngCell In rngRange If rngCell.Value Then rngOutput.Offset(lngLoopCounter).Offset(-1, -1).Value = rngCell.Value rngOutput.Offset(lngLoopCounter).Offset(1, 1).Value = rngCell.Value Set rngBorders = Range(rngOutput.Offset(lngLoopCounter).Offset(-1, -1), rngOutput.Offset(lngLoopCounter).Offset(1, 1)) With rngBorders .Borders(xlEdgeLeft).Weight = xlThin .Borders(xlEdgeRight).Weight = xlThin .Borders(xlEdgeTop).Weight = xlThin .Borders(xlEdgeBottom).Weight = xlThin End With lngLoopCounter = lngLoopCounter + 3 Else End End If Next End Sub Regards Rajan verma +91 7838100659 [IM-Gtalk] From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of David Grugeon Sent: 16 May 2012 11:59 To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ 2 Values in the same cell The answer is No AFAICS However you could use two columns (one formatted left top and one right bottom). Put borders around the two but no border between them. If you want the gridlines to disappear you can give both cells a fill colour of white. Regards David Grugeon On 16 May 2012 05:44, joseph camill joseph.cam...@gmail.com wrote: On Wed, May 16, 2012 at 1:08 AM, joseph camill joseph.cam...@gmail.com wrote: Attached is an example On Wed, May 16, 2012 at 12:48 AM, joseph.cam...@gmail.com wrote: Hi, Is it possible to concatenate two values in one cell and seperate the first value to top left and second value to bottom right of the same cell. For e.g. £25m and €12m both in cell a1. And both are clearly seperate from each other. Thanks, Joseph Sent on my BlackBerry® from Vodafone -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- David Grugeon -- 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
Re: $$Excel-Macros$$ 2 Values in the same cell
Attached is an example On Wed, May 16, 2012 at 12:48 AM, joseph.cam...@gmail.com wrote: Hi, Is it possible to concatenate two values in one cell and seperate the first value to top left and second value to bottom right of the same cell. For e.g. £25m and €12m both in cell a1. And both are clearly seperate from each other. Thanks, Joseph Sent on my BlackBerry® from Vodafone -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com 2 values in one cell.xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
Re: $$Excel-Macros$$ 2 Values in the same cell
On Wed, May 16, 2012 at 1:08 AM, joseph camill joseph.cam...@gmail.comwrote: Attached is an example On Wed, May 16, 2012 at 12:48 AM, joseph.cam...@gmail.com wrote: Hi, Is it possible to concatenate two values in one cell and seperate the first value to top left and second value to bottom right of the same cell. For e.g. £25m and €12m both in cell a1. And both are clearly seperate from each other. Thanks, Joseph Sent on my BlackBerry® from Vodafone -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com 2 values in one cell.xls Description: MS-Excel spreadsheet