View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
NEWER USER NEWER USER is offline
external usenet poster
 
Posts: 10
Default Adding a WHERE statement

I recorded a basic macro and want to add a WHERE statement in the body and
need some help. I recorded

Range("B2").Select
ActiveCell.FormulaR1C1 = "1"
Range("B2").Select
Selection.Copy
Range("B2:B65536").Select
Application.CutCopyMode = False
Selection.FillDown
Range("A2").Select

I want to fill Column B entirely WHERE any value LESS THAN 2 OR NULL. Any
Help appreciated as to where and How to add statement.