Thread: Excel VBA - Type mismatch during While
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
sub_pop sub_pop is offline
external usenet poster
  
Posts: 1
Default Excel VBA - Type mismatch during While
On a worksheet with 4 columns and ~300 rows, where the 4th column is th
same formula in each row, returning a value for the first ~10-20,
want to paste the contents of the 1st column into the 5th column of th
same row, so long as the result of the formula in column 4 is no
"#N/A"

What I have looks like this:
While ActiveCell < "#N/A"
ActiveCell.Offset(0, -3).Select
ActiveCell.Copy
ActiveCell.Offset(0, 4).Select
ActiveCell.PasteSpecial
ActiveCell.Offset(1, -1).Select
Wend

This works well for adding the 5th column, but errors out as a Typ
Mismatch when it reaches the first row where the result in column 4 i
#N/A. Any help is greatly appreciate

--
Message posted from http://www.ExcelForum.com

Reply With QuoteReply With Quote