can someone help modify the clear command to only clear columns from A-G?

**psunursingguy21** · 01-30-2013, 02:09 PM

Ok i just found that when it checks the rows for data that it is clearing too far over to the right other wise it works great. Can the code that clears, only clear from A-G in "the followupcall" sheet? Otherwise it works great!

Please Login or Register  to view this content.

**Andrew-R** · 01-30-2013, 02:16 PM

Something like this should work:

Please Login or Register  to view this content.

**Richard Buttrey** · 01-30-2013, 02:17 PM

Hi,

Yes, just replace

Please Login or Register  to view this content.

with

Please Login or Register  to view this content.

**psunursingguy21** · 01-30-2013, 03:52 PM

perfect thanks again for everyones help!!!

can someone help modify the clear command to only clear columns from A-G?

LinkBack

Thread Tools

Rate This Thread

Display

can someone help modify the clear command to only clear columns from A-G?

Re: can someone help modify the clear command to only clear columns from A-G?

Re: can someone help modify the clear command to only clear columns from A-G?

Re: can someone help modify the clear command to only clear columns from A-G?

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions