How do you highlight and drag down dates (day, month, date, and year) , e.g. see Column A. It doesn't work, but if you highlight and drag down Column D or Column E, it works. How can I do it with Column A? Thank you.
When trying to use your example as a template:
>>> use code - tags <<<
Range("'calculator'![a30:a36]").ClearContents
' Range("'calculator'!a30").ClearContents
' Range("'calculator'!a31").ClearContents
' Range("'calculator'!a32").ClearContents
' Range("'calculator'!a33").ClearContents
'...
I need a macro that clears the alphanumerical entries of a worksheet so the user doesn't have to do it manually.
Please see the yellow highlighted cells (A-4..A28, A30..A36, A38..A47, A50..E76, F51..F76, and H75) on the attached worksheet.
Is there a better way than listing each cell...see...
I have a 20 Mb and growing spreadsheet that takes about 10 minutes to save. I would like a macro that when ran, will simply save the current spreadsheet/workbook and upon completing the "save," will beep or play a tune so that I can visit the lunch room or coffee pot while waiting and listen...
p45cal, et. al.
The following version written by Marc L, works the fastest; however, it intermittently leaves a string of "zeros" past the data in Columns E and F for about 3200 rows [see picture below]. Sometimes it does it, sometimes not.
>>> use code - tags <<<
Sub Marc_L() 'Written by...
There is one minor problem with this version. It picks up the "background highlight color" of cell E5 and propagates that across the "matches" as seen below. ...First picture below is cell E5, the next picture shows cells >36,000 rows deep with same background highlight color as cell E5.
What...
Please see the attached sanitized spreadsheet.
I need a macro that will scan down Column J looking for the word “Canceled” and replace (in the same row) whatever may be in Columns E and F with “N/A”
If "N/A" is already there, skip to the next occurrence of "Canceled" until all rows have...
BTW, I did as you suggested: Pastes values into pre-formatted destination cells to adopt their number formatting.
I'm guessing that since we got different results with the same files that Excel version / Windows version may be the root of the problem?
I just realized
I tried Formatting the entirety of columns (K) in both Demo1 and Demo-2 to "Custom" mm/dd/yyyy then copied a row (E through L) and still got the date in serial number. Any other suggestions?
Paste Special -> Values works except it treats the date as a 5-digit number instead of a proper looking date. e.g. 43329 vs. 08/17/2018.
Have any other suggestions? [Yes to All] really should work.
That's a pretty bold statement for someone who's only been a member 8 days, and weighing in on a question that's over 3 months old.
BUT, in case you don't understand "diet" and really care, please re-read Panels #1, #2, and especially the link in #3.
Please see the two attachments, Demo-1 and Demo-2. I have six Name Manager formulas in Demo-1. When I try to copy a single row (Columns E through F) from file Demo-2 to file Demo-1, I see: Note: SearchFor70
If I click either [Yes] OR [Yes to All] I see: Note: SearchFor75, then...
I have a VBA macro which "cleans" up the data before I process it; however, it cleans up too well in Column D.
If the character data in any cell in Columns A-F is all numbers, the macro (CleanUp_9) deletes the data found in that cell. Fortunately, the only column that "may" have all numbers is...