ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Expression for Macro - help (https://www.excelbanter.com/excel-discussion-misc-queries/57559-expression-macro-help.html)

Pasmatos

Expression for Macro - help
 
Hi.
I need help.

I have a range that start with a cell that i have selected and ends in the
U3000, i need automaticaly select in that range all the rows and delete them.
How do i complete this expression ... It's something like the expression
below but dont know the final touch to work.
Please help.

Rows(ActiveCell.select :u3000).Select



JE McGimpsey

Expression for Macro - help
 
Please don't start a new thread - it just tends to fragment any answers,
and wastes the time of those replying to questions that have already
been answered. There's at least one suggestion in your previous post. If
that's not sufficient, try explaining what didn't work.

For tips on using these groups effectively, see

http://cpearson.com/excel/newposte.htm





In article ,
"Pasmatos" wrote:

Hi.
I need help.

I have a range that start with a cell that i have selected and ends in the
U3000, i need automaticaly select in that range all the rows and delete them.
How do i complete this expression ... It's something like the expression
below but dont know the final touch to work.
Please help.

Rows(ActiveCell.select :u3000).Select


Pasmatos

Expression for Macro - help
 
Sorry, but you are confused i don't have any prior post for my question, that
have being answered.
Regards.

"JE McGimpsey" wrote:

Please don't start a new thread - it just tends to fragment any answers,
and wastes the time of those replying to questions that have already
been answered. There's at least one suggestion in your previous post. If
that's not sufficient, try explaining what didn't work.

For tips on using these groups effectively, see

http://cpearson.com/excel/newposte.htm





In article ,
"Pasmatos" wrote:

Hi.
I need help.

I have a range that start with a cell that i have selected and ends in the
U3000, i need automaticaly select in that range all the rows and delete them.
How do i complete this expression ... It's something like the expression
below but dont know the final touch to work.
Please help.

Rows(ActiveCell.select :u3000).Select



Pasmatos

Expression for Macro - help
 
Sorry for my last reply JE McGimpsey, but i don't have confirmation of my
previous post, and don't see that post, because that, i wrote another.
I know the rules for use these groups and i do everything to respect them.

Regards.
Paulo

"JE McGimpsey" wrote:

Please don't start a new thread - it just tends to fragment any answers,
and wastes the time of those replying to questions that have already
been answered. There's at least one suggestion in your previous post. If
that's not sufficient, try explaining what didn't work.

For tips on using these groups effectively, see

http://cpearson.com/excel/newposte.htm





In article ,
"Pasmatos" wrote:

Hi.
I need help.

I have a range that start with a cell that i have selected and ends in the
U3000, i need automaticaly select in that range all the rows and delete them.
How do i complete this expression ... It's something like the expression
below but dont know the final touch to work.
Please help.

Rows(ActiveCell.select :u3000).Select



Dave Peterson

Expression for Macro - help
 
And it's not very efficient for you or the responders for you to post multiple
times to different groups.

If you think you must post to multiple newsgroups, include them all in one
message.

(Then you have less to find and responders won't duplicate efforts if the
question has been answered.)

Pasmatos wrote:

Sorry for my last reply JE McGimpsey, but i don't have confirmation of my
previous post, and don't see that post, because that, i wrote another.
I know the rules for use these groups and i do everything to respect them.

Regards.
Paulo

"JE McGimpsey" wrote:

Please don't start a new thread - it just tends to fragment any answers,
and wastes the time of those replying to questions that have already
been answered. There's at least one suggestion in your previous post. If
that's not sufficient, try explaining what didn't work.

For tips on using these groups effectively, see

http://cpearson.com/excel/newposte.htm





In article ,
"Pasmatos" wrote:

Hi.
I need help.

I have a range that start with a cell that i have selected and ends in the
U3000, i need automaticaly select in that range all the rows and delete them.
How do i complete this expression ... It's something like the expression
below but dont know the final touch to work.
Please help.

Rows(ActiveCell.select :u3000).Select



--

Dave Peterson


All times are GMT +1. The time now is 05:24 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com