Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Type Mismatch | Excel Worksheet Functions | |||
type mismatch on saving excel calculation mode via VB app | Excel Discussion (Misc queries) | |||
Type mismatch | Excel Programming | |||
Type mismatch | Excel Programming |