Programming
in [Excel]
|
.value hi all !!! let's watch this part of my sub as example.. my question is .. is there any reason why i setted all the range as value ?? is it a lose of time and cpu undere extensive usage or has that any reason ??? tx ! paolo Range("D10").Value = 0 Range("L32").ClearContents Range("E80").Value = aWS.Range("B8").... 14 May 2010 18:20
if-then functions I have a two sheet workbook. If 'sheet 1 B7' contains a certain word I want "Sheet2 B2' to return the value in 'Sheet 1 B8". Can I do this? How? Thanx ... 14 May 2010 17:14
Removing or deleting Checkboxes from workbook After copying data off the web into Excel I get lots of HTMLCheckboxes which I don't want and bloat the wookbook slowing down loading, processing, and saving. Any suggestions on deleting all checkboxes?? -- Brian McNamee ... 27 May 2010 17:04
Macro to add worksheet hi,all I have a document that is 1 columns. I want add worksheets for example: A1 sheet1 sheet1 sheet1 sheet8 ----->VBA add sheet sheet8 sheet8 sheet3 sheet3 ...... ...... ... 14 May 2010 20:31
Macro to control Print area/view I have a document that is about 5,000 rows and 25 columns. In some cases I need to print all content, and in other cases I need only to print the left 20 cloumns. I currently do this by goint into print view and moving the blue lines into the appropriate places. I am not very familiar with Macros but have be... 14 May 2010 17:14
Ignore error I have a spreadsheet that consists of multiple years of data that have some headings and footings between each set of 12 monthly rows. One column of data has a formula like this: =X140-T140-U140 Every cell except the January cell has the little "Inconsistent data" mark. "The formula in this cell differs fro... 14 May 2010 19:26
Search and display based on cell value On page one. I have various full names listed throughout the worksheet in various places. When a user clicks on a cell with a name in it, I want them to be directed to sheet 2 where the same name (cell values) is found in column A. (There will be profile info starting with their name in column A.) ... 14 May 2010 12:50
formula to VBA How do I go from this formula =INT(G20/12) & " ft. " & MOD(G20,12) & " in." to a line in VBA that will perform in this function: Function ConvertInches(intInches) Dim intInches As Integer Dim intFeet As Integer ConvertInches = INT(intInches/12) & " ft. " & MOD(intInches,12) & " in." ... 15 May 2010 00:50
Excel 2007 "Protect Sheet" option not available Hi there, In Excel 2007 I tried to protect certain ranges. I don't know exactly what I did, but suddenly the "Protect Sheet" option is no longer available (it's of course still there but cannot be selected, only "Protect Workboo" is selectable). I cannot figure out how to unlock the Protect Sheet option. Any ... 14 May 2010 10:37
OPEN WORKBOOK Hi, have a workbook abc****.xls in c:\myfolder\ I want to open it **** is of variable length I think I need to use something like Workbooks.Open Filename:= c:\myfolder\ or maybe should I call the abc****.xls to a cell first Thanks in advance -- Message posted via http://www.officekb.com... 14 May 2010 10:37 |