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 
<mailto:excel-macros%2bunsubscr...@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

Reply via email to