Ask Question Forum:
Model Library:2025-02-08 Updated:A.I. model including DeepSeek is online for auto reply question page
C
O
M
P
U
T
E
R
2
8
Show
#
ASK
RECENT
25-06-28 16:30:14
Wilson Edwards
Reply:3
Post_ID:829370google adsense
as TitlePlease advise
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
25-06-28 16:00:17
Wilson Edwards
Reply:0
Post_ID:829369googles adsense
As TitlePlease advise
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
25-06-27 11:44:47
Wilson Edwards
Reply:2
Post_ID:829367googleads;drive traffic;adsense
I read some outside third-party company to prompt driving web traffic to my website to increase my google adsense revenue.How are they able to do ?During driving traffice to my website, it will create google adsense impression or not ?Google will treat that impression is invalid ?Please advise
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
25-06-27 11:02:02
Wilson Edwards
Reply:0
Post_ID:829368googleads;invalid traffic
I read some outside third-party company to prompt driving web traffic to my website to increase my google adsense revenue.How are they able to do ?During driving traffice to my website, it will create google adsense impression or not ?Google will treat that impression is invalid ?Please advise
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
25-05-05 20:08:11
test test
Reply:3
Post_ID:829366googlebot;crawler;cloudflare
Accept
How my website can use cloudflare with"Under Attack Mode" and be able to allow goolge bot, crawler to crawl my website pages at the same time ?Please advise
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
25-04-17 16:26:31
Wilson Edwards
Reply:1
Post_ID:829365css;html
Accept
as title Please advise
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
25-04-14 19:42:56
Wilson Edwards
Reply:5
Post_ID:829364javascript
Accept
Please adviseThanks
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
25-04-14 01:47:39
Wilson Edwards
Reply:2
Post_ID:829363javascript
I have set iframe addEventListener with mousedown event, it works becoz the iframe source is same domain ofthe current page..For example<iframe id=''myiframe" src='https://samedomian.com//test.html'></iframe><script>document.getElementById("myiframe").addEventListener('mousedown, function () {console.log('mousedown event detected');});</script>But when I change iframe src to external domain or cross-domin such as https://example.comit doesn't work, the reason it is blocked by cross-dmain policyAny mothed to solve this issue, how to detect mousedown event on iframe ?
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
25-04-14 01:22:51
Wilson Edwards
Reply:2
Post_ID:829362javascript
For example, I have a link in DIV-A tag now I can not click the link in DIV-A because it is covered by DIV-B I want to click the link DIV-A anyway. I tried this example, it work at https://computer28.com/learn/pointer-events.php Any other good example or other method to achieve this ? Please advise
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
25-03-28 09:26:04
Wilson Edwards
Reply:5
Post_ID:829361google_drive;php;centos8
I would like to download all my google_drive files by using php program code onmy linux centos 8 system server, how to it ?How to get the google API key to start download for php program ?Since the download file size is very huge, how can I speed up the download the file ifits size is more 100G size ?Please advise
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
25-03-12 23:38:28
Wilson Edwards
Reply:1
Post_ID:829360javascript;html;css
Accept
I would like to create child node inside of body tag and enclosing all elements inside body tagby javascript code;For example:Before:<html><body><div></div><a></a><span></span></body></html>After, if I would like to see this reuslt, creating new div tag enclose everything inside of body tag, new div tag 's id is new_child_nodeAfter:<html><body><div id='new_child_node'><div></div><a></a><span></span></div></html></body>Please advise
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
25-03-03 21:46:28
test test
Reply:4
Post_ID:829359cloudflare;proxy;socket;python;centos 8;apache
I am using cloudflare to protect my website recently,but I have a page which is using python socket to send streaming data to visitor with 5000 portsuch as http://mywbesite.com:5000.Before using clouldflare, visitor can get data from port 5000, now after usingcloudflare, all visitors to my website can not get any data from port 5000.Now I pause cloudflare, the python socket port is working back again..The question is I would to like to keep all cloudflare service such as proxy but python socket port need to work for exception by cloudflare, how can I do that ?My Simple python socket code:from flask import Flask, render_template, request, session,jsonifyfrom flask_sse import ssefrom flask_socketio import SocketIO, emit, join_roomimport platformimport loggingfrom flask_cors import CORSimport socket....if __name__ == "__main__": app.run(host="0.0.0.0",debug=False, port=5000, ssl_context=("mycert")
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
25-03-02 21:19:15
test test
Reply:3
Post_ID:829358cloudflare;VPN;proxy;linux;apache
My website is using cloudflare internt traffic protection.I am using php code to monitor all internet ip through chrome browser to my websitefor example, monitoring $_SERVER['HTTP_X_FORWARDED_FOR'] and$_SERVER['REMOTE_ADDR'];I try it in those different computers with different ISP ip, I found the result as followsCase-1 Computer A,$_SERVER['HTTP_X_FORWARDED_FOR']="51.58.202.19";$_SERVER['REMOTE_ADDR']="172.64.0.0"where51.58.202.19 is my Compuer A ISP ip and172.64.0.0 is cloudflare use proxy server to get the webpage for Computer A.Case-2 Computer B,$_SERVER['HTTP_X_FORWARDED_FOR']="61.85.102.11";$_SERVER['REMOTE_ADDR']="61.85.102.11"where61.85.102.11is my Compuer B ISP ip and$_SERVER['HTTP_X_FORWARDED_FOR']=$_SERVER['REMOTE_ADDR']My question is Why in case-1 Cloudflare will use proxy to get webapge for computer A butcloudfare don't use proxu to get wbepage for computer B in which both php ip is same from$_SERVER['HTTP_X_FORWARDED_FOR']=$_SERVER['REMOTE_ADDR'] ?Second question, in what condition ro when Cloudflare use proxy or not use proxy to get webpage for browser visitor?Final question isIf cloudflare use proxy , it mean visitors of Computer A, ISP IP maybe bot or maliciousor suspected IP , Can I release Google Ads on my webste and allow the vistior of Computer A to click the ads ? If the visitors click the ads, it mean the click is excuted from Computer A, ISP IP or from Cloudflare 's proxy IP ?Please advise
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
25-03-02 12:50:13
test test
Reply:2
Post_ID:829357cloudflare;google chrome;apache
Question 1- Cloudflare show warning, too may redirect on chrome solvedAnswer: solved by removing all redirect from http to https since cloudflare will handleall redirect from http.Since in apahce httpd.conf, we added the following for http to https and except some directorybased on this linkhttps://stackoverflow.com/questions/5818146/how-to-force-rewrite-to-https-except-for-a-few-pages-in-apache#RewriteEngine on#RewriteCond %{SERVER_NAME} =computer28.com [OR]#RewriteCond %{SERVER_NAME} =www.computer28.com#RewriteRule ^https://%{SERVER_NAME}%{REQUEST_URI}[END,NE,R=permanent]#RewriteEngine on#RewriteCond %{HTTPS} =off#RewriteCond %{REQUEST_URI} !^\/local\/#RewriteCond %{REQUEST_URI} !^\/world\/#RewriteRule (.*)https://%{HTTP_HOST}/$1[L,R=301]#RewriteCond %{HTTPS} =on#RewriteCond %{REQUEST_URI} \/fid\/ [OR]#RewriteCond %{REQUEST_URI} \/php\/#RewriteRule (.*)http://%{HTTP_HOST}/$1[L,R=301]Comment it all, it works nowQuestion-2:How to Fix ERR_QUIC_PROTOCOL_ERROR Message in Chrome Browserwhen using cloudflareAnswer-2https://kinsta.com/knowledgebase/err_quic_protocol_error/https://www.hostinger.com/tutorials/how-to-fix-err-quic-protocol-errorchrome://net-internals/#dnsHTTP/3 Cheker:https://http3check.net/?host=computer28.comhttps://kinsta.com/knowledgebase/flush-dns/on Window 10:ipconfig /flushdns //clear all DNS cachingFinal, if still can not solve question-2, delete cloudflare account and then re-create new other account using other gmail accout to see any help from resetting all cloudflare default setting.Need to wait 1-day or 2-day. to see theERR_QUIC_PROTOCOL_ERROR will be sovledor not...If above answer can not be solved, any suggestion or solution to solve those those bothquestions,Please advise
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
25-03-01 19:03:13
Wilson Edwards
Reply:2
Post_ID:829356centos 8
as title for the question, I read the link,https://devco.re/blog/2014/06/19/client-ip-detection/ it works , for php as following code., Any other method besides php code, to dectect the ip is real ip not VPN not TOR IP not proxy IP?<?php if(!empty($_SERVER['HTTP_CLIENT_IP'])){ $myip = $_SERVER['HTTP_CLIENT_IP']; }else if(!empty($_SERVER['HTTP_X_FORWARDED_FOR'])){ $myip = $_SERVER['HTTP_X_FORWARDED_FOR']; }else{ $myip= $_SERVER['REMOTE_ADDR']; } echo $myip; ?>
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
25-03-01 17:56:38
Wilson Edwards
Reply:2
Post_ID:829355google ads;cloudflare
Google Ads can be shown if my website is using cloudflare protection ? and next question isCloudflare can protect my websie from Bot Fraud Click on my website Google Ads.My Cloudflare account is free version Cloudflare.Please advise
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
25-02-28 00:17:59
Wilson Edwards
Reply:4
Post_ID:829354google;reCAPTCHA
I just created reCAPCHA fromg google site athttps://www.google.com/recaptcha/admin/createand following his instruction, created my first reCAPCHA html page such as follows<!DOCTYPE html><html lang="en"><head><script async defer src="https://www.google.com/recaptcha/api.js"></script></head><body><div class="g-recaptcha" data-sitekey="6LcIhOQqAAAAAGbMD-QaT-xjh9VYF87D7w6uMw4n"></div></body></html>The page is successful and show google reCAPCHA, but it will ask me to do image testCan I bypass the image test, just tick the I am not a rebot box only ?Please advise
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
25-02-26 04:32:58
Ty Yt
Reply:1
Post_ID:829353Linux apache
As tilte
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
25-02-25 04:28:14
Wilson Edwards
Reply:2
Post_ID:829352centos;linux
I am using linux command, host, to check the revserse ip , some is not found but if I am using, online tool, that IP is normal, not abusive ipHow to check the IP is abusive ?
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
25-02-23 19:30:17
Wilson Edwards
Reply:3
Post_ID:829351香港樓市;Hongkong housing price
Accept
香港樓市, 現在買 Okay ?
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
25-02-23 17:06:22
Wilson Edwards
Reply:4
Post_ID:829348google adsense
Accept
my website server is new or small server, recently, just start up my server width Google Adsense ads into my site.DUring, these past 7-day, I get page view not much, but have 50 impression and 20 click dailyI check all my apache log file, those access to my wbesite is not too freqently, butToday Google banned my Google Adsense Account, including this time, Google already banned my site for 5-time.The reason is invalid traffic, I have already followed all rules from GooglePlease advise
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
25-02-20 15:15:06
su e
Reply:1
Post_ID:829347excel vba 技術趨勢圖陰陽燭
excel vba 技術趨勢圖陰陽燭
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
25-02-18 17:05:47
w kk
Reply:3
Post_ID:829345葵芳地鐵站葵涌廣場鋪位
葵芳地鐵站葵涌廣場鋪位
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
25-02-18 16:46:59
w kk
Reply:1
Post_ID:829344why we use
as tile
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
25-02-18 16:43:41
w kk
Reply:1
Post_ID:829343bitcoin
as title
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
25-02-18 16:33:55
w kk
Reply:2
Post_ID:829342as title
Accept
as title
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
25-02-15 21:18:40
Wilson Edwards
Reply:7
Post_ID:829340google;adsense;crawler
Accept
I just want disallow Google search indexing engine to access all my files and all my directories except some files such as index.php and music.png and let ads.txt can be crawled by Google Adsense Crawler Please advise
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
25-02-12 00:53:08
Norton Alex
Reply:1
Post_ID:829260javascript
my question is same as the title And, I search it on internet, the closer one is this link https://stackoverflow.com/questions/3538021/why-do-we-use-base64 Any good article about this topic Regards
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
25-02-12 00:48:17
Wilson Edwards
Reply:2
Post_ID:829290window10/11;apache;centos;php;html
Accept
After clicking some Googe Ads and leave the ads site or delete the tab, your browser may forwards you to other site which may give you message such as "Congrulation,! You Get Prize, Bonus, Coupon.etc" Probably your browser is infected by virus and the Congurlation site is hacker /attacker virus site.. I will think the following methods to solve my problem, Please advise those methods are correct 1- Right away or now, remove the forwars site(Congrulation site) or delete such browser Tab 2- Look at this image: https://computer28.com/image/deletecache.jpg Delete or clean your chrome browser data At Chrome browser, Click Sitting->Privacy Security->Delete Browser Data, it will pop up window, in that window, Click Advanced->Select Time Range(All Time)->Tick all box below Time range such as Browsering History..etc. Click Delete Data button 3-If using Window 10, Turn on Microsoft Defender Virus Protection System, always turn it on https://carleton.ca/its/help-centre/how-to-enable-windows-defender-on-personal-pc/ You are better to install Microsoft Window 11 if u are using WIndow 10 4- Add X-Content-Type-Options: nosniff on header at my apache server
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
25-02-12 00:32:47
Norton Alex
Reply:3
Post_ID:829339centos;apache;php;html
Accept
as title with the topic tag
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
25-02-11 17:12:06
test test
Reply:2
Post_ID:829338centos;linux;A.I.
I would like to stop all A.I. access my website through VPN or TOR browser,How I know the A.I. is accesing into my website pagesPlease advise
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
25-02-11 17:07:11
Wilson Edwards
Reply:1
Post_ID:829291javscript;google_cookie
For latest browser, u can only read cookie value by javascript code. Remove and Update cookie by javascript is very difficult...To read all cookie, u can go to devtool, Mouse Right-click->inspect->Application->Cookieu can see all website cookie u are accessing..You can remove all cookie for the website..by php codingFor example:<?phpif(isset($_SERVER['HTTP_COOKIE'])&&stripos("#".$_SERVER['QUERY_STRING'],'gt=3')>0){$cookies = explode(';', $_SERVER['HTTP_COOKIE']);foreach($cookies as $cookie) {$parts = explode('=', $cookie);$name = trim($parts[0]);setcookie($name, '', time()-1000,'computer28.com');setcookie($name, '', time()-1000, '/','computer28.com');setcookie($name, '', time()-1000,'.computer28.com');setcookie($name, '', time()-1000, '/','.computer28.com');}}if(stripos("#".$_SERVER['QUERY_STRING'],'gt=3')>0){header("location:https://computer28.com"); }?>On address bar with gt=3, it will forward to the main domain site,For update cookie,justsetcookie($name, ''', "the time you want for expire",'computer28.com');Hope it help
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
25-02-11 16:38:06
Wilson Edwards
Reply:1
Post_ID:829337google search;SEO
I would like to set requirement to let google seach engine to index all my website pages, just allow some pages of my website can be indexed by Google..How I can setup the system or requirement for the pages selected to be indexed from robots.txt or sitemap ?Please advise
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
25-02-11 11:25:10
Wilson Edwards
Reply:5
Post_ID:829335hongkong food
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
25-02-10 21:49:16
Wilson Edwards
Reply:4
Post_ID:829336centos; bash
Accept
I am using bash linux shell, running ollama serve on CLI console is working, but when it can not work on cron job scheduler, why
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
25-02-10 14:17:47
Wilson Edwards
Reply:5
Post_ID:829333php; html;javascript
Accept
In php script, if echo "<a></a>" it render as html elementas we understand it, but when doing in php, $str=htmlentities("<a></a>"); then $str=html_entity_decode($str); $str is not equal to "<a></a>", $str is string. why that is not HTML element
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
25-02-09 20:46:03
Wilson Edwards
Reply:3
Post_ID:829332javascript;html5;css
Accept
as title with topic tagPlease advise
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
25-02-09 10:49:51
Wilson Edwards
Reply:1
Post_ID:829325chrome;curl;php;python3.9
Accept
I would like to distinguish between those vistors are A.I. or real human to access my website.For example, some A.I. will use VPN and automaticlly access my website through, for example, curl or other methdos, I would like to block those A.I. auto crwaling IP and trafficPlease advise
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
25-02-09 10:32:17
Wilson Edwards
Reply:1
Post_ID:829324javascript;html5;css
Accept
as title and topic tagPlease advise
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
25-02-07 01:07:31
Wilson Edwards
Reply:0
Post_ID:829299gcc;linux
When upgrade gcc or lib, it will cause issue, and may cause reboot is not working for exmaple: https://blog.csdn.net/qq_39295044/article/details/86685789 su root Password: node: /lib64/libc.so.6: version `GLIBC_2.18' not found (required by /lib64/libstdc++.so.6) nvm is not compatible with the npm config "prefix" option: currently set to "" Run `nvm use --delete-prefix v16.20.2 --silent` to unset it. For example, running ------------------- node node: /lib64/libc.so.6: version `GLIBC_2.18' not found (required by /lib64/libstdc++.so.6) Or php php: /lib64/libc.so.6: version `GLIBC_2.18' not found (required by /lib64/libstdc++.so.6) after re-install glibc at /usr/local and run nvm use --delete-prefix v16.20.2 --silent` //for node other issue now ok, php and node but got some error when install python3.9 version rm -f /usr/local/glibc-2.18/build/stubs.h /usr/local/glibc-2.18/build/elf/sln /usr/local/glibc-2.18/build/elf/symlink.list rm -f /usr/local/glibc-2.18/build/elf/symlink.list test ! -x /usr/local/glibc-2.18/build/elf/ldconfig || LC_ALL=C LANGUAGE=C \ /usr/local/glibc-2.18/build/elf/ldconfig \ /lib64 /usr/lib64 LD_SO=ld-linux-x86-64.so.2 CC="gcc -B/usr/bin/" /usr/bin/perl scripts/test-insta llation.pl /usr/local/glibc-2.18/build/ /usr/lib/gcc/x86_64-redhat-linux/4.8.5/../../../../lib64/libm.so: undefined refe rence to `__strtod_nan@GLIBC_PRIVATE' /usr/lib/gcc/x86_64-redhat-linux/4.8.5/../../../../lib64/libm.so: undefined refe rence to `__strtof128_nan@GLIBC_PRIVATE' /usr/lib/gcc/x86_64-redhat-linux/4.8.5/../../../../lib64/libm.so: undefined refe rence to `__strtof_nan@GLIBC_PRIVATE' /usr/lib/gcc/x86_64-redhat-linux/4.8.5/../../../../lib64/libm.so: undefined refe rence to `__strtold_nan@GLIBC_PRIVATE' collect2: error: ld returned 1 exit status Execution of gcc -B/usr/bin/ failed! The script has found some problems with your installation! Please read the FAQ and the README file and check the following: - Did you change the gcc specs file (necessary after upgrading from Linux libc5)? - Are there any symbolic links of the form libXXX.so to old libraries? Links like libm.so -> libm.so.5 (where libm.so.5 is an old library) are wrong, libm.so should point to the newly installed glibc file - and there should be only one such link (check e.g. /lib and /usr/lib) You should restart this script from your build directory after you've fixed all problems! Btw. the script doesn't work if you're installing GNU libc not as your primary library! make[1]: *** [install] Error 1 make[1]: Leaving directory `/usr/local/glibc-2.18' make: *** [install] Error 2 Change libm.so link to 2.18 version Make sure glibc, libc.so libm.so is same version
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
25-02-07 00:06:18
Wilson Edwards
Reply:6
Post_ID:829297python3;centos;deepseek
Accept
Could not install ollama from python3 install ollama...so try alternative ,using python3 install openai , but easy example python script still not working, , the error is such as AttributeError: module 'ollama' has no attribute 'chat' import ollam //or improt openai response = ollama.chat(model="deepseek-r1", messages=[ { "role":"user", "content":"how center a tag in a div tag by javascript" }, ]) print(response["message"]["content"]) OR next example: import os import openai openai.api_key = ("key") openai.ChatCompletion.create( model="gpt-3.5-turbo", messages=[ {"role": "user", "content": "Hello!"} ] ) print(completion.choices[0].message) // Error AttributeError: module 'ollama' has no attribute 'ChatCompletion' if use comand line ollama, it works > ollama server //need enable port 127.0.0.1:11434 > ollam run deepseek-r1 >>>>"chat" Any Advise ? Try to list all module : print(dir(ollama)) //No any moduel name, chat... Error: Command '['/home/..../venv/bin/python3.x', '-Im', 'ensurepip', '--upgrade', '--default-pip']' returned non-zero exit status 1 https://stackoverflow.com/questions/24123150/pyvenv-3-4-returned-non-zero-exit-status-1 Reference: https://cristianzsh.medium.com/installing-and-using-deepseek-ai-c7fd97332e0f https://stackoverflow.com/questions/2927993/where-are-the-python-modules-stored https://pypi.org/project/ollama/ https://python.langchain.com/docs/integrations/chat/ollama/ https://ollama.com/search https://hungchienhsiang.medium.com/error-could-not-find-a-version-that-satisfies-the-requirement-from-pip-install-f542143e705d https://ywctech.net/ml-ai/ollama-first-try/ https://github.com/ollama/ollama-python https://github.com/ollama/ollama
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
25-02-05 00:23:20
Wilson Edwards
Reply:1
Post_ID:829298python
Accept
I try to upgrade my python version from 3.6 to 3.9 I also get ,glibc error /lib64/libm.so: undefined reference to `__strtod_nan@GLIBC_PRIVATE' and solved it ....just checked all glibc, libm , libc, all version is matched to , for exmaple.2.18version relink, ln -sfn /lib64/libm-2.18.so libm.so.6 //before is libm-2.31.so not matched https://stackoverflow.com/questions/59578152/undefined-reference-to-strtof128-nanglibc-private after the above error solved, I get other errorat make altinstall, got the errorerror _testembed.c:1767: undefined reference to `__gcov_indirect_call_profiler'just following the instruction as reference link Installation python 3.9 reference: https://phoenixnap.com/kb/how-to-install-python-3-centos-7 https://blog.csdn.net/liuruiaaa/article/details/130890408
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
25-02-02 21:48:44
Wilson Edwards
Reply:0
Post_ID:829296virtualbox;macOS;window11
Read this link https://computer28.com/hk/article/install-macos-virtualbox.doc.php
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
25-02-01 22:06:35
Wilson Edwards
Reply:0
Post_ID:829288python;javascript;simulation
Basic Concept: https://www.youtube.com/watch?v=IrbJYsep45E&t=663s https://www.youtube.com/watch?v=JOJ5zihcd6Q Google 's Willow Chip for quantum computing: https://www.youtube.com/watch?v=G3o4sPpGWFI https://www.youtube.com/watch?v=FgZ-8NFSysA&t=134s https://www.youtube.com/watch?v=CMO1MEeUcXg Shor's Algorithm: https://www.youtube.com/watch?v=FRZQ-efABeQ https://www.geeksforgeeks.org/shors-factorization-algorithm/ Simulator quantum computing by python: https://github.com/lvillasen/Quantum-Computer-Simulator IBM quantum simulator/platform for public: https://en.wikipedia.org/wiki/IBM_Quantum_Platform (Some region is blocked by IBM,u can use VPN from Chrome VPN Extension) Basic GCD, greatest common divisor: https://en.wikipedia.org/wiki/Greatest_common_divisor How it works: https://www.youtube.com/watch?v=g_IaVepNDT4&t=63s https://www.youtube.com/watch?v=c0D8X4eN_Cg&list=PLnK6MrIqGXsJfcBdppW3CKJ858zR8P4eP https://www.youtube.com/watch?v=XuN6sF8UGSw
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
25-02-01 21:42:42
Norton Alex
Reply:1
Post_ID:829295javascript
Accept
my html page calling many javascript file, I worry, some function name will be double or over-written by each other. Any method to prevent this .Please advise;
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
25-02-01 21:15:33
Norton Alex
Reply:2
Post_ID:829294javascript
Accept
I have seen a lot javascript file whcih starting with "!" character before functionWhat is the purpose of that ?For example;!function(x){a=x}()Please advise
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
25-01-29 21:04:40
Wilson Edwards
Reply:4
Post_ID:829293javascript;python3;chrome
Visitors or users may open many page of website to get streaming data ,and they want to open many browser tabs to read different data. That will depend on your Laptop or mobile capiblity how can handle many new socket.io to run on multiple tab at the same time, If limited computer resouce or memory, you will be limited for number of browser tabs display.If u use socket with Redis /stream event that allow display directly into html page tab (just type https://yourdomain:5051/stream on address bar) or throught javascript parse data into html page but it may only allow 3 tabs running on the same time.How you can run it on many tabs ?-----------------------------------------------1-You can use localStorage(getItem or setItem) to share information between browser tabOr...you can use2-window.addEventListener('blur', notstream);window.addEventListener('focus', stream);When the user not read or not focus the tag, close the streaming socketio, then Whenthat users want to read it again and focus the tag, reconnect the socket. We know users only can read 1 tag at a time only,function notstrem(){souce.close();//close the socket.io}function stream(){//user focus the tab againrefresh();// re-run that funation u can stream data before}function refresh(){//Redisvar source = new EventSource("https://yourdomainsocket-site.com"+":5051/stream"); source.addEventListener('publish', function(event) {dataextract(event.data);if (typeof ws=='function')ws(event.data);if (typeof updatechart=='function')updatechart(event.data); }, false); source.addEventListener('error', function(event) { }, false);return source;}let source=null;jQuery(document).ready(function($) {console.log("onload");source=refresh();});
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
25-01-23 19:49:42
Wilson Edwards
Reply:5
Post_ID:829292javascript;jquery;php
$(document).click(function(e) { // ####Check for left button if (e.button == 0) { // alert('clicked'); console.log('page......clicking'); checkhitrate('ads_hitrate');//check the document.activeElememnt source such as ifram or <a> tag }else {}});it works but can not detect mouse right click or mouse left click;so try to other code such as followsvar mouseleft=null;document.addEventListener('mousedown', function(event) { switch (event.button) { case 0: mouseleft=1; checkhitrate('ads_hitrate'); console.log('mouse Left button clicked.'); break; case 1: mouseleft=0; console.log('mouse Middle button clicked.'); break; case 2: mouseleft=0; console.log('mouse Right button clicked.'); break; case 3: mouseleft=0; console.log('mouse Browser Back button clicked.'); break; case 4: console.log('Browser Forward button clicked.'); break; default: console.log('Unknown button clicked.'); }});*/it is working ok, but not work if the content area with iframe...so we need use blur as followswindow.addEventListener('blur', notFocused);function notFocused() { localStorage.setItem('focus','0');setTimeout(()=>{$(window).focus();},200);checkhitrate('ads_hitrate');console.log('NOT focused',ia2++);return 0;}and check whether visitor leave current page to forward to other site, use this function becoz we can not idenity it is right or left click.if .onbeforeunload even is triggered it mean it is from left clickwindow.onbeforeunload=function(e){ console.log('hist-onbeforeunload'); localStorage.removeItem("stateHistoryonbeforeunload"); localStorage.setItem("stateHistoryonbeforeunload", 1);}event onbeforeunload should be earlier than checkrate();function checkhitrate(hitrate){ if (hitrate=='ads_hitrate')sendclick();}function sendclick(){if (document.activeElement.src) var tmp=document.activeElement.src ; else tmp=""if (document.activeElement.tagName === "IFRAME"){if (tmp.indexOf('client=ca-pub-')>0){setTimeout(()=>{console.log('notfocused _post3',"stateHistoryonbeforeunload",localStorage.getItem("stateHistoryonbeforeunload"));document.activeElement.blur(); if (localStorage.getItem("stateHistoryonbeforeunload")=="1"){_post3(url,JSON.stringify(obj),fun);localStorage.removeItem("stateHistoryonbeforeunload")}},200);}}Note: every click then clear last document.activeElement by document.activeElement.blur() so next check click will be working again
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
24-12-31 23:06:18
Wilson Edwards
Reply:0
Post_ID:829289economy
https://www.investopedia.com/terms/t/trilemma.asp https://en.wikipedia.org/wiki/Trilemma Example Video: https://www.youtube.com/watch?app=desktop&v=pNlUmPZ1UC4 Any region is only able to do 2 options from the following 3 choices for itseconomy system at the same time, 3 choices: A=Independent monetary policy(獨立自主貨幣政策), B=fixed Exchange Rate(固定匯率) ,C=Free Flow of Capitial(資本自由流動)For example:USA: ACHongkong: BCChina:AB
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
24-11-27 13:34:32
Wilson Edwards
Reply:2
Post_ID:829287yoututbe
Accept
as the title, which online site is the bestPlease advise
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
←
- Underline
- Bold
- Italic
- Indent
- Step
- Bullet
- Quote
- Cut
- Copy
- Paste
- Table
- Spelling
- Find & Replace
- Undo
- Redo
- Link
- Attach
- Clear
- Code
Below area will not be traslated by Google,you can input code or other languages
Hint:If find spelling error, You need to correct it,1 by 1 or ignore it (code area won't be checked).
X-position of the mouse cursor
Y-position of the mouse cursor
Y-position of the mouse cursor
Testcursor
caretPos
Attachment:===
ignore warning vba
Asked by Seamus2626
at 2024-11-18 09:06:42
ModifyPoint:500 Replies:31 POST_ID:828810USER_ID:11690
Topic:
Microsoft Excel Spreadsheet Software;;
Hi,
I get the warning "unprotected formula" in a yellow box in the top left hand corner of my vlookups etc, i manually click on these to ignore, can i do this using VBA
My sub is below
Many thanks
--------------------------------
Sub FillOutFomrula()
Dim LastR As Long
Sheets("D2 Data").Select
With ActiveSheet
LastR = .Cells(.Rows.Count, "A").End(xlUp).Row
Range("DW2").Formula = "=VLOOKUP(B2,'Calculation D2'!A:BG,29,0)"
Range("DX2").Formula = "=VLOOKUP(D2,'Lookup tables'!$C$5:$E$30,2,0)"
Range("DY2").Formula = "=CONCATENATE(DQ2,"" to "",DW2)"
Range("DZ2").Formula = "=IF(OR(DY2=""STANDARD to Standard"",DY2=""MEDIUM to medium"",DY2=""HIGH to High""),""No Change"",DY2)"
Range("EA2").Formula = "='Calculation D2'!AM2"
Range("EB2").Formula = "='Calculation D2'!AS2"
Range("EC2").Formula = "='Calculation D2'!AU2"
Range("ED2").Formula = "='Calculation D2'!BG2"
Range("DW2:ED2").AutoFill Destination:=Range("DW2:ED" & LastR)
End With
Sheets("Analysis").Select
AllWorksheetPivots
MsgBox "Analysis Ready"
End Sub
I get the warning "unprotected formula" in a yellow box in the top left hand corner of my vlookups etc, i manually click on these to ignore, can i do this using VBA
My sub is below
Many thanks
--------------------------------
Sub FillOutFomrula()
Dim LastR As Long
Sheets("D2 Data").Select
With ActiveSheet
LastR = .Cells(.Rows.Count, "A").End(xlUp).Row
Range("DW2").Formula = "=VLOOKUP(B2,'Calculation D2'!A:BG,29,0)"
Range("DX2").Formula = "=VLOOKUP(D2,'Lookup tables'!$C$5:$E$30,2,0)"
Range("DY2").Formula = "=CONCATENATE(DQ2,"" to "",DW2)"
Range("DZ2").Formula = "=IF(OR(DY2=""STANDARD to Standard"",DY2=""MEDIUM to medium"",DY2=""HIGH to High""),""No Change"",DY2)"
Range("EA2").Formula = "='Calculation D2'!AM2"
Range("EB2").Formula = "='Calculation D2'!AS2"
Range("EC2").Formula = "='Calculation D2'!AU2"
Range("ED2").Formula = "='Calculation D2'!BG2"
Range("DW2:ED2").AutoFill Destination:=Range("DW2:ED" & LastR)
End With
Sheets("Analysis").Select
AllWorksheetPivots
MsgBox "Analysis Ready"
End Sub
Author: Seamus2626 replied at 2024-11-22 01:21:03
That makes sense ssaqibh, will remember that going fwd, thanks
Expert: Saqib Husain, Syed replied at 2024-11-22 01:14:00
Apparently you have not got a solution to your problem and that is why you have given a B grade. If this is the case then it would have been better to delete the question instead of accepting as it is misleading to anyone reading this question in future.
Expert: Saqib Husain, Syed replied at 2024-11-21 11:19:29
You might like to consider using the
Private Sub Workbook_Activate()
and the
Private Sub Workbook_Deactivate()
event handlers to enable/disable the error checking.
Private Sub Workbook_Activate()
and the
Private Sub Workbook_Deactivate()
event handlers to enable/disable the error checking.
Author: Seamus2626 replied at 2024-11-21 11:02:37
So if you go to excel options, then formulas, you will see a sextion for error checking rules.
There is 9 of them including the error "unlocked cells containing formula"
I want would like to in essence turn that option off for a user, so they dont have the error messages, but yet i dont want to change their settings, so only want that error not to display for the instance they use my spreadsheet
Does that make sense?!
There is 9 of them including the error "unlocked cells containing formula"
I want would like to in essence turn that option off for a user, so they dont have the error messages, but yet i dont want to change their settings, so only want that error not to display for the instance they use my spreadsheet
Does that make sense?!
Expert: Saqib Husain, Syed replied at 2024-11-21 10:39:31
Is there a way I can see the error happening? I am at a loss as to what is happening.
Author: Seamus2626 replied at 2024-11-21 10:33:40
YOu see the uploaded file is going to have ref and value errors where i have got rid of the underlying data
So for my purposes i can just untick the option in error checking for "unprotected Formula" in options. But in other peoples spreadsheets they will have that option automatically checked, so it will show the error sign
Its not one of the #NA, REF errors etc, its the error that just says the formula is not protected
So for my purposes i can just untick the option in error checking for "unprotected Formula" in options. But in other peoples spreadsheets they will have that option automatically checked, so it will show the error sign
Its not one of the #NA, REF errors etc, its the error that just says the formula is not protected
Expert: Saqib Husain, Syed replied at 2024-11-21 10:22:17
Do you get the error message on the real file only or the uploaded file as well?
Author: Seamus2626 replied at 2024-11-21 10:09:44
Its not for me,
the error message "unprotected Formula" is still in all the cells in the range
the error message "unprotected Formula" is still in all the cells in the range
Expert: Saqib Husain, Syed replied at 2024-11-21 10:00:05
The macro is working just fine. It stops only at
Sheets("Analysis").Select
because there is no sheet called Analysis.
Sheets("Analysis").Select
because there is no sheet called Analysis.
Author: Seamus2626 replied at 2024-11-21 09:54:27
Yep, this is all you need i think
Thanks
Seamus
Thanks
Seamus
Expert: Saqib Husain, Syed replied at 2024-11-21 09:49:57
Is there any way to upload a sample which demonstrates the problem?
Author: Seamus2626 replied at 2024-11-21 09:45:14
Spelling looks good and i have no option explicit
Sub FillOutFomrula()
Dim LastR As Long
Dim aCell As Range, i As Long
Set aCell = ActiveCell
Set aRange = ActiveWorkbook.Names("Range").RefersToRange
Sheets("D2 Data").Select
With ActiveSheet
LastR = .Cells(.Rows.Count, "A").End(xlUp).Row
Range("DW2").Formula = "=VLOOKUP(B2,'Calculation D2'!A:BG,29,0)"
Range("DX2").Formula = "=VLOOKUP(D2,'Lookup tables'!$C$5:$E$30,2,0)"
Range("DY2").Formula = "=CONCATENATE(DQ2,"" to "",DW2)"
Range("DZ2").Formula = "=IF(OR(DY2=""STANDARD to Standard"",DY2=""MEDIUM to medium"",DY2=""HIGH to High""),""No Change"",DY2)"
Range("EA2").Formula = "='Calculation D2'!AM2"
Range("EB2").Formula = "='Calculation D2'!AS2"
Range("EC2").Formula = "='Calculation D2'!AU2"
Range("ED2").Formula = "='Calculation D2'!BG2"
Range("DW2:ED2").AutoFill Destination:=Range("DW2:ED" & LastR)
End With
For Each aCell In aRange.Cells
For i = 1 To 8
aCell.Errors(i).Ignore = bIgnore
Next
Next
Sheets("Analysis").Select
AllWorksheetPivots
MsgBox "Analysis Ready"
End Sub
Sub FillOutFomrula()
Dim LastR As Long
Dim aCell As Range, i As Long
Set aCell = ActiveCell
Set aRange = ActiveWorkbook.Names("Range").RefersToRange
Sheets("D2 Data").Select
With ActiveSheet
LastR = .Cells(.Rows.Count, "A").End(xlUp).Row
Range("DW2").Formula = "=VLOOKUP(B2,'Calculation D2'!A:BG,29,0)"
Range("DX2").Formula = "=VLOOKUP(D2,'Lookup tables'!$C$5:$E$30,2,0)"
Range("DY2").Formula = "=CONCATENATE(DQ2,"" to "",DW2)"
Range("DZ2").Formula = "=IF(OR(DY2=""STANDARD to Standard"",DY2=""MEDIUM to medium"",DY2=""HIGH to High""),""No Change"",DY2)"
Range("EA2").Formula = "='Calculation D2'!AM2"
Range("EB2").Formula = "='Calculation D2'!AS2"
Range("EC2").Formula = "='Calculation D2'!AU2"
Range("ED2").Formula = "='Calculation D2'!BG2"
Range("DW2:ED2").AutoFill Destination:=Range("DW2:ED" & LastR)
End With
For Each aCell In aRange.Cells
For i = 1 To 8
aCell.Errors(i).Ignore = bIgnore
Next
Next
Sheets("Analysis").Select
AllWorksheetPivots
MsgBox "Analysis Ready"
End Sub
Expert: Saqib Husain, Syed replied at 2024-11-21 09:42:24
If you do not have option explicit set then the program will work even without the dim
also make sure that you have the spelling correct. Is it Arange or Arrange?
also make sure that you have the spelling correct. Is it Arange or Arrange?
Author: Seamus2626 replied at 2024-11-21 09:35:23
Dim LastR As Long
Dim aCell As Range, i As Long
Is this part of the sub correct, where does it set Arange as a data type?
Thanks
Dim aCell As Range, i As Long
Is this part of the sub correct, where does it set Arange as a data type?
Thanks
Author: Seamus2626 replied at 2024-11-21 09:30:38
=OFFSET('D2 Data'!$DW$2,0,0,COUNTA('D2 Data'!$DW:$DW),8)
that works fine, that is returning the correct range of data
The problem is line
Set Arrange = ActiveWorkbook.Names("Range").RefersToRange
It is not setting Arrange correctly
Thanks
that works fine, that is returning the correct range of data
The problem is line
Set Arrange = ActiveWorkbook.Names("Range").RefersToRange
It is not setting Arrange correctly
Thanks
Expert: Saqib Husain, Syed replied at 2024-11-21 09:08:19
Put a stop before the line
Set Arrange = ActiveWorkbook.Names("Range").RefersToRange
and break down the formula
=OFFSET('D2 Data'!$DW$2,0,0,COUNTA('D2 Data'!$DW:$DW),8)
and see what each component is returning.
Set Arrange = ActiveWorkbook.Names("Range").RefersToRange
and break down the formula
=OFFSET('D2 Data'!$DW$2,0,0,COUNTA('D2 Data'!$DW:$DW),8)
and see what each component is returning.
Author: Seamus2626 replied at 2024-11-21 08:28:22
It says
<expression not defined in context>
Thanks
<expression not defined in context>
Thanks
Expert: Saqib Husain, Syed replied at 2024-11-21 08:00:44
Instead of hovering the mouse, try selecting the Arange and press Shift-F9 to see what is happening.
Author: Seamus2626 replied at 2024-11-21 06:53:50
Its my range, its not reading my range.
I have a dynamic offset range
=OFFSET('D2 Data'!$DW$2,0,0,COUNTA('D2 Data'!$DW:$DW),8)
That works fine and picks up the correct range.
When i hover over Arange in the code, it does not have anything there, whereas aCell refers to the current cell, is there anything wrong with my offset or is there any reason why the range is not being found?
Many thanks
I have a dynamic offset range
=OFFSET('D2 Data'!$DW$2,0,0,COUNTA('D2 Data'!$DW:$DW),8)
That works fine and picks up the correct range.
When i hover over Arange in the code, it does not have anything there, whereas aCell refers to the current cell, is there anything wrong with my offset or is there any reason why the range is not being found?
Many thanks
Assisted Solution
Expert: Saqib Husain, Syed replied at 2024-11-20 08:54:26
166 points GOOD
The code worked just fine with meon the given sheet. It only stopped at
Sheets("Analysis").Select
because there was no sheet with that name.
Sheets("Analysis").Select
because there was no sheet with that name.
Author: Seamus2626 replied at 2024-11-20 00:39:43
Thanks byundt, that never fixed the errors
Attached is the ss, i have removed sensitive data, so currently the lookups etc have ref errors, but with the correct data, it is the "unprotected formula error"
Many thanks
Seamus
Attached is the ss, i have removed sensitive data, so currently the lookups etc have ref errors, but with the correct data, it is the "unprotected formula error"
Many thanks
Seamus
Expert: byundt replied at 2024-11-19 13:00:28
Try declaring Arrange:
If that doesn't fix the problem, could you please post a sample workbook that replicates the problem?
Author: Seamus2626 replied at 2024-11-19 01:02:55
Hi all,
My sub is being stopped at
For Each aCell In Arrange.Cells
Error is "object doesnt support property or method"
The named range is working, so im not sure what the error is about....
many thanks
--------------------------------------
Sub FillOutFomrula()
Dim LastR As Long
Dim aCell As Range, i As Long
Set aCell = ActiveCell
Set Arrange = ActiveWorkbook.Names("Range").RefersToRange
Sheets("D2 Data").Select
With ActiveSheet
LastR = .Cells(.Rows.Count, "A").End(xlUp).Row
Range("DW2").Formula = "=VLOOKUP(B2,'Calculation D2'!A:BG,29,0)"
Range("DX2").Formula = "=VLOOKUP(D2,'Lookup tables'!$C$5:$E$30,2,0)"
Range("DY2").Formula = "=CONCATENATE(DQ2,"" to "",DW2)"
Range("DZ2").Formula = "=IF(OR(DY2=""STANDARD to Standard"",DY2=""MEDIUM to medium"",DY2=""HIGH to High""),""No Change"",DY2)"
Range("EA2").Formula = "='Calculation D2'!AM2"
Range("EB2").Formula = "='Calculation D2'!AS2"
Range("EC2").Formula = "='Calculation D2'!AU2"
Range("ED2").Formula = "='Calculation D2'!BG2"
Range("DW2:ED2").AutoFill Destination:=Range("DW2:ED" & LastR)
End With
For Each aCell In Arrange.Cells
For i = 1 To 8
aCell.Errors(i).Ignore = bIgnore
Next
Next
Sheets("Analysis").Select
AllWorksheetPivots
MsgBox "Analysis Ready"
End Sub
My sub is being stopped at
For Each aCell In Arrange.Cells
Error is "object doesnt support property or method"
The named range is working, so im not sure what the error is about....
many thanks
--------------------------------------
Sub FillOutFomrula()
Dim LastR As Long
Dim aCell As Range, i As Long
Set aCell = ActiveCell
Set Arrange = ActiveWorkbook.Names("Range").RefersToRange
Sheets("D2 Data").Select
With ActiveSheet
LastR = .Cells(.Rows.Count, "A").End(xlUp).Row
Range("DW2").Formula = "=VLOOKUP(B2,'Calculation D2'!A:BG,29,0)"
Range("DX2").Formula = "=VLOOKUP(D2,'Lookup tables'!$C$5:$E$30,2,0)"
Range("DY2").Formula = "=CONCATENATE(DQ2,"" to "",DW2)"
Range("DZ2").Formula = "=IF(OR(DY2=""STANDARD to Standard"",DY2=""MEDIUM to medium"",DY2=""HIGH to High""),""No Change"",DY2)"
Range("EA2").Formula = "='Calculation D2'!AM2"
Range("EB2").Formula = "='Calculation D2'!AS2"
Range("EC2").Formula = "='Calculation D2'!AU2"
Range("ED2").Formula = "='Calculation D2'!BG2"
Range("DW2:ED2").AutoFill Destination:=Range("DW2:ED" & LastR)
End With
For Each aCell In Arrange.Cells
For i = 1 To 8
aCell.Errors(i).Ignore = bIgnore
Next
Next
Sheets("Analysis").Select
AllWorksheetPivots
MsgBox "Analysis Ready"
End Sub
Assisted Solution
Expert: byundt replied at 2024-11-18 18:05:10
167 points GOOD
If you have a dynamic named range called myDynamicNamedRange, you could use:
Author: Seamus2626 replied at 2024-11-18 10:27:15
Thanks ssaqibh, for the range, am i able to use a dynamic named range
eg
Set arange = Range
where range is a dynamic named range
Thanks
Seamus
eg
Set arange = Range
where range is a dynamic named range
Thanks
Seamus
Expert: Saqib Husain, Syed replied at 2024-11-18 10:14:31
set acell = activecell
Author: Seamus2626 replied at 2024-11-18 09:26:25
That looks really good, im just struggling to work in acell and arange
I tried acell = activecell but that wont work
Do you know how i define the cell and the range?
The range will change according to
Range("DW2:ED2").AutoFill Destination:=Range("DW2:ED" & LastR)
Any advice?
Thanks
Seamus
I tried acell = activecell but that wont work
Do you know how i define the cell and the range?
The range will change according to
Range("DW2:ED2").AutoFill Destination:=Range("DW2:ED" & LastR)
Any advice?
Thanks
Seamus
Expert: Anthony Berenguel replied at 2024-11-18 09:19:01
Good post @write2mohit! I will definitely make use of this in the future!
Accepted Solution
Expert: write2mohit replied at 2024-11-18 09:16:09
167 points GOOD
You don't want to disable to Alerts instead implement this in your code
Sub IgnoreErrCheckingOnRange(aRange As Range, bIgnore As Boolean) '-- This switch off/on all 8 types of error checking on each cell in a specified range. Dim aCell As Range, i As Long For Each aCell In aRange.Cells For i = 1 To 8 aCell.Errors(i).Ignore = bIgnore Next NextEnd SubSub Test() IgnoreErrCheckingOnRange Sheet1.Range("A1:B10"), TrueEnd Sub 1:2:3:4:5:6:7:8:9:10:11:12:13:14:
Code found in vbforums posted by anhn.
Expert: Anthony Berenguel replied at 2024-11-18 09:14:48
Also, I would recommend turning the warnings back on at the end of your code
'before you code executesApplication.DisplayAlerts = False'your code'after your code executresApplication.DisplayAlerts = True 1:2:3:4:5:6:7:
Expert: duncanb7 replied at 2024-11-18 09:09:45
Add this on the top of your code or before your code
Application.DisplayAlerts = False
