Function Getj(FileN, Optional shi = 1, Optional KeyName = "Код") As Integer
Dim c As Range
With FileN.Worksheets(shi)
Set c = .Cells.Find(KeyName, .Cells(.Rows.Count, .Columns.Count), xlValues, xlPart, xlByRows, xlNext, False)
If Not c Is Nothing Then Getj = c.Column
End With
End Function
Sub makroooo() Range(Cells(10, 1), Cells(10, 1)) = 1000 End Sub