Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Help with If/then macro in VBA
I've tried for about 2 days now to get this code right and can't see to. What I'm trying to do is after the value of a cell reaches <1, i will cut and paste the entire row after it. Therefore its values wil be erased in the process. The example will illustrate this, the shee will essentially just roll foward rows after the specified days = 0. My thoughs were if sheet1:A1<1, then copy row A2, erase A1 The file attached provides a clear example. I know attachments aren' preferred but the formatting gets messed up when I try and copy an paste from excel. Any help is appreciated +------------------------------------------------------------------- |Filename: excelforum example4.zip |Download: http://www.excelforum.com/attachment.php?postid=3519 +------------------------------------------------------------------- -- dstoc ----------------------------------------------------------------------- dstock's Profile: http://www.excelforum.com/member.php...fo&userid=2422 View this thread: http://www.excelforum.com/showthread.php?threadid=38062 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Help with If/then macro in VBA
Insert a commanbutton from the Control ToolBox menu. And attach the following code: Private Sub CommandButton1_Click() Range("B11") = Range("B11") - 2 If Range("B11") < 1 Then Range("B11").EntireRow.Delete Range("B11") = Range("B11") - 2 End If End Sub Mangesh -- mangesh_yadav ------------------------------------------------------------------------ mangesh_yadav's Profile: http://www.excelforum.com/member.php...o&userid=10470 View this thread: http://www.excelforum.com/showthread...hreadid=380628 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro recorded... tabs & file names changed, macro hangs | Excel Worksheet Functions | |||
Macro Help Needed - Excel 2007 - Print Macro with Auto Sort | Excel Worksheet Functions | |||
how to count/sum by function/macro to get the number of record to do copy/paste in macro | Excel Programming | |||
macro to delete entire rows when column A is blank ...a quick macro | Excel Programming | |||
Start Macro / Stop Macro / Restart Macro | Excel Programming |