Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
how to rm the "extra row"?
how to rm the "extra row"?
In sheets("data_entry"), there is a column (Q) for "Dye Mode", where some rows are EMPTY but NOT ALL. After the "Make Sticker" button(in data_entry) is pressed, sticker sheets are generated and a problem arises.. Problem: In between each sticker, there should be ONLY ONE empty row. The macro is ok IF ALL the cells in "Dye Mode" are FILLED, AND REPLACE: ------------------------------------------------------------------------------------If .Cells(rr, cDYE_MODE) < "" Then 'chk dye mode exist, if yes 'fill dye mode Cells(rCurr + 1, cc + 2) = "(" & .Cells(rr, cDYE_MODE) & ")" Else rCurr = rCurr - 1 'rm row for dye mode End If ------------------------------------------------------------------------------------WITH: ------------------------------------------------------------------------------------ 'fill dye mode Cells(rCurr + 1, cc + 2) = "(" & .Cells(rr, cDYE_MODE) & ")" ------------------------------------------------------------------------------------ However, in case ONLY SOME cells are filled, the macro generates ONE MORE empty row, which is not desired to appear, between some stickers! It seems that "rITEM" and "rCurr" in the vba cause this problem. How to re-write the macro so that the "extra rows" do NOT arise? File Attached: http://www.exceltip.com/forum/attach...?postid=290084 (help17.zip) ------------------------------------------------ ~~ Message posted from http://www.ExcelTip.com/ ~~ View and post usenet messages directly from http://www.ExcelForum.com/ |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
how to rm the "extra row"?
(referring to the same attachment)
error date format?! NONE of the dates in the sticker sheets correctly show today's date as the vba write: Cells(rCurr + 1, cc + 2) = Format(Date, "dd/mm/yyyy") Why? (question 1) Some dates EVEN appear to be "US$37,662.00"!! Why? (question 2) And how to correct to two of the above problems? (question 3) ------------------------------------------------ ~~ Message posted from http://www.ExcelTip.com/ ~~ View and post usenet messages directly from http://www.ExcelForum.com/ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
change "true" and "false" to "availble" and "out of stock" | Excel Worksheet Functions | |||
HELP on "left","right","find","len","substitute" functions | Excel Discussion (Misc queries) | |||
Count occurences of "1"/"0" (or"TRUE"/"FALSE") in a row w. conditions in the next | New Users to Excel | |||
need the extra button of "Allocation" next to help. | Excel Discussion (Misc queries) |