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 174

  1. Solved: Deleting Rows (11 replies)
  2. Solved: SumProduct vs. SUM ?? (22 replies)
  3. Solved: Activating a worksheet whose name is customized (3 replies)
  4. Left and Find Function Syntax (3 replies)
  5. How to copy two non-contiguous cells (11 replies)
  6. AD lastLogonTimestamp Is my code right? (1 replies)
  7. Postcode Macro - Amending (5 replies)
  8. Userform to change password in VBE (10 replies)
  9. Solved: Deleting Rows if a particular string doesnt exist in it (9 replies)
  10. conditonal formatting (1 replies)
  11. Disable Macro Security by VBA (3 replies)
  12. Hide Rows based several values (3 replies)
  13. How to skip the cell? (1 replies)
  14. Batch file execution (2 replies)
  15. Solved: Why do my URL's change after saving a workbook? (4 replies)
  16. Solved: UDF to emulate Weeknum() (15 replies)
  17. [SOLVED:] Shortcut to inserting rows (3 replies)
  18. How to remove everything but one sheet? (14 replies)
  19. unsort after sort (1 replies)
  20. How to search for phonetic similarities in Addresses (6 replies)
  21. Solved: Cell Arrangement (3 replies)
  22. question on 'Install or Uninstall ActiveX Controls (.ocx, .dll files)' (2 replies)
  23. Solved: VBA beginner exercise (9 replies)
  24. select case and looping problem (5 replies)
  25. Why does Object Browser Show Same Items Multiple Times? (13 replies)
  26. Solved: Shapes: Some Explanation Please (17 replies)
  27. Solved: Pass a workbook and worksheet name (14 replies)
  28. A Free ebook on Excel from MrExcel.com (2 replies)
  29. Solved: type mismatch on open (15 replies)
  30. Solved: Creating new worksheets (2 replies)
  31. Auto fill a form (3 replies)
  32. Solved: Non-Contiguous Copy PasteSpecial (10 replies)
  33. a list of all formula in activeworkbook (20 replies)
  34. Solved: Pass Variable Reference (2 replies)
  35. [SOLVED:] Stopwatch in Excel !!!! (2 replies)
  36. "Unable to get the Find property of the range class" Error (4 replies)
  37. Copying an entire sheet into another workbook (24 replies)
  38. Send Key function help (4 replies)
  39. Solved: Excel 2007 viewer (8 replies)
  40. Solved: Copy works, copy/paste doesn't... (bug?) (19 replies)
  41. [SOLVED:] Conditional formatting on several sheets (6 replies)
  42. Solved: string problem (2 replies)
  43. Solved: Changing text in multiple cells (6 replies)
  44. WORKDAY function (3 replies)
  45. Count --> all worksheets (2 replies)
  46. convert a number into month (3 replies)
  47. Paste Special? (2 replies)
  48. Solved: Excel 2007 Multiplication Bug Da Capo... (4 replies)
  49. Delete unmatched records (7 replies)
  50. Shorter way of putting names to SeriesCollection (8 replies)
  51. Pivot Table Settings (1 replies)
  52. Solved: Insert Rows and Transpose (2 replies)
  53. Add records to table (excel) (1 replies)
  54. Check for active Word document (1 replies)
  55. Amend code - (3 replies)
  56. Solved: Code execution interrupted (4 replies)
  57. Holiday planner/tracker (1 replies)
  58. Solved: Multiple Pivot Tables - simultaneous field change (6 replies)
  59. Critical Error: Odd Behavior on This particular Line all day (1 replies)
  60. Need a function to convert mm to inches (20 replies)
  61. output to textfile (2 replies)
  62. Change empty cell to a character in VBA (15 replies)
  63. Solved: Deleting group of rows if string pattern doesnt match (12 replies)
  64. [SOLVED:] Prevent Delete of Certain Sheets (13 replies)
  65. Solved: Loops and linking to Internet Explorer Excel file (3 replies)
  66. Solved: How to call an action based on input (4 replies)
  67. Setting values to a whole range at once (4 replies)
  68. Excel Add ins - Free Ones (3 replies)
  69. Not sure how to Amend current VBA code to do one more step (2 replies)
  70. Solved: Close all instances of IE (4 replies)
  71. Excel 2007 Multiplication Bug?! (5 replies)
  72. Calling Word macro from Excel macro (2 replies)
  73. Rename Multiple files. Help wanted (6 replies)
  74. [SOLVED:] Excel/Word timing problem (14 replies)
  75. Running a macro when excel startsup (2 replies)
  76. Get File Extension (4 replies)
  77. Commenting code (4 replies)
  78. Returning to Excel from Paste in Word (2 replies)
  79. Solved: Using Object Browser: Discover New Info (11 replies)
  80. Disable menu options (2 replies)
  81. Highlight row if date is this week (14 replies)
  82. Pivot table macro (3 replies)
  83. Buggy scope of a variable (22 replies)
  84. Error Handling: Complete exit (3 replies)
  85. Solved: Assist in Converting IF-Then to Select Case (12 replies)
  86. Adding text to existing text (3 replies)
  87. Freezing two top rows (2 replies)
  88. Getting Weekday as String and working with dates (12 replies)
  89. Help with a while wend loop (2 replies)
  90. Closing Excel.. (6 replies)
  91. Userform Save with contents of TextBoxes (5 replies)
  92. Solved: Find "/" in string & debug.print ? (4 replies)
  93. copy sheets and files (2 replies)
  94. IF-Then-Else in VBA help needed (9 replies)
  95. Solved: Debugging Immediate Window Question (16 replies)
  96. Solved: Read string variable while ignoring case sensitiveity (15 replies)
  97. Seek help for value (25 replies)
  98. I need a menu bar in a userform (3 replies)
  99. Hide "track changes" option (6 replies)
  100. I don?t want the hide cell to be copying!! How to do it? (3 replies)
  101. [SOLVED:] Sum Across unknown Number of Worksheets (16 replies)
  102. MultiPage -how to change Page color? (2 replies)
  103. increase numbers by percent in a specific column (2 replies)
  104. Still a challenge (8 replies)
  105. forms-comboboxes & textboxes (4 replies)
  106. Workbooks.Open Does not Error if Workbook is not Present (6 replies)
  107. Solved: CHANGE FROM ALL UPPER CASE (10 replies)
  108. Solved: Writing to specific sheets on specific cells (3 replies)
  109. [SOLVED:] Getting Data From a Closed Workbook (16 replies)
  110. Countif multiple criteria (18 replies)
  111. [SOLVED:] ScreenUpdating Issue? (7 replies)
  112. Can I use if, sum, match and offset functions to do this?? (4 replies)
  113. Pasting some tables form Excel in Word (14 replies)
  114. [SOLVED:] Passing row height properties to array (3 replies)
  115. [SOLVED:] Temporarily Remove Conditional Formatting (13 replies)
  116. date of last backup (2 replies)
  117. Click on a cell, which one was it? (18 replies)
  118. Listbox columns from 2 sheets (9 replies)
  119. Solved: Print Multiple Worksheets Error (4 replies)
  120. Solved: 'Custom' data validation (10 replies)
  121. Import Text File to tab in sheet (2 replies)
  122. loading all add-ins at one stroke (4 replies)
  123. Using sound in excel 2007 (2 replies)
  124. Form not working, Cracking me up! (19 replies)
  125. Solved: Copy multiple Excel Sheets (12 replies)
  126. Edit Button images (6 replies)
  127. advanced graphs - plotting (0 replies)
  128. must activate sheet before paste? (3 replies)
  129. Copy and paste macro different worksheets (5 replies)
  130. [SLEEPER:] add a numerated worksheet (7 replies)
  131. Solved: tooltip (9 replies)
  132. HTTP: Yahoo Currency Conversion (11 replies)
  133. "Out of memory" (7 replies)
  134. Cell swapping (3 replies)
  135. [SOLVED:] WorksheetFunction.Vlookup Different Workbook Reference (20 replies)
  136. Listbox problem (8 replies)
  137. Problem with Excel 2003 XLA (Menu) Add-In (7 replies)
  138. Solved: Connect Combobox to Named Range (11 replies)
  139. Setting values for x-axis (3 replies)
  140. [SLEEPER:] flashing label (3 replies)
  141. column question (6 replies)
  142. Solved: Weird workbook on open (6 replies)
  143. Solved: Method to instruct how many times to do something? (11 replies)
  144. Solved: Getting Hyperlink from cell (6 replies)
  145. btn click userform add row (12 replies)
  146. Solved: Syntax question: Range(....) (6 replies)
  147. "FIXED OBJECT WILL MOVE" ERROR IN EXCEL (1 replies)
  148. Solved: Place Mult Select Listbox selections in specified cells (2 replies)
  149. Lock active cell based on value in above cell (9 replies)
  150. [SOLVED:] Sort list Box (2 replies)
  151. check if Access file is open and who the userID is (2 replies)
  152. Copying from one sheet to another (1 replies)
  153. Structure of the array that is returned by ClipboardFormats (5 replies)
  154. Solved: Extended 'ControlTiptext' for combobox items (4 replies)
  155. Method 'Range' of Object_ Worksheet' failed (10 replies)
  156. Forumla Problem (3 replies)
  157. [SOLVED:] End For Next routine on error (4 replies)
  158. Different ways of copying (8 replies)
  159. Listbox Multi column error (7 replies)
  160. Solved: Export data to .txt file (3 replies)
  161. Lock record creation in Excel (1 replies)
  162. hiding/unhiding a page on a userform (3 replies)
  163. Solved: Setting up a global dictionary (5 replies)
  164. Solved: Layout of Monthly Data needs to change (2 replies)
  165. Opening workbooks via shortcuts (2 replies)
  166. get letter of the active column (5 replies)
  167. Solved: Building add-in errors (6 replies)
  168. Solved: Rolling average (6 replies)
  169. Solved: sum visible rows only (6 replies)
  170. Updating graph automatically once the data changes (1 replies)
  171. What object is missin here (error 424) (9 replies)
  172. Difference between Sheet and Worksheet (2 replies)
  173. Solved: if value less then 5 show warning in worksheet change (5 replies)
  174. [SLEEPER:] Alternating row colors while sorting??? (3 replies)
  175. [SOLVED:] How to Force a Formula to Calculate (2 replies)
  176. Setting up a UserForm (12 replies)
  177. find last cell with formula (5 replies)
  178. Solved: Reorganizing Data (8 replies)
  179. Solved: addTextBox: how to find points from top/left of a specific cell? (2 replies)
  180. Solved: Schedule a macro (8 replies)
  181. Solved: Find last row, Array Worksheets via Function (14 replies)
  182. VBE opens by itself (6 replies)
  183. Solved: How to add image to chart series point (1 replies)
  184. Solved: Code for buttons (17 replies)
  185. Solved: update inventory when receiving and shipping (37 replies)
  186. Solved: Inserting Blank Row (3 replies)
  187. Solved: Multiselect listbox (7 replies)
  188. Solved: Replace Method using variables to find/replace (6 replies)
  189. object question (2 replies)
  190. Solved: Setting Array for Two Sheets- Almost there (8 replies)
  191. [SOLVED:] One source two targets, pick with dv (2 replies)
  192. Compare and Print with VBA (2 replies)
  193. Declaring a variable and assigning a value to it at once (6 replies)
  194. Consolidating multipule workbooks (4 replies)
  195. Solved: any way to clear textboxes on a userform? (4 replies)
  196. How to clear a userform after completion (4 replies)
  197. populating lists (3 replies)
  198. Public variable doesn't reset (5 replies)
  199. Collect Data via the Web: redux (20 replies)
  200. Solved: import multiple text files from listbox (6 replies)
  201. To a.Copy/b.Paste or to b.Value=a.Value (6 replies)
  202. Solved: Populate listbox (2 replies)
  203. Why can't i select things on non-active sheet? (8 replies)
  204. Solved: How to move a comment? (5 replies)
  205. Solved: If Instr line of code assistance needed (15 replies)
  206. inputbox variable validation (3 replies)
  207. repeating/looping through code (18 replies)
  208. Why does this Crash (10 replies)
  209. Solved: multi summation of columns (2 replies)
  210. [SOLVED:] Sorting on each sheet balks (14 replies)
  211. Copy data from excel to another application (1 replies)
  212. copy paste (7 replies)
  213. Help: Excel object size unit (4 replies)
  214. Controls on sheet OTF (3 replies)
  215. Solved: Highlight Text in TexBox on UserForm Open (2 replies)
  216. Number of work hours between two dates (1 replies)
  217. Solved: ? Better way to code (9 replies)
  218. Setting the limits in y-dimension for a graph (2 replies)
  219. Solved: DATA VALIDATION (2 replies)
  220. Editable Worksheet_Change result (4 replies)
  221. Collect Data via The Web (37 replies)
  222. [SOLVED:] adding new items to a dropdown (9 replies)
  223. Help Adding a constant text to a numeric cell (3 replies)
  224. Random Numbers via HTTP (6 replies)
  225. Solved: For Each Loop Through Sheet Collection Getting Wrong Results (6 replies)
  226. Help: Worksheet_change event disable "undo"? (4 replies)
  227. Solved: Sorting a Range, Header info? (2 replies)
  228. dropdown on a form (2 replies)
  229. formatting a label (3 replies)
  230. Creating a graph from a selection (3 replies)
  231. Solved: Non-Contiguous Reference Clear Contents (4 replies)
  232. Solved: Formula or vba required for most frequent text in an array. (6 replies)
  233. Centering Text in a Message Box (9 replies)
  234. Solved: Replace tilde character fails (9 replies)
  235. Presenting two datas in a graph (3 replies)
  236. Solved: Multidimensional Array (8 replies)
  237. Solved: DISPLAY "0" INSTEAD of #NUM! (7 replies)
  238. Solved: Clear white space off each column of each sheet of a workbook (4 replies)
  239. Weird runtime errors (1 replies)
  240. Code for a find sort and copy. (1 replies)
  241. Solved: How to add an Accelerator to a Caption? (2 replies)
  242. Solved: Putting String Array to cells directly (5 replies)
  243. MultiPage manipulation (6 replies)
  244. Named Range issue using file online (0 replies)
  245. Solved: Adding Sheets By Day Order (5 replies)
  246. Creating a Pivot Table using VBA (7 replies)
  247. VBA to grab data from other .XLS file (4 replies)
  248. How to show Form abobe selected cell? (1 replies)
  249. [SOLVED:] How do I force recalulation of custom function on Workbook_Open? (19 replies)
  250. Solved: How to tell if no value is selected in a listbox (10 replies)