Deleting all formulas in a worksheet when unprotected in VBA code
I would like to know the vba code for deleting all formulas within a worksheet if the worksheet is unprotected by any one, obviously I would have to have an administrators code in case I need to unprotect the worksheet myself. My workbook contains many worksheets and with many formulas I have...
Answer Question
| Sep 26 2008 9:52 AM GMT
| asked by
Barnoldswick
Excel 2003, Excel formulas, Microsoft Excel
Is vlookup the correct formula to use for my task?
This is the formula that I am trying to write:When the cell row values in columns A and B, are equal to the cell row values in colums E and F are the same, I would like that information to appear side by side in separate colums for comparison. For any company data that does not match with vendor...
View Answer
| Sep 4 2008 3:54 PM GMT
| asked by
Ginaque
VLOOKUP, Excel formulas, Microsoft Excel
Excel Form Macro
Hello Excel Gurus,I am in great need for an Excel Froms Macro that Switches a Spin Control (asignes integer value) to a cell and is mux'ed betwen different cell references that are activated by a radio button. I created a model code fragment well over a year ago and got the functionality to work...
View Answer
| Aug 24 2008 11:27 PM GMT
| asked by
Dinosaur99
SpinButton, Excel functions, Excel macros
Current Date in Excel Query
I am using Excel 2003. I am trying to run a query that will used daily and the only thing that will change with the query is the current date. Is there a way to use a formula saved in the query that will automatically use the current date instead of having to manually input it everytime?Thank you!
View Answer
| Jul 17 2008 6:32 PM GMT
| asked by
Jameb12
Query, Excel 2003, Excel formulas
Adding dayys to a date without adding weekends
I want to enter a date into a cell in microsoft excel and in another cell I want it to add five days onto the previous date without includind the weekends in so if I enter the 7/16/2008 into the first cell then I want to have it add five work days making it the 7/23/2008 instead of five regular...
View Answer
| Jul 17 2008 4:38 PM GMT
| asked by
Hoganstech
Calendar, Microsoft Excel, Excel formulas
Ms Excel Question
i have entered different students name in column A, Paper name in Column B & their marks in column C. like:john english 90magi maths 15john stats 99john history 35 & i've applied this formula:=if(A2:A66000="John",sum(C2:C66000))to get the total marks of John in all...
View Answer
| Jul 4 2008 8:51 AM GMT
| asked by
Moonzy
Excel formulas, Microsoft Excel
Excel 2003 linking text format in two workbooks
I have 8 different workbooks that are linked to one master workbook. In each of the 8 workbooks people need to select certain names and change the text format to bold. however when the master workbook is open and updated the BOLD format is not there. Each of the 8 workbooks are changed monthly...
View Answer
| May 30 2008 6:58 PM GMT
| asked by
Carourke
Excel 2003, Linking workbooks, Excel formulas
Search for duplicates in a collumn and delete the row on which it occurs
Hi,I have a spreadsheet with list of identifiers in collumn 1, this is auto generated and due to the source info some of them duplicated, what I want to do is find the duplicates and remove the entire row they appear on.I know this is possible using clipboard and filters but I would rather avoid...
View Answer
| May 6 2008 1:47 PM GMT
| asked by
Harleq
Excel formulas, Excel functions, Excel macros
Retreiving data from within square brackets, there may be more than one in each cell (spreadsheet owner refuses to change it grrrr)
I have a spreadsheet with a column containing data in the following format Column GRow 1 [1T40131A] [GB50131A] [GB50131B] [GB50131C] [1T50131D]Row 2 [1T400133]Row 3 [303640]*VFRow 4 [240700]*RNI would like to create a UDF that will retrieve the data within the...
View Answer
| May 2 2008 8:51 AM GMT
| asked by
Harleq
Excel formulas, Excel functions, Excel macros
