Forum Discussion
AUTO COPY AND PASTE
Check the column F in attached sheet, find the formula in cell F4 downwards,, I hope that you are looking for this.
In cell F3, you need to enter number smaller/prior than H3, like is 1 then 0. This will copy automatically in H4:H54, this may vary depends on the set of numbers to want to get.
Remember cell H4:H54 has formula ,, need to be handled carefully.
I'm using this vba to print
Private Sub Worksheet_Change(ByVal Target As Range)
Dim KeyCells As Range
Set KeyCells = Range("F3")
If Not Application.Intersect(KeyCells, Range(Target.Address)) _
Is Nothing Then
ActiveSheet.PrintOut
End If
End Sub
- This VBA code will print the current sheet/part of it what so every when cell F3 has no value,, then could you please write me,,, how you get value in F3,, from Keyboard or through formula,, if using formula then using which cell to copy in F3 !
I dont have a formula i need a vba that will detect if the cell is empty or if there is something there and if there is something there it would copy to f3
- I'm confused,, since ActiveSheet.PrintOut prints the Active sheet, I mean the entire sheet, are you sure that you want this only or something else !!
i have set print area so it would only print part that i need