View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Don Guillett Don Guillett is offline
external usenet poster
 
Posts: 10,124
Default If macro to copy a row


Without full info

if application.counta(columns("g"))0 then

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"GeorgeA" wrote in message
...
Hello,
I would like to be able to move rows of data from Sheet 1 to Sheet 2 IF
column G on Sheet 1 is not empty. Can anyone help me with this?
Thanks!