Hi,


I have cell A1 = 10 and B1 = -

This must change A1 to -10

I have no other option, I cannot use any other cells for joining,

Any others Ideas?

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...mming/200601/1

Want to explain this some more??
Are you saying ,if cell B1 is negative the A1 is negative?

Try this small macro:


Sub Macro1()
Cells(1, 1) = Cells(1, 2) & Cells(1, 1)
End Sub

--
Gary's Student


"Danny Boy via OfficeKB.com" wrote:

Hi,


I have cell A1 = 10 and B1 = -

This must change A1 to -10

I have no other option, I cannot use any other cells for joining,

Any others Ideas?

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...mming/200601/1

that's pretty cool,
is there a way to do that so you can still keep the formulas in the
cells?
Dave

Hi Dave:

This will work, but only if A1 contains a fomula (starts with =):

Sub Macro2()
Dim s As String
s = Cells(1, 1).Formula
s = "=" & Cells(1, 2) & "(" & Right(s, Len(s) - 1) & ")"
Cells(1, 1).Formula = s
End Sub

--
Gary''s Student


"damorrison" wrote:

that's pretty cool,
is there a way to do that so you can still keep the formulas in the
cells?
Dave

Hi Guys

Thanks for your responses

I wish I would have waited for your replies. I did it the way I didn't want
to by going round the bush abit.

I put =A2&B2 into the appriopite cells then copied and pasted the results as
values into column C then went back and deleted the columns A and B, its
works this way and its fast zzzziiiiiiiiiiiiiiipppppppppppp

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...mming/200601/1