Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
SkipBlanks doen't
SkipBlanks is badly named and a bit quirky. It does NOT "condense" a pasted
range to paste only non-blank values. For example, if A1:A5 contains A <blank C <blank E and you PasteSpecial SkipBlanks = True into B1, the result is NOT A C E Instead, the result will look the same as A1:A5. What SkipBlanks does is not paste empty values over into the destination range. The contents of the destination corresponding to the blank cells in the source are not changed. For example, if A1:A5 is as described above, and B1:B5 has <blank B <blank D <blank the result of PatseSpecial SkipBlanks = True is A B C D E The blank cells in A1:A5 are not paste over into B1:B5, and the contents of B1:B5 corresponding to the blank cells in A1:A5 are not changed. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com (email address is on the web site) "Jim Tibbetts" wrote in message ... I have a column of data that has apostrophies which are removed for further processing. After the apostrophies are removed I want to copy the column of data to another column without the blanks that are left over after the removal of the apostrophies. The following is what I have, but blanks are still pasted in Column F. What am I missing? For rwIndex = 2 To 501 For colIndex = 2 To 2 With Worksheets("WhoHas").Cells(rwIndex, colIndex) If Len(Trim(.Value)) = 0 Then .ClearContents End With Next colIndex Next rwIndex Range("WhoHas!B2:B126").Select Selection.Copy Range("WhoHas!F2").Select Selection.PasteSpecial Paste:=xlValues, SkipBlanks:=True Thanks -- Jim T |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I enlarge a sheet that doen't have the maximize button? | Excel Discussion (Misc queries) | |||
Why doen't PasteSpecial, Formulas not display formula in cell? | Excel Discussion (Misc queries) | |||
Chart problem: values in column A doen't show on x-axis | Excel Discussion (Misc queries) | |||
Function tests OK but doen't work when called | Excel Programming |