tag:blogger.com,1999:blog-16506996.post113690701585987187..comments2024-02-08T01:57:07.944-07:00Comments on The Digital Voice: Multiple Row Selection in Excel VBAJohn Wardhttp://www.blogger.com/profile/10741149622435353727noreply@blogger.comBlogger3125tag:blogger.com,1999:blog-16506996.post-15780266061729852952009-09-15T07:24:58.794-06:002009-09-15T07:24:58.794-06:00Your "Select row of current active cell"...Your "Select row of current active cell" just saved my week.<br />Thank you.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-16506996.post-5630113821353093742009-02-24T15:43:00.000-07:002009-02-24T15:43:00.000-07:00try ":" rather than " : "try ":" rather than " : "Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-16506996.post-75968616478808693362008-01-03T09:18:00.000-07:002008-01-03T09:18:00.000-07:00Hi, I have a question about deleting all rows up t...Hi, I have a question about deleting all rows up to the current row.<BR/><BR/>I'm trying to write a script that will delete all rows below the current row up to row 65000. I tried to use your script and it gave me the following error:<BR/><BR/>"Run-time error '1004':<BR/>Method 'Range' of object '_Global' failed"<BR/><BR/>Here is the modified script:<BR/><BR/>Range("A2").Select<BR/>Do While ActiveCell.Offset(0, 1) <> ""<BR/>ActiveCell.Offset(1, 0).Select<BR/>Loop<BR/>Range(ActiveCell.Row & " : " & ActiveCell.Row, "65000:65000").Delete <BR/><BR/><BR/>Any help would be greatly appreciated.Anonymousnoreply@blogger.com