Archive

Archive for the ‘Uncategorized’ Category

Funny & Comic Hidden Camera Jokes

July 22, 2017 Leave a comment

You should necessarily watch .

The headless man joke ,chucky comes alive …..all and for more watch this video :

Categories: Uncategorized

Copying The Chosen Numeric Values To The Other Page

February 4, 2016 Leave a comment

Useful Macros – 12

Copying The Chosen Numeric Values To The Other Page

              In the previous examples, the columns that contain non-numeric values were copied .

We will copy the numerical values that comply with criteria in this template . For example ; there are numeric values in Column I.

Now let’s copy great values from 20.000 in Column I to other pages.Using code as follows :

“For i = 1 To a

If Val(Cells(i, 9)) > 20000 Then

Sheets(“Data”).Rows(i).Copy sh2.Rows(last)

last = last + 1

End If

Next i “

numeric value copying

Download Working Example