Search : in
By :

Insert row based on cell format

JW, on Jun 27, 2009 12:48:30 pm BST 
 Report this message to moderators

Hello,

I have data in A:I.
In column F, there is a string of times.
Using Vba....
I would like to insert a blank row in the row above any time in that string that's before 00:30:00 am.

Or if easier, insert a row before cell.Interior.colorindex = 41

Configuration: Windows 2000 Internet Explorer 6.0

Best answers for « Insert row based on cell format » in :
Basic Excel Formulas Show Basic Excel Formulas Below are some basic formulas for Microsoft excel: Basic formula : ADDITION cell A1 to A10 = sum (A1: A10) AVERAGE cell A1 to A10 = average (A1: A10) MAXIMUM cell A1 to A10 = max (A1: A10) MINIMUM...
Automatically insert rows in Excel Show
Basic Excel Formulas 2 Show Basic Excel Formulas 2 We saw the SI function Function and is also interesting. Combined with SI, this gives: = IF (AND (condition1; condition2 ;....... conditionZ) true false) displays on the various conditions to be verified (eg...
Excel tips : How to insert date in a cell ShowExcel tips : How to insert date in a cell Below are some tips on how to insert date and time in an excel cell for a specific purpose:- To insert current date, press CTRL ¯+ ;¯ in the chosen cell. To insert current time, press CTRL¯+...
Colouring cells on conditions ShowColouring cells on conditions There are many pratical functions under Excel which is not commonly used. Example: If you wish a cell automatically turns red (or other formatting border, frame etc) under one condition: a result, a...
Highlighting the current row ShowHighlighting the current row Issue Solution Adding it to a general module (eg Module1) Issue When you make conversion on a Excel sheet, you often loses the point of reference. Solution This little function highlights any line...
Download Comersus Enhancement Package Show
Download AUTOption ShowAUTOption is simply an application for creating autorun menu for CD-ROM. Your menu will be fully customizable and an assistant will help you in your steps. You can even insert sounds in WAV format. Advantage The commands will open the browser,...
Spreadsheet - Formulas ShowIntroduction to Formulas The main use of a spreadsheet is to automate calculations, which means using cells to perform operations based on values in other cells. The spreadsheet recalculates all the values each time a change is made to the value of...
Spreadsheets - Conditional expressions ShowWhat is a Conditional Structure? Conditional structures are instructions that allow to test if a condition is true or not. Conditional structures may be associated together. To successfully execute these tests using logical functions, spreadsheets...
Ask your question Reply
They need your help