Content in a range is not clearing when i use F5 key

**shiva_raj** · 04-04-2017, 03:19 PM

Hi,

Below 2 lines of code is working when I run step by step (by using F8). But the code is not working properly when I use "F5".

Workbooks("Team Update - Copy.xlsm").Sheets("TS").Range(Cells(2, 13), Cells(1000, 23)).Select
Selection.ClearContents

Explanation: = Each time code has to delete the contents from range M2 to W1000 in "TS" Sheet. When i use F5 key, code is not deleting the content.

Note: Pls go through the Code and pls run the code at least 2 to 3 times each time by pressing F8 and F5 then you can observe the problem.

thank you in advance

regards
shiva

**humdingaling** · 04-04-2017, 08:25 PM

firstly..you dont need to select first.

you can just do it in one line

Please Login or Register  to view this content.

secondly
you have code to clear but then you have code to repopulate with new data below
is this why say it not clearing?

Please Login or Register  to view this content.

**shiva_raj** · 04-04-2017, 09:53 PM

HI,

Thank you for reply.

I could not understand, Pls tell me the solution.

**humdingaling** · 04-04-2017, 10:35 PM

point 2 was a question which i tried to ask without posting the whole code

at the start of the code you clear contents with the code

Please Login or Register  to view this content.

then down the bottom
you have code that populates that same area you have cleared

Please Login or Register  to view this content.

**xlnitwit** · 04-05-2017, 02:03 AM

Hi,

You have not properly qualified all the calls

Please Login or Register  to view this content.

otherwise the code will fail unless that is the active worksheet and workbook.

Content in a range is not clearing when i use F5 key

LinkBack

Thread Tools

Rate This Thread

Display

Content in a range is not clearing when i use F5 key

Re: Content in a range is not clearing when i use F5 key

Re: Content in a range is not clearing when i use F5 key

Re: Content in a range is not clearing when i use F5 key

Re: Content in a range is not clearing when i use F5 key

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Clearing Sheet Content

Cell content clearing when using Save As macro

Auto Clearing Content

clearing content from blank cells

[SOLVED] Exclude column when clearing content with VBA

[SOLVED] Clearing cells content when opening up an Excel workbook

clearing cell content on MAC?

[SOLVED] clearing cell content in a macro

Bookmarks

Bookmarks

Posting Permissions