Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Code to delete rows with varying amounts of data
Hi,
I have a macro whcih sorts data on column K on one tab then pastes the data onto a new tab conntaining Lookup formula. My problem is that the rows pasted contain varying amounts of data and ideally I would like some code which I incorporate into the current macro whichi would: 1. locate the first row in Column K which is empty 2. Select columns A:P for this row (whcih DO contain data) and all columns below this empty column/row (K) 3. Delete all the data in these rows. Thanks for your help. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sorting rows of data of varying lengths | Excel Discussion (Misc queries) | |||
getting data from an array of varying amounts of comboboxes | Excel Programming | |||
Insert totals after varying rows of data | Excel Programming | |||
Creating Pivot tables by VBA for varying amounts of data | Excel Programming | |||
Remove varying amounts of space characters | Excel Discussion (Misc queries) |