Macro Troubles

[QCIT3 MMisonora]

Hi there,
I have an excel file with macros on it and have gotten it onto OpenOffice, but 
the coding for the macros on the file keep saying there is an error, so I was 
wondering if anyone can please inform me as to how I can fix these two lines in 
two separate codes.

       1. LastSn = rng.Find("*", rng.Cells(1), Lookat:=xlPart, 
LookIn:=xlFormulas, SearchOrder:=xlByRows, SearchDirection:=xlPrevious, 
MatchCase:=False) .Row

       2. TargetCol = Target.Column


Thanks.


Sent from Outlook<http://aka.ms/weboutlook>