Copy the contents of a range of cells to a single comment (indicator)?
How do you copy the contents of a range of cells to a single comment (indicator)? I have a range of cells ("n12:n14"), and want to copy the contents into a single comment indicator within the activecell. anybody help? Thanks Mik ... 29 Apr 2010 20:22
I have an array with about 1500 names in it. How can I add those names to column A1 on sheet1 and go down one cell 1500 times and add the next value to the spreadsheet? in Excel07 VBA ... 29 Apr 2010 19:14
I have an array with about 1500 names in it. How can I add those names to column A1 on sheet1 and go down one cell 1500 times and add the next value to the spreadsheet? in Excel07 VBA ... 30 Apr 2010 06:12
Enable Spelling Check
Hello all, I have an Excel file that password-protects the worksheets and workbook. Due to the password-protecting the worksheets, the Spelling option under Tools menu is not available. Could someone help me with a code to have the Spelling option enabled while the worksheets are password-protected? Tha... 30 Apr 2010 16:19
Getting Data Validation to execute when using Paste Special... Val
I know that when data is normally pasted into a cell that contains Data Validation, the Data Validation rule is deleted/cleared. However, if I use Paste Special... Values, for example, the Data Validation rule is preserved, although it does not execute. It's only if I subsequently edit the cell (after having ... 30 Apr 2010 05:07
Checking if some cells are empty when file is being saved
Is there something that can be checked if the "Save" function is executed. I have a file with a number of worksheets and I don't want a user to be able to save it without entering some data. Once the "save" is selected I would like to check to see if all required fields are still empty so I can display an er... 29 Apr 2010 16:57
referring cell in macro function
If a create a macro intended to be used as a function in a worksheet is there a property of the referring cell? I want to know what cell the formula is in. ... 29 Apr 2010 16:57
Is there a way to speed up Calculation !!!!!!!!!!!!!!!
I have this line of code in my macro: Wks.Range("G3:GA732").Calculate This line of code takes over an hour to execute. The range is all SUMPRODUCT formulae and I have to run the report daily. It takes about 2 hours to run the report. 90% of that is spent executing the "Calculate" code above. What I need... 29 Apr 2010 19:14
Setting up a macro that can be ran from any excel file.
I built a macro that I want to be able to run from any excel file I open. I think you have to save it in a "personal" workbook that is hidden, but I'm having troubles setting it up and editing it in a personal workbook. I get a message telling me to use the unhide command, but not sure where to find this. Ho... 29 Apr 2010 18:05
Count Images in an Excel Sheet
I have saved excel sheets with screen prints in it. I need to know if I can get the total number of screen shots in a particular excel sheet. ... 29 Apr 2010 16:57