Cut and copy VBA - If range has value cut and paste to another cell - if Null Skip

**Tom_Watson123** · 05-28-2015, 11:00 AM

Hello All -
I am new to writing VBA and have searched the forum for something similar to my query, but have come up short. What I am looking for is a vba that would look at a range ie: K7:k50 and if there is a value move it one column left. If null, go to next cell in range.

Thank you in advance!

Tom

**sweep** · 05-28-2015, 11:04 AM

Hello,

Does this get you started?

Please Login or Register  to view this content.

**Tom_Watson123** · 05-28-2015, 11:13 AM

You sir are a genius! Thank you so very much.

Cut and copy VBA - If range has value cut and paste to another cell - if Null Skip

LinkBack

Thread Tools

Rate This Thread

Display

Cut and copy VBA - If range has value cut and paste to another cell - if Null Skip

Re: Cut and copy VBA - If range has value cut and paste to another cell - if Null Skip

Re: Cut and copy VBA - If range has value cut and paste to another cell - if Null Skip

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Formula to Copy/Paste data based on value of another cell. SKIP BLANK ROWS.

Copy paste into first cell in column, Skip cells with text.

[SOLVED] macro to Copy paste range skip zero values

VBA code if cell is null - skip

Copy and paste except null value formula results

Bookmarks

Bookmarks

Posting Permissions