convert $A$12 to a value

[EDUCATED MONKEY]

Hi I have a couple of issues that I could do with a hand with<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
1 how do I convert $A$12 so I can use the value in a delete scenario <o></o>
e.g. Sheets("Sheet1").Select<o></o>
Range("A3: $A$12 ").Select this does not work<o></o>
Range("A3:A12").Select this does <o></o>
Selection.Delete Shift:=xlUp<o></o>
2 some times one or more item are missing from the list of things to find and it crashes please see code below <o></o>
3 I know the answer to this but I just can not remember it right now so I will ask <o></o>
How do I copy arrange of cells in this case C3 to H3 to next available row on another sheet <o></o>

Sub FindString()
    Dim Found As Range
    
    
    Set Found = ActiveSheet.UsedRange.Find("title", LookIn:=xlValues, lookat:=xlPart)
     Range("C1") = Trim(Found.Value)
    
     
     Range("C2") = Len(Trim(Found.Value))
     Set Found = ActiveSheet.UsedRange.Find("author", LookIn:=xlValues, lookat:=xlPart)
     Range("D1") = Trim(Found.Value)
     Range("D2") = Len(Trim(Found.Value))
     Set Found = ActiveSheet.UsedRange.Find("basic", LookIn:=xlValues, lookat:=xlPart)
     Range("E1") = Trim(Found.Value)
     Range("E2") = Len(Trim(Found.Value))
     Set Found = ActiveSheet.UsedRange.Find("language", LookIn:=xlValues, lookat:=xlPart)
     Range("F1") = Trim(Found.Value)
    'Range("F2") = Len(Trim(Found.Value))
     Set Found = ActiveSheet.UsedRange.Find("synopsis", LookIn:=xlValues, lookat:=xlPart)
    Range("G1") = Trim(Found.Value)
    Range("G2") = Len(Trim(Found.Value))
     Set Found = ActiveSheet.UsedRange.Find("imageurl", LookIn:=xlValues, lookat:=xlPart)
    Range("H1") = Trim(Found.Value)
    'Range("H2") = Len(Trim(Found.Value))
    
End Sub

 

[EDUCATED MONKEY]

Very well.
I'll just say, I know you're on a path to sorting things out ...
For the next html parser project:
Take a look at these two Reference libraries:
WinHttp
Microsoft HTML Object Library

They can make the parsing of HTML more bearable.

Thank you seem to be over the worst just got an annoying problem just posted if you get a minuet <?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
I decided upon the viable version so I can change at will if necessary <o></o>