Log in

View Full Version : Excel Help



Pages : 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 [96] 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 154 155 156 157 158 159 160 161 162 163 164 165 166 167 168 169 170 171 172 173

  1. How to escape characters in Microsoft Excel, such as an equals sign? (6 replies)
  2. Solved: How do you create a quiz with microsoft excel 2007? (4 replies)
  3. Solved: Looping through Worksheets and inserting a formula into a Range of Cells (4 replies)
  4. I/O Excel to PicAxe Micro (3 replies)
  5. Solved: Format Chart Area (8 replies)
  6. Solved: Time format in user form (3 replies)
  7. Solved: Error with Recorded Macro (4 replies)
  8. Help with VBA code (3 replies)
  9. VBA for batch upload (3 replies)
  10. Solved: Sound alert (11 replies)
  11. Solved: Copy .txt file (2 replies)
  12. Sub routine isn't sending outlook message.. (12 replies)
  13. Using a click button to select data relating to checkboxes (5 replies)
  14. Simple Copy and paste (11 replies)
  15. Solved: Colour change based on cell value (6 replies)
  16. Match columns linked to external workbook (1 replies)
  17. Solved: special sort (7 replies)
  18. Solved: If value found, copy range macro help! (5 replies)
  19. Interactive Drop Down List/file chooser (0 replies)
  20. Solved: Insert picture (2 replies)
  21. Help reg user form development (1 replies)
  22. VBA programming question on cell selection and optimization (9 replies)
  23. Changing CommandBars.Name (5 replies)
  24. Solved: Calling a Script From Another Module (1 replies)
  25. Solved: VLOOKUP accross sheets (1 replies)
  26. Command Button Shrinkage (3 replies)
  27. Preserving Objects and Collections (1 replies)
  28. Solved: Making CheckBox1 Selected By Default (1 replies)
  29. Populate a field on a webpage and submit and record data (5 replies)
  30. how to find last non empty cell in col and use it as input in a range (3 replies)
  31. Any of you guys familiar with web query... (3 replies)
  32. Getting Week Numbers to Display over Multiple Years without Resetting to 1 (11 replies)
  33. Solved: Cell value capture (6 replies)
  34. Save Data to a Closed Workbook. (5 replies)
  35. Solved: faster way to delete row (4 replies)
  36. Copy Worksheets to a new Workbook (2 replies)
  37. custom order? (1 replies)
  38. Library Not Registered error (11 replies)
  39. Solved: User Input With Options (6 replies)
  40. Solved: Sum the distinct values under a specific criteria (8 replies)
  41. How to acees server xml file (0 replies)
  42. Solved: extend the border line (5 replies)
  43. Solved: Formatting Dynamic Toolbar (13 replies)
  44. Solved: Adding a New Toolbar (5 replies)
  45. Solved: Changing time string? (26 replies)
  46. Solved: Copying Named Ranges (2 replies)
  47. Solved: Can't get If,Or, to work (5 replies)
  48. Runtime error '1004' Application-defined or object-defined error regarding if formula (12 replies)
  49. Copy a table from an excel sheet to an Embedded Excel Chart Object's Sheet (7 replies)
  50. Solved: Monthly to Quarterly Part 2 (6 replies)
  51. Solved: Scrollbar (2 replies)
  52. Solved: Count unique entries that occur over consecutive dates (7 replies)
  53. Solved: Condionally Formatting a Row Based on a Cell Condition (7 replies)
  54. Solved: import empty column QueryTables thnks (3 replies)
  55. Solved: Buttons (8 replies)
  56. Solved: Deleting Rows based on criteria (6 replies)
  57. Solved: Problem with amended xld.sheetmanager code (6 replies)
  58. comparision macro is very slow (6 replies)
  59. Solved: how can i change this code to identifiy the 2 digit no? (5 replies)
  60. Solved: Limit character input in a textbox (5 replies)
  61. Solved: Check if combo box is populated (10 replies)
  62. Solved: User Changeable File Paths (4 replies)
  63. Automatic upload excelsheet (html) to web (0 replies)
  64. Copy Folder to specified path... (4 replies)
  65. Solved: Excel match headers, append data (2 replies)
  66. Solved: Seperate each recipient into own tab (12 replies)
  67. Button press effect in Excel Shape (1 replies)
  68. Search folder with a value in cell (3 replies)
  69. Pull data to new workbook with new sheet per workbook (4 replies)
  70. Solved: vba to ID info in cells and find other cells with same info (18 replies)
  71. Scrolling issue, going too far (2 replies)
  72. Solved: Check 1st 4 chars & conditionally enter a string (10 replies)
  73. Managing Duplicate Conditional Formatting Rules in Excel 2007 (0 replies)
  74. Solved: RecordSet and ListView (4 replies)
  75. Obtain version number of SharePoint document (2 replies)
  76. Open Publisher doc from Excel then edit (2 replies)
  77. New landscape Word doc from Excel (1 replies)
  78. Solved: Cell reference in VB (5 replies)
  79. Get Data From Acess (3 replies)
  80. Moving ExcelMacro to Access (3 replies)
  81. Macro to export cell values to Word (8 replies)
  82. Solved: Tracking changes with comments (7 replies)
  83. Solved: multi columns selected (7 replies)
  84. Solved: Remove All Comments (2 replies)
  85. Lock cell formatting but allow value input (1 replies)
  86. Solved: How to copy rows in different worksheets created on the fly (9 replies)
  87. Animated Gif Help (1 replies)
  88. Solved: PRINT AREA VBA (4 replies)
  89. Text to Columns Wizard - Way to save off positions? (9 replies)
  90. Solved: Cells showing as formulas...not results. (5 replies)
  91. Problem with Excel - Access macro (1 replies)
  92. Solved: combine from all sheets (6 replies)
  93. Completely at a loss... (5 replies)
  94. Solved: Find in 3 colums and list the result in a list box.. (8 replies)
  95. plotting a named range within a named range (8 replies)
  96. Run a macro contained in an add-in using keyboard shorcuts? (2 replies)
  97. What Does “Insert Names” Mean on the VBE Screen? (2 replies)
  98. [SOLVED:] Help with MsgBox Function (2 replies)
  99. Solved: User defined function and copy paste (3 replies)
  100. Button embedded in a chart, xl2007 (0 replies)
  101. Get a Structure from a Pointer (10 replies)
  102. How To separate VBA application into file (3 replies)
  103. Runtime Error 1004 with working accross worksheets & string concatenation (2 replies)
  104. Weird Type Mismatch Problem (Cell Formula vs. Cell Value) (11 replies)
  105. Solved: Active cell display (5 replies)
  106. Solved: Command button colour change if file missing (24 replies)
  107. find and compare (5 replies)
  108. text box (1 replies)
  109. ActiveX in Excel (2 replies)
  110. Solved: syntax: shell (6 replies)
  111. Change Customer ID (7 replies)
  112. Transpose or array? (6 replies)
  113. [SOLVED:] Call every X seconds (4 replies)
  114. Change 1 character in cell (15 replies)
  115. Save to SharePoint Library w/meta (1 replies)
  116. Code moves cells out of range (1 replies)
  117. Solved: copy worksheet to another workbook (16 replies)
  118. Solved: Problem in Find & FindNext for a Function call (10 replies)
  119. Solved: Problem with date Picker Control (4 replies)
  120. Solved: lost vblf's (3 replies)
  121. Populate ListBox with Filtered Records (16 replies)
  122. VBA code to enable autofilter on protected sheets (1 replies)
  123. Solved: parse and new column (5 replies)
  124. Solved: Search for cell values then sum scell to...... (4 replies)
  125. Loop through variables (5 replies)
  126. Macro 4 (1 replies)
  127. Creat Pivot table by VBA (1 replies)
  128. Operators in Arguments question (11 replies)
  129. Solved: Is there a way around using a tonn of ascii references...... (2 replies)
  130. Solved: Form VBA (2 replies)
  131. Pointer to Workseet (9 replies)
  132. need help with rounding formula (3 replies)
  133. Eventdriven XML Export (2 replies)
  134. Searching within a pivot table (0 replies)
  135. Solved: Sumproduct calculating total incorrectly due to date (6 replies)
  136. Solved: How to copy formatted number cells visible text? (5 replies)
  137. Workbook Sequencing Only on Saves (2 replies)
  138. Autofilter code not working (3 replies)
  139. Help... What have I done !! (1 replies)
  140. Help with the Loop (6 replies)
  141. Solved: Removing duplicates based on two columns (4 replies)
  142. AUTOMATICALLY CLICK DEFAULT MESSAGE BOX (3 replies)
  143. Weird insert line problem... (6 replies)
  144. copy entire column and paste into another workbook (1 replies)
  145. Printing daily log sheet with preprinted dates (solved) (3 replies)
  146. Solved: countif - help required (5 replies)
  147. Solved: creating recap with macro (2 replies)
  148. Solved: Help with value testing (6 replies)
  149. [SOLVED:] Time difference formula required (5 replies)
  150. Solved: Formula to help identify specific words in titles? (18 replies)
  151. Solved: Copying an entire Letter from word document (3 replies)
  152. Help using Access as backend for Excel (5 replies)
  153. Solved: Microsoft Internet Controls Library (1 replies)
  154. VBA - Format with lanuage change (0 replies)
  155. Help with Create Hyperlinked List of Directory Contents (3 replies)
  156. Self-saving workbook? (9 replies)
  157. Solved: Removing a Item from Listbox. (4 replies)
  158. Hiding Rows takes Time (1 replies)
  159. Solved: Sumproduct - Summing (9 replies)
  160. Using VLookup and Maximum statements or what will work (2 replies)
  161. Solved: The magically disappering Excel Workbook. (7 replies)
  162. passing FieldInfo value as a variable (3 replies)
  163. [SOLVED:] Tabbing order (1 replies)
  164. Solved: SpecialCells(xlCellTypeVisible) does not seem to work in range object (4 replies)
  165. Conversion and Icons (0 replies)
  166. update data via listbox (4 replies)
  167. Module to delete rows (11 replies)
  168. VBA not working on both sheets (5 replies)
  169. Simple Copy and Paste Mystery (10 replies)
  170. Excel save file - 2007 (6 replies)
  171. Feedback form Help (1 replies)
  172. IF formula for identifying unique rows (quite confusing problem) (5 replies)
  173. Help regarding reminders about birthdays of employees in advance(2days) (1 replies)
  174. Solved: make certain cells visible (3 replies)
  175. Please help with my Pivot Table VBA Code. (6 replies)
  176. Solved: Find Duplicates (6 replies)
  177. Solved: Move numbers from DOC to XLS (4 replies)
  178. Solved: Get a line from a text file. (20 replies)
  179. Something weird with vba (5 replies)
  180. SpinButton (12 replies)
  181. convert xls to csv large number problems (5 replies)
  182. Solved: Pease help on CTRL-SHIFT ENTER on my VBA Formula (11 replies)
  183. Extract One column from multi-column array (4 replies)
  184. Excel reversing cell value? (2 replies)
  185. Solved: Function to wait until a particular file exists (7 replies)
  186. Solved: PDF to Excel Data extract automatically (13 replies)
  187. Extract to multiple text files (3 replies)
  188. Loopthroughsheets following code (2 replies)
  189. Runtime Error 9 (0 replies)
  190. Solved: vba autofilter (3 replies)
  191. Code help (11 replies)
  192. Solved: Control Filter (2 replies)
  193. UF Case Mutliple values in cell (4 replies)
  194. How to call value from one sheet to another sheet using VBA macro (0 replies)
  195. Activesheet is not working. What may be the cause? (1 replies)
  196. Solved: Prompt to enable macro (4 replies)
  197. Solved: Help to apply contract penalties (18 replies)
  198. Solved: Help with simple Macro (I'm sure) (2 replies)
  199. Getting the PivotTable Page data from another sheet (7 replies)
  200. VBA for pasting excel chart in powerpoint (0 replies)
  201. vba Trim help (5 replies)
  202. Solved: Tab (6 replies)
  203. Is there a faster way to perform this function? (8 replies)
  204. Creating Userform Instructions (7 replies)
  205. How to find the Count of Records in List in atleast one-null scenario? (12 replies)
  206. UF Radio Button get value (4 replies)
  207. Visual Basic (for applications) (7 replies)
  208. Solved: UF Copy Textbox Value (2 replies)
  209. Solved: Syntax to "print in header" (3 replies)
  210. Print a UserForm (4 replies)
  211. Exit Userform and close excel (1 replies)
  212. combined Vlookup & Hlookup? (7 replies)
  213. VBA Code: Populating data in different sheets (0 replies)
  214. Solved: How to get data from TextBox? (4 replies)
  215. Duplicate numbers (4 replies)
  216. Variable (6 replies)
  217. Using the Number Formatting Language to Specify the “BOLD” Attribute (3 replies)
  218. [SOLVED:] Modify exiting VBA code to open one sheet instead of several multiple sheet copied (9 replies)
  219. need typo conditional formating code (4 replies)
  220. Unable to set the Visible property of the Worksheet class (3 replies)
  221. entirerow.delete (1 replies)
  222. Solved: Range Select and Delete certain Values (2 replies)
  223. entirerow. (2 replies)
  224. Function to write the Interior Color (8 replies)
  225. Data validation.........vba array (1 replies)
  226. Solved: Always open a new instance of excel (5 replies)
  227. Solved: {Solved}calculation:multiply (0 replies)
  228. Can't get Match Index Formula right (1 replies)
  229. Solved: Combine multiple sheet become one (2 replies)
  230. Solved: insert a date for the current year (2 replies)
  231. Solved: Merging data from two spreadsheets (0 replies)
  232. Solved: VBA - Range and value match and replace (2 replies)
  233. Solved: UserForm Help for Travel Log (1 replies)
  234. Select cell before sheet deactivate (0 replies)
  235. Solved: Excel VBA code to merge 2 columns into 1 (2 replies)
  236. Solved: Redim a range (4 replies)
  237. Run-time error for Highlighting (4 replies)
  238. [SOLVED:] Identify Button that has been clicked (9 replies)
  239. filter (4 replies)
  240. Solved: copy data automatically to another sheet (5 replies)
  241. Solved: change font color after updated (4 replies)
  242. Solved: How do you write this formula in VBA code? (7 replies)
  243. Solved: AutoFilter, Criteria, Header (4 replies)
  244. Using conditional formatting in 2007 (2 replies)
  245. Copy range by condition (3 replies)
  246. Ont-time Alert on breaking threshold (0 replies)
  247. Avg last ten (0 replies)
  248. Solved: Speed with array vs. dictionary (3 replies)
  249. [SOLVED:] Add prefix to a number (19 replies)
  250. [SOLVED:] Get cell comment text in another cell (2 replies)