| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA code need help on CopyPaste
I have a list of PartNumber ranging from B2:B6880 and I am vlooking them
up to other worksheets for values of Safety-Stock, Qty-on-hand, PO-Qty, etc.. For example, I insert column N to vlookup for the Safety-Stock values. Double-clicking the black cross-sign that appears on the bottom-right of cell N2 Vlookup formula doesn't copy the N2 formula to N6880 because there are some blank cells in column M and column O. I am hoping someone can help me with a code which can allow to copy cell N2 formula to the last cell in column N where the whole row is not totally blank, ie. at least has a cell in the row populated with value. Eg, if this row as mentioned above is row 6880, then row 6881 onwards will be totally blank. Appreciate so much if someone can help with with a code to do this. Thanks so much in advance! --- Message posted from http://www.ExcelForum.com/ |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| split post code (zip code) out of cell that includes full address | Excel Discussion (Misc queries) | |||
| Code to conditional format all black after date specified in code? | Excel Discussion (Misc queries) | |||
| Drop Down/List w/Code and Definition, only code entered when selec | Excel Worksheet Functions | |||
| Convert a Number Code to a Text Code | Excel Discussion (Misc queries) | |||
| copying vba code to a standard code module | Excel Discussion (Misc queries) | |||
Threaded Mode
