Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
Pasmatos
 
Posts: n/a
Default 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


  #2   Report Post  
Posted to microsoft.public.excel.misc
JE McGimpsey
 
Posts: n/a
Default 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

  #3   Report Post  
Posted to microsoft.public.excel.misc
Pasmatos
 
Posts: n/a
Default 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


  #4   Report Post  
Posted to microsoft.public.excel.misc
Pasmatos
 
Posts: n/a
Default 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


  #5   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson
 
Posts: n/a
Default 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


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel expression {=SUm(if(istext(c8:k8),1,0))} Mike Excel Worksheet Functions 2 October 11th 05 07:12 PM
Can Excel represent formula in textural format with values substi. BoneR Excel Worksheet Functions 7 March 31st 05 03:11 PM
R² expression for trendline in chart jean Charts and Charting in Excel 1 December 23rd 04 07:51 AM
> and < criteria in one single expression in excel ExcelLEarner New Users to Excel 1 December 5th 04 04:54 AM
Excel Expression Yubasus Excel Discussion (Misc queries) 2 November 26th 04 12:41 AM


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

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"