subject:"\"RE\\\: $$Excel\\\-Macros$$ 2 Values in the same cell\""

Re: $$Excel-Macros$$ 2 Values in the same cell

2012-05-26 Thread rao

Thanks Rajan for your prompt reply.

On Sat, May 26, 2012 at 2:48 PM, Rajan_Verma 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  wrote:
>
> Thanks Buddy..I got...
>
> ** **
>
> ** **
>
> Cheers,
>
> Prabhakar
>
> ** **
>
> On Sat, May 26, 2012 at 2:03 PM, Rajan_Verma 
> 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 
> 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" AF

RE: $$Excel-Macros$$ 2 Values in the same cell

2012-05-26 Thread Rajan_Verma

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  wrote:

Thanks Buddy..I got...

 

 

Cheers,

Prabhakar

 

On Sat, May 26, 2012 at 2:03 PM, Rajan_Verma  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  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  wrote:

 

On Wed, May 16, 2012 at 1:08 AM, joseph camill  wrote:

Attached is an example

 

On Wed, May 16, 2012 at 12:48 AM,  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 thi

Re: $$Excel-Macros$$ 2 Values in the same cell

2012-05-26 Thread rao

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  wrote:

> Thanks Buddy..I got...
>
>
> Cheers,
> Prabhakar
>
> On Sat, May 26, 2012 at 2:03 PM, Rajan_Verma 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 
>> 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  wrote:
>>
>>  
>>
>> On Wed, May 16, 2012 at 1:08 AM, joseph camill 
>>

Re: $$Excel-Macros$$ 2 Values in the same cell

2012-05-26 Thread rao

Thanks Buddy..I got...


Cheers,
Prabhakar
On Sat, May 26, 2012 at 2:03 PM, Rajan_Verma 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 
> 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  wrote:
>
>  
>
> On Wed, May 16, 2012 at 1:08 AM, joseph camill 
> wrote:
>
> Attached is an example
>
>  
>
> On Wed, May 16, 2012 at 12:48 AM,  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-pr

RE: $$Excel-Macros$$ 2 Values in the same cell

2012-05-26 Thread Rajan_Verma

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  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  wrote:

 

On Wed, May 16, 2012 at 1:08 AM, joseph camill  wrote:

Attached is an example

 

On Wed, May 16, 2012 at 12:48 AM,  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

Re: $$Excel-Macros$$ 2 Values in the same cell

2012-05-26 Thread rao

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 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  wrote:
>
> ** **
>
> On Wed, May 16, 2012 at 1:08 AM, joseph camill 
> wrote:
>
> Attached is an example
>
> ** **
>
> On Wed, May 16, 2012 at 12:48 AM,  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.
>
>

RE: $$Excel-Macros$$ 2 Values in the same cell

2012-05-16 Thread Rajan_Verma

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  wrote:

 

On Wed, May 16, 2012 at 1:08 AM, joseph camill  wrote:

Attached is an example

 

On Wed, May 16, 2012 at 12:48 AM,  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

2012-05-16 Thread dguillett1

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

2012-05-16 Thread Maries

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


2 values in one cell.xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet

Re: $$Excel-Macros$$ 2 Values in the same cell

2012-05-15 Thread David Grugeon

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  wrote:

>
>
> On Wed, May 16, 2012 at 1:08 AM, joseph camill wrote:
>
>> Attached is an example
>>
>>
>> On Wed, May 16, 2012 at 12:48 AM,  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

2012-05-15 Thread joseph camill

On Wed, May 16, 2012 at 1:08 AM, joseph camill wrote:

> Attached is an example
>
>
> On Wed, May 16, 2012 at 12:48 AM,  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

Re: $$Excel-Macros$$ 2 Values in the same cell

2012-05-15 Thread joseph camill

Attached is an example

On Wed, May 16, 2012 at 12:48 AM,  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

RE: $$Excel-Macros$$ 2 Values in the same cell

Re: $$Excel-Macros$$ 2 Values in the same cell

Re: $$Excel-Macros$$ 2 Values in the same cell

RE: $$Excel-Macros$$ 2 Values in the same cell

Re: $$Excel-Macros$$ 2 Values in the same cell

RE: $$Excel-Macros$$ 2 Values in the same cell

Re: $$Excel-Macros$$ 2 Values in the same cell

Re: $$Excel-Macros$$ 2 Values in the same cell

Re: $$Excel-Macros$$ 2 Values in the same cell

Re: $$Excel-Macros$$ 2 Values in the same cell

Re: $$Excel-Macros$$ 2 Values in the same cell

12 matches

Site Navigation

Mail list logo

Footer information