G
gavmer
Hi all,
I have 2 questions i hope someone can help with.
1. My code copies and pastes based on value greater than 0. Problem is
i have a negative value i need to include. (IE -50). How can i do thi
and avoid copying all the blanks???
If IsNumeric(cell) Then
If cell > 0 Then
Cells(cell.Row, 5).Copy
Sh.Cells(rw, "D").PasteSpecial Paste:=xlPasteValues
Cells(cell.Row, 2).Copy
Sh.Cells(rw, "b").PasteSpecial Paste:=xlPasteValues
2. values (prices) are inserted in a row however, i would not like th
user to see the pricing. They need to know a value is inserted bu
maybe only with a ##???? These values ditermine which data copies an
pastes so the above code needs to recognise a value??
Can anyone help??
Thanks in advance!!
I have 2 questions i hope someone can help with.
1. My code copies and pastes based on value greater than 0. Problem is
i have a negative value i need to include. (IE -50). How can i do thi
and avoid copying all the blanks???
If IsNumeric(cell) Then
If cell > 0 Then
Cells(cell.Row, 5).Copy
Sh.Cells(rw, "D").PasteSpecial Paste:=xlPasteValues
Cells(cell.Row, 2).Copy
Sh.Cells(rw, "b").PasteSpecial Paste:=xlPasteValues
2. values (prices) are inserted in a row however, i would not like th
user to see the pricing. They need to know a value is inserted bu
maybe only with a ##???? These values ditermine which data copies an
pastes so the above code needs to recognise a value??
Can anyone help??
Thanks in advance!!