by Clint Sco » Sat, 04 Feb 1995 07:03:32
by Mike Swa » Tue, 07 Feb 1995 15:35:25
You know, I just wouldn't expect this to work, what with data
conversion and all. (If you do get it to work, please post!) Anyway, what
I'd do is just get the data from each column, concatinating them into a
string as you went.
--
by MSande » Tue, 14 Feb 1995 11:58:30
1. Type mismatch when selecting a row using a variable for the row
Hi all,
In the following Sub, I get a type mismatch in the line "
Rows("rw:rw").Select ". I would have thought that if the rw variable (as an
integer) worked for the Cells object it should have worked for the rows
object. When I hold my cursor over the rw in the previous line it says "rw
=15" so I don't understand why I am getting the type mismatch. What am I
doing wrong?
Thanks for the continued help!
Jim
Sub DeleteIMsg()
Dim rw As Integer
For rw = 1 To 32767
If Cells(rw, 8).Value = "" Then Exit Sub
If Cells(rw, 8).Value = "I" Then
If Cells(rw, 9).Value = "NI" Then
Rows("rw:rw").Select
Selection.Delete shift:=xlUp
End If
End If
Next rw
End Sub
3. Multiple rows in table but display single row in select statement
5. Selecting a Row Programmatically in a Data Table
6. HELP!! Palatino Font Needed!!!!
8. select row which have specified data
9. Macro To Transpose Selected Row Data To Column Format
10. Getting data from a row Excel5.0
11. Getting data from PREVIOUS row in DW
12. Excel - Getting first row number that doesn't have data