|
If I have 2 non-adjacent cells selected eg A1 and A4, hit Ctrl+C, and then Ctrl-V in a different application I only want the contents of A1 and A4 pasted into my document, not A1, A2, A3, and A4. Within Excel itself only the selected cells are pasted, but it barfs the selected values as soon as you try to go outside.
Did you ever see history portrayed as an old man with a wise brow and pulseless heart, weighing all things in the balance of reason?
Is not rather the genius of history like an eternal, imploring maiden, full of fire, with a burning heart and flaming soul, humanly warm and humanly beautiful?
--Zachris Topelius
Training a telescope on one’s own belly button will only reveal lint. You like that? You go right on staring at it. I prefer looking at galaxies.
-- Sarah Hoyt
|
|
|
|
|
Yep, known problem. What you can do is hide the unwanted cells/columns/rows before copying.
|
|
|
|
|
...or just delete the unwanted stuff after copying.
- I would love to change the world, but they won’t give me the source code.
|
|
|
|
|
... or copy 1 at a time.
... or paste into empty cells in Excel (end of rwo) and then copy a second time to paste externally.
There are many workarounds. They're all ![Elephant | [mastadon]](https://codeproject.freetls.fastly.net/script/Forums/Images/elephant.gif) ed.
Did you ever see history portrayed as an old man with a wise brow and pulseless heart, weighing all things in the balance of reason?
Is not rather the genius of history like an eternal, imploring maiden, full of fire, with a burning heart and flaming soul, humanly warm and humanly beautiful?
--Zachris Topelius
Training a telescope on one’s own belly button will only reveal lint. You like that? You go right on staring at it. I prefer looking at galaxies.
-- Sarah Hoyt
|
|
|
|
|
|
Pretty sure with the learning curve factored in, writing any sort of macro there would take longer than the time I'm spending on this task. (Probably 2-4 hours.)
Did you ever see history portrayed as an old man with a wise brow and pulseless heart, weighing all things in the balance of reason?
Is not rather the genius of history like an eternal, imploring maiden, full of fire, with a burning heart and flaming soul, humanly warm and humanly beautiful?
--Zachris Topelius
Training a telescope on one’s own belly button will only reveal lint. You like that? You go right on staring at it. I prefer looking at galaxies.
-- Sarah Hoyt
|
|
|
|
|
Except that I need the intermediate column data for sanity checking if what I'm copying out makes sense, and reordering the columns to make the two I'm copying adjacent would may the eyeball checks harder to do.
Did you ever see history portrayed as an old man with a wise brow and pulseless heart, weighing all things in the balance of reason?
Is not rather the genius of history like an eternal, imploring maiden, full of fire, with a burning heart and flaming soul, humanly warm and humanly beautiful?
--Zachris Topelius
Training a telescope on one’s own belly button will only reveal lint. You like that? You go right on staring at it. I prefer looking at galaxies.
-- Sarah Hoyt
|
|
|
|
|
You could temporarily paste in one editor (visual studio or notepad++) which supports alt + mouse click as an edition possibility and select-delete the data you do not need.
|
|
|
|
|
That's a lot of assumptions for the receiving app. Find 2 adjacent locations. Or combine, creating a new table. Maybe a horizontal stack panel. Or vertical. Or.
Apps can read the clip board. Someone has to code what has to happen.
It was only in wine that he laid down no limit for himself, but he did not allow himself to be confused by it.
― Confucian Analects: Rules of Confucius about his food
|
|
|
|
|
I have an LG BlueRay disc drive that is compatible with M discs. I am trying different burning software apps that will burn 25 GB M discs reliably. If any members have experience with specific software, I will love to get their suggestions / recommendations. Thanks in advance!
Get me coffee and no one gets hurt!
|
|
|
|
|
Doing data backups or are you that lone guy who still watches movies with a BlueRay player ?
|
|
|
|
|
Movies I stream. It's purely for backups. 
Get me coffee and no one gets hurt!
|
|
|
|
|
HA!
A bluRay player is the only way to watch movies if, like me, you live where even 5Mb broadband is but a distant dream, promised now for over 7 years, but yet to be delivered!
8)
|
|
|
|
|
If you want a fun project, you can always set up Plex on a spare computer in your home network 🤓 You'll need a lot of hard drive space if you want uncompressed Blu-Rays though. But I can't argue with the simplicity of using a Blu-Ray player... Just plug it in and it works.
|
|
|
|
|
I bought a Blue Ray player, a Blue Ray movie, watched it once and then used the player for regular DVDs two or three times and haven't touched it since. It's (literally) gathering dust somewhere.
- I would love to change the world, but they won’t give me the source code.
|
|
|
|
|
Somewhat similar - but my only blue ray device is an internal drive on my 'best' desktop. I probably used it for something else, but the only use that really comes to mind was testing that it works.
I don't believe I've ever watched a blue-ray movie. Then again, I'm satisfied with raster-scanned black & white TV.
| Ravings en masse^ |
|---|
| "The difference between genius and stupidity is that genius has its limits." - Albert Einstein | | "If you are searching for perfection in others, then you seek disappointment. If you seek perfection in yourself, then you will find failure." - Balboos HaGadol Mar 2010 |
|
|
|
|
|
I use Leawo for everything media.
"One man's wage rise is another man's price increase." - Harold Wilson
"Fireproof doesn't mean the fire will never come. It means when the fire comes that you will be able to withstand it." - Michael Simmons
"You can easily judge the character of a man by how he treats those who can do nothing for him." - James D. Miles
|
|
|
|
|
I've used ImgBurn to burn ISOs on both 25GB and 50GB Blu-ray discs.
|
|
|
|
|
Sure, me too. Works like a charm!
|
|
|
|
|
The site I found indicates ImgBurn hasn't been updated since 2013. Am I looking at the wrong site? I found it on other sites, but the same version 2.5.8.0
|
|
|
|
|
www.imgburn.com
And 2.5.8.0 is the version I have. The file date I have on disk is from 2013.
Isn't it sad that people are now so used to relentless updates, they automatically assume that something that old must surely be broken/no longer working?
Kudos to developers who realize some software does reach a completion point, and that more addons just means more bloat. I'm looking at you, Microsoft...
|
|
|
|
|
dandy72 wrote: Isn't it sad that people are now so used to relentless updates,
 Since 2013 there have been a number of significant Windows updates, including Windows 10. A lot of software that operates on a lower level has been updated to work with or work correctly with the newer operating systems. Also, security updates are a consideration. There is FAR more to consider than "relentless updates".
I've been burned a few times when using older software that was no longer supported. In this case, switching to a different program would probably have little impact on me, but having been burned, I pay attention to details.
modified 4-Dec-20 13:24pm.
|
|
|
|
|
Well, I haven't been burned (har) with imgburn yet. Been using it longer than I've been using Windows 10 and it's always worked just fine for me. If it ever fails, there are multiple free alternatives to go to.
|
|
|
|
|
I suggest you look at the item from Jacquers below. Test the main ImgBurn executable on the VirusTotal website if you want to see for yourself.
Get me coffee and no one gets hurt!
modified 4-Dec-20 12:29pm.
|
|
|
|
|
Yeah, I came across that too. However, I already had a 'clean' version on my main machine so I just used that on the machine I was trying to install imgburn on.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
