#1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 703
Default urgent ?

My sheet2 has a list a data, four columns wide. My userform shows this data
with buttons 'prev' and 'next' as per the code mentioned here recently. I
have a button 'delete' that needs to remove the row 'rownumber'.
Is this very hard to do???
thanks again.
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 367
Default urgent ?

try this

worksheets("sheet2").rows(rownumber).delete xlshiftup

this is just the syntax, maybe you have to adjust some things.
(I got the rownumber from your previous posts!)

btw: Try to stay in one post so we can check what has been done
already, or at least give us a link to a prior post!

Cheers
Carlo

On Dec 25, 1:59*pm, Charlie wrote:
My sheet2 has a list a data, four columns wide. *My userform shows this data
with buttons 'prev' and 'next' as per the code mentioned here recently. *I
have a button 'delete' that needs to remove the row 'rownumber'.
Is this very hard to do???
thanks again.


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
IME MODE FOR EXCEL 2007 (URGENT URGENT) Stella Wong Excel Discussion (Misc queries) 1 August 23rd 08 11:16 PM
a very urgent help in VBA [email protected] Excel Programming 0 August 5th 06 01:14 PM
Urgent-Urgent VBA LOOP Jeff Excel Discussion (Misc queries) 0 October 6th 05 05:46 PM
Macro help urgent urgent Dave Peterson[_3_] Excel Programming 0 September 4th 03 03:59 PM
Macro help urgent urgent chandra Excel Programming 0 September 4th 03 03:50 PM


All times are GMT +1. The time now is 11:47 AM.

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

About Us

"It's about Microsoft Excel"