Formatting in excel

[smithy0705]

Hi

I am very new to VBA basically copying bits from other workbooks so please bear with me!

My query is as follows:

I would like to reformat my output of

[TABLE="width: 201"]
<colgroup><col width="268" style="width: 201pt; mso-width-source: userset; mso-width-alt: 11434;"> <tbody>[TR]
[TD="width: 268, bgcolor: yellow"]12.9000299280694 - 63.5578583765112[/TD]
[/TR]
</tbody>[/TABLE]

to £12.90 - £63.58

Please can anyone help.
Thanks so much in advance
Joanne

 

[RoryA]

I think you basically want this:

            RENTVALUE = ActiveCell.Offset(J, 77).Value
        If Len(RENTVALUE) <> 0 then
            If RENTVALUE < MINVALUE Then
                MINVALUE = RENTVALUE
                Else
            End If

            If RENTVALUE > MAXVALUE Then
                MAXVALUE = RENTVALUE
                Else
            End If
         End If
            NEXTREVIEW = ActiveCell.Offset(J, 70).Value
        If Len(NEXTREVIEW) <> 0 then
            If NEXTREVIEW < MINDATE Then
                MINDATE = NEXTREVIEW
                Else
            End If
            
            If NEXTREVIEW > MAXDATE Then
                MAXDATE = NEXTREVIEW
                Else
            End If
        End If

repeat the logic of the blue lines if it should apply to the other values too.