Dear Expert,
I have a macro in a workbook which is used as a tamplate. Whenever it is opened, there is messege that asks the user to Enable or Disable the macro, some people choose to disab...
When I open an Excel 2003 spreadsheet (that resides on a server) it opens it twice (2 separate instances) with the same name. Only difference is that each title is appended with a ":1" and "...
I am working on a large workbook with many vlookups. I am running into the same problem over and over again. I have data tabs that update daily from a SQL database. Charts read these data t...
Just wonder if it is possible either to embed or to link to a video file with Excell 2003, like if I have a drawing like a plan and each section of the plan with be linked to a video on the sa...
Hi
I have a dynamic range defined (as per instructions from this website - cheers :-)). I have a problem however, when the range inclues some totally empty cells. If the data has not been l...
Attached is the spreadsheet that I want to combine rows on, I have deleted most of the data.
I want to combine rows that have the same ASX code (column B) IF the buy date (column G) is wi...
Hello, when a workbook opens, how do i set it to run a public sub Tail, every 2 mins.
I want to be able to put into my spreadsheet a function or formula that will calculate how many days there are in between a range of dates. For example:
07/29/08 to 07/30/08 is 1 day.
...
Hi
In a Windows 2003 / XP Pro domain environment with redirected application data, what is the best way to open Excel workbooks in landscape page setup for printing purposes as the default?...
Hi,
If I have a cell with both the name and surname (e.g. John Doe in cell A1), is there any way to retrieve only the surname? (e.g. Cell B1 would automatically retrieve Doe)
I have a cell with a number in it on a certain tab. I want to hit a button that will show me everything that references the number in that cell throughout my entire workbook. NOTE: I know that...
I have an Access Database program that is creating Excel Workbooks, however, I have hidden sheets that require some VBA code. I need a way to create the VBA code inside each Excel Workbook cr...
I have an excel spreadsheet and I am trying to combine multiple rows into one row. I want to combine the Description column for all rows where ST_ID, SM_Category, SM_SubCategory and SM_StartD...
Hello,
Via Excel VBA, I am attempting to create a powerpoint application that contains two slides, and each slide has a differnt template as the backdrop. I have tried the following, where...
Hi
Is it possible to add validation to a field to allow numbers only using vb code in an excel worksheet. This would have to work in all rows .
Thank you
ok hopefully this doesn't turn out to be too complicated.
I am trying to compare strings together and consider them duplicates, though sometimes they are slightly different though always in...
I do a lot of vlookups between various sources of data. Source data is text but sometimes the other data does not get found on the lookup because of different formats. If i reformat the cells ...
Hi
Is there a way to use the row number returned by COUNTA() function in a cell reference?
For example, COUNTA(A2:A65535) may return 182. This is the row number of the last cell with dat...
I will like to utilize the vlookup function in excel VBA. I have the lookup table on sheet1 and I have a combo box on sheet2 looking up the values in column A of sheet1. when a value is sele...
Is there a way to read from Excel VBA if the "Trust Access To Visual Basic Project" setting is enabled or disabled?
If it is disabled, I could pompt the user to enable it manually, or alterna...
I have been using the code below to save my file to Csv. It works well except if I protect the sheed it gives an error
For i = 1 To [a1].SpecialCells(xlLastCell).Row
Can this be modifid to ...
Is there a function that would highlight which cells contain spelling mistakes. I don't actually need the function to run the actual spell check procedure but just show which cells contain the...
I do not want to protect the entire excel sheet. The users need to edit entries in the columns as they update their progress. The last cell is the sum of the nunmbers the user has entered....
What is the best way to search a range of values in an excel worksheet to find all of the blank values? And, ideally, provide a listing of the cells that contain the missing values.
Whever I open up a CSV file with other sheets in the backgrond with large amount of formulas in them Excel will seem to calculate the entire sheet. is there anyway to disable this? I already...
