VBA code to copy displays false before some text

[alikhalil]

Not necessarily a cross post but I'll put up the older related thread in here just in case since I'm not receiving any answer:
https://www.excelguru.ca/forums/sho...om-another-sheet&p=32526&viewfull=1#post32526

I have the file attached in the following link:

https://ufile.io/2sr95

(Original content replaced by Text "Test")

It has a couple of macros on the main sheet that copy that copy each sheet's content to the main one and on each sheet as well. The idea is simple, I want to copy whatever is inside those boxes/black borders. I did not create the code by myself I only edited minor parts in it as I'm in no way that knowledgeable in VBA. The buttons do copy but the problem is somewhere next to the third or fourth or sometimes second line in each sheet it adds the word False before it. p45cal from excel guru was kind enough to trace the issue for me

The word 'False' appearing is probably due to there being a cell with 'False' in; it's variously F4, F5 or F6 and is the cell linked to a checkbox on each of those sheets. The cell has the format ;;; which renders its content invisible to the human but the code still sees it.

When I tried to exclude that part from the copy code, I went into an endless loop of errors. Can someone please look into it for me?

Your help is greatly appreciated. Thanks in advance

 

[alikhalil]

Anyone can look into the code? I wish i was able to upload the file on forum's server but I don't see something similar to excelguru

 

[mikerickson]

I haven't looked at your file, but have you tried replacing the .Value property of a cell with the .Text property?

 

[Michael M]

The link provided offers a fast file download for $5 per month....I think I'll save my money !!

 

[alikhalil]

^Sorry about that, try the below links please?

I haven't looked at your file, but have you tried replacing the .Value property of a cell with the .Text property?

I really wish I could play around with the code itself but i have close to zero knowledge of VBA that's why I resorted to the forum. But I do know for sure that it's more than just that see my first post and excelguru's p45cal's comment on the matter.

if you have time please take a look (uploaded to several places in case)

http://jmp.sh/vP7gmni

http://s000.tinyupload.com/?file_id=48823507928350473019

https://ufile.io/4pidf

 

[alikhalil]

Up. Help, anyone?

 

[alikhalil]

Up, help, anyone?

 

[alikhalil]

I'm upping this thread one last time in hopes someone might be able to fix this code.

Please and thank you.