How do I select multiple rows by using VBA? e.g. Row 2,4,6,8 Thanks so much
K Kenneth lEE Jan 13, 2010 #1 How do I select multiple rows by using VBA? e.g. Row 2,4,6,8 Thanks so much
J Jay Freedman Jan 13, 2010 #2 Kenneth said: How do I select multiple rows by using VBA? e.g. Row 2,4,6,8 Thanks so much Click to expand... In VBA, you can't select multiple pieces of text (rows or anything else) that aren't continuous. See http://support.microsoft.com/?kbid=288424. The best you can do is to select one piece at a time, working in a loop. -- Regards, Jay Freedman Microsoft Word MVP Email cannot be acknowledged; please post all follow-ups to the newsgroup so all may benefit.
Kenneth said: How do I select multiple rows by using VBA? e.g. Row 2,4,6,8 Thanks so much Click to expand... In VBA, you can't select multiple pieces of text (rows or anything else) that aren't continuous. See http://support.microsoft.com/?kbid=288424. The best you can do is to select one piece at a time, working in a loop. -- Regards, Jay Freedman Microsoft Word MVP Email cannot be acknowledged; please post all follow-ups to the newsgroup so all may benefit.
