Improve company productivity with a Business Account.Sign Up
For x = 2 To ActiveSheet.UsedRange.Rows.Count
If Cells(x, 1).Value = "" Then
Cells(x, 1).Value = Cells(x, 2).Value
Cells(x, 2).Value = Cells(x, 3).Value
Cells(x, 3).Value = ""
Open in new window
Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.
One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.
Author Closing Comment
The results are in! Meet the top members of our 2017 Expert Awards. Congratulations to all who qualified!
Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.
Have a better answer? Share it in a comment.
Please enter a first name
Please enter a last name
Must be at least 4 characters long.
Join and Comment
Join the community of 500,000 technology professionals and ask your questions.
Join & Ask a Question
Join our community for more solutions or to ask questions.
For immediate help use Live now!