quickly

I want to join a list of date together quickly. the join function requires the text function for every single date. Is there an easier way to join a list of date together?

Hi All, I need your help to find out only formula cell with highlight with color quickly. i have a large file with lot of small formula. Thanks

<tbody> Joe & Sue Smith 123 Main St Chicago, IL 60601 Lets say I have a large column of data in this exact format. Any way I can separate this out quickly in excel into a name, then address, then city, state, zip formats? </tbody>

Hi I have a spreadsheet containing a dropdown menu There has never been an issue using it in the past, however we have recently upgraded to 2016 and when i click on it now the drop_down arrow quickly appears then disappears again. In other tabs within the same spreadsheet , the dropdowns all...

Hi, does anyone know a way to give a hash value of a whole excel workbook? I need to quickly compare two workbooks that have 20+ tabs as quickly as possible, without uploading them to a dodgy website.

Hi All, can i quickly merge multiple excel files Data in single file? Heading should be same or different? Thanks. Majid

Range("C5:C" & Rows.Count).End(xlDown).Clear In the above line of code, data after C5 not getting clear. I used this too Range("C5:C" & Rows.Count).End(xlDown).ClearContents Can any one quickly suggest on this

Hi everyone, I'm running the Solver add in, trying to find combinations of cells that sum up to a certain value. It's been running for over 20 minutes, maybe even longer. Right now it's on "Subproblem 4700" or so. And the "Trial Solutions" are going by very quickly. Does anybody know what...

hi, I need to refresh Query (PQ) after file saving. Is there any way to check if is fully saved before executing next line? In below code if any user would switch sheets very quickly I get run-time error. Private Sub Worksheet_Activate() ActiveWorkbook.Save ActiveWorkbook.Connections("Query...

Hello All, I have been using command prompt copy *.csv combined.csv However it has started failing for me on 1/2 the files. (trying to combine 365 files) Does anyone know another way to combine multiple .csv files quickly Regards, Simon

I'm trying to figure out why my screentip will sometimes appear next to the cursor and other times it'll appear at the bottom of the window. Does anyone have an idea as to why this happens or how it can be corrected? It happens at random, and if you move quickly off of it and back onto it, it'll...

Good Morning, I posted a thread about IF(OR and unfortunately, the site time's you out very quickly. I didn't realize that would happen and when I tried to submit my full post it ended up posting half of what I wrote. I went back and replied to my own post with the remaining information but now...

Hi Folks, I am new to excel VBA as I am now passion to learn all about Excel VBA. Could you all please advice me to learn quickly and effectively. Thanks In Advance To All!!!! Regards, nvreddy

I have a huge spreadsheet of 77 columns and close to 78,000 rows that I need to run the clean and trim functions to clean the data. Is it possible to create a macro that will both clean invisible characters and leading and trailing spaces. I can't use spreadsheet functions because I have to too...

Hi, I have the same data validation formula set for the range B:B on a couple of hundred worksheets. I need it replaced throughout the workbook by another formula. Is there a way to do it quickly with a macro or something? Changing the thing by hand will take half a day at least... Thanks...

Hi, I am running excel 2010 on windows 7 and due to the memory limitation in one session of excel (ours keel over when they hit 900MB) we are forced to run 2 separate instances. In each of the sessions we have a number of workbooks open. The problem we have is quickly switching from a...

Dear All, Is anyone aware of a quick way of deleting all named ranges within a given workbook? I can loop over them, but it takes forever. (I've got about 20,000 names in total). Turning the normal things off doesn't do much good either (e.g. auto-calculating, events, etc)