Thanks Rajan for your prompt reply.
On Sat, May 26, 2012 at 2:48 PM, Rajan_Verma <rajanverma1...@gmail.com>wrote:
> 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.
>
>
> ------------------------------------------------------------------------------------------------------
> 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****
>
> --
> 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
> ****
>
> To unsubscribe, send a blank email to
> excel-macros+unsubscr...@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
> ****
>
> To unsubscribe, send a blank email to
> excel-macros+unsubscr...@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
>
> To unsubscribe, send a blank email to
> excel-macros+unsubscr...@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
>
> To unsubscribe, send a blank email to
> excel-macros+unsubscr...@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
To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com
