Asking Help for VBA copy only cell eith value and the cell before

[ericokay]

Please anybody help me to solve this VBA

I want to copy a range that if the specified cell is filled with value

in the picture attached is my file
if G9 is filled with value more than 0 then i want to copy from B9 to G9
i need only the code to select the range. i alrewdy have the copy code to another sheet

thank you so much all

 

[Micron]

Try If Range("G9") > 0 Then Range("B9:G9").Copy or
If Range("G9") > 0 Then
Range("B9:G9").Copy
End If

You might have to further qualify the Range reference by providing a reference to a particular sheet (or ActiveSheet).