Choose Range() in VBA

[Useful]

Hi Mr Excel!
I've creted the macro code below and i want to select range from "g" to "h" and apply the formula (from B23) to this range

Sub Proper()

Dim f As String
Dim g As Range
Dim h As Range

f = Range("B23").Value

Range("M60000").End(xlUp).Offset(1, -5).Value = g
Range("M60000").End(xlUp).Offset(20, -5).Value = h
Range(g, h).Select = f


End Sub

Thanks

 

[wigi]

For instance:

Sub Proper()

    Range("M60000").End(xlUp).Offset(1, -6).Resize(20, 2).Value = Range("B23").Value

End Sub

Please spend time learning the basics of a programming language like VBA, then you will understand that a line like

Range("M60000").End(xlUp).Offset(1, -5).Value = g

operates from left to right: you fill a range with an (empty) variable g. Not the other way round: g is not a variable containing a range.

 

[venkat1926]

try this modification

Sub Proper()
Dim f As String
Dim g As Range
Dim h As Range
f = Range("B23").Value
Set g = Range("M60000").End(xlUp).Offset(1, -5)
Set h = Range("M60000").End(xlUp).Offset(20, -5)
'Range(g, h).Select = f
Range(g, h).FormulaArray = f
End Sub

is this what you want.

 

[Useful]

Thanks for your answer i'm newbie in VBA and i'm tring to learn a lot with your help
Yes this code is working thanks a lot!

 

[Useful]

try this modification

Sub Proper()
Dim f As String
Dim g As Range
Dim h As Range
f = Range("B23").Value
Set g = Range("M60000").End(xlUp).Offset(1, -5)
Set h = Range("M60000").End(xlUp).Offset(20, -5)
'Range(g, h).Select = f
Range(g, h).FormulaArray = f
End Sub

is this what you want.

Thanks venkat1926 this was very helpfull too!