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: Reference another Excel workbook without Activating it (3 replies)
  2. Solved: Set Value of Merged And Centered Cells (2 replies)
  3. Solved: SUMPRODUCT across multiple sheets (2 replies)
  4. Inserting Carriage returns in Message Boxes (2 replies)
  5. Solved: Calculate "Current Month Average" (9 replies)
  6. Solved: Outlook Email Blast from Excel (1 replies)
  7. My Excel Crashes on Close (1 replies)
  8. Solved: How do you modules to calculate? (3 replies)
  9. Solved: Test if rows are hidden (2 replies)
  10. Critical Thinking Challenge (3 replies)
  11. Copy and paste count by last row (2 replies)
  12. Solved: Setting a Range as a Class Property (2 replies)
  13. How to convert dates in my Sub (5 replies)
  14. Using Excel to look at charts (4 replies)
  15. Solved: Conditional Format to a Linked Cell (4 replies)
  16. SaveAs with embedded Word document - OLEObjects (4 replies)
  17. Solved: Check my code please to find next blank row (2 replies)
  18. [SOLVED:] Ranking Data in List (2 replies)
  19. Solved: maximum function with #na value (4 replies)
  20. Solved: Sending Long to Clipboard or any other way to get it to Word from Excel? (2 replies)
  21. Solved: Importing space delimited text files (6 replies)
  22. Solved: Help for FY problem (5 replies)
  23. Using two Userforms. (4 replies)
  24. Solved: IF THEN COMMAND (8 replies)
  25. Copy Paste Values (7 replies)
  26. VB copy & paste help .......pleased (1 replies)
  27. How to detect a digital certificate (0 replies)
  28. Limit data field in PIVOT TABLE (2 replies)
  29. Solved: Match help (2 replies)
  30. Running Macro on Muliple Files (4 replies)
  31. How do I preserve the user's Clipboard while he's accessing my form? (3 replies)
  32. Can complete VBA code be exported to a different WKBK (3 replies)
  33. Selecting Column Until End of Another Array (7 replies)
  34. Solved: copy and paste macro - simple, right? (12 replies)
  35. convert to pdf to excel using vba (8 replies)
  36. How to call sub(which is personal.xls) in activeworksheet. (3 replies)
  37. VBA Find from EXCEL replace to WORDS HELP !!!! (4 replies)
  38. Multiple copies of Active Worksheet (2 replies)
  39. Solved: Read only password (1 replies)
  40. Excel save file (4 replies)
  41. Solved: How do I identify the type of graphic object that is currently selected? (4 replies)
  42. Solved: conditional population of cell (1 replies)
  43. Solved: Format cell when condition fulfilled (4 replies)
  44. Solved: Pulling Data from several sheets to one - Macro (1 replies)
  45. Form Close help (15 replies)
  46. need to automate date of last data entry (4 replies)
  47. Passing Parameter to Excel for SQL Report (5 replies)
  48. Search for repeated characters (8 replies)
  49. Solved: Send button value as arguement to macro (2 replies)
  50. Solved: Values to Text (2 replies)
  51. [SLEEPER:] VBA multiple ranges (8 replies)
  52. Merge & compare excel formula (4 replies)
  53. How can I create an Object and send by email? (3 replies)
  54. Solved: Search for text as part of a cell (2 replies)
  55. Solved: How to export an excel chart as a jpeg (4 replies)
  56. Solved: How to get AVERAGE of range into a cell (3 replies)
  57. Solved: Formatting cells with times (3 replies)
  58. Solved: hyperlink question (1 replies)
  59. Solved: If statement - Cell starts with Number (2 replies)
  60. Automatically Generate Reports from Excel Template (2 replies)
  61. Solved: Min of 4 Nos,returning >0 values (3 replies)
  62. Solved: countif with multiple criteria (3 replies)
  63. Solved: Data Export (6 replies)
  64. Solved: Excel to Outlook - late binding? (2 replies)
  65. Copy formula down the column (4 replies)
  66. Solved: Hi-Lite a cell based on value in another cell (4 replies)
  67. Import mutiple files from a folder to excel files (1 replies)
  68. Solved: Counting number of times a code has been executed (6 replies)
  69. Solved: Count cells with 3 requirements (3 replies)
  70. Amend VBA Code to include extra worksheet(s) (1 replies)
  71. [SOLVED:] Date Formatting help (4 replies)
  72. Solved: Saving File - Automated File Naming (16 replies)
  73. Add different password(S) to worksheet(s) from workbook (0 replies)
  74. Automatically insert rows at varied intervals (8 replies)
  75. Solved: Finding Min & Max values by week, month and year (2 replies)
  76. Sleeper: Disabling of cutcopypaste for a few cells in a worksheet (8 replies)
  77. Solved: Making a Range non-editable (6 replies)
  78. Last Updated Alert (1 replies)
  79. Solved: sum only certain columns (1 replies)
  80. File download without knowing the full url / redirect (2 replies)
  81. Changing the font in the fluent ribbon (1 replies)
  82. Call MS Access function in module via Excel (2 replies)
  83. Prevent Calculation Running While Saving (4 replies)
  84. [SOLVED:] Using vlookup if the lookup value is not in the first column (2 replies)
  85. Macro to search active cell value and look for it in word docs saved in a folder (0 replies)
  86. Solved: Adding worksheet to blank workbook (4 replies)
  87. Solved: Transpose column A to rows (4 replies)
  88. Solved: Scale graph absolutely (6 replies)
  89. Consolidate data (2 replies)
  90. Solved: Merge Excel file through validation (15 replies)
  91. Opening/getting data from different excel file (7 replies)
  92. Autofilter/Delete Duplicates/Find Changes (13 replies)
  93. Solved: Auto Load Form when Excel Launches (8 replies)
  94. Solved: Hundreds of links on Multiple Sheets (5 replies)
  95. Solved: Data Management In Excel - Theory/Design (3 replies)
  96. Solved: Any way to retrieve deleted file (2 replies)
  97. Cumulative % in Pivot (13 replies)
  98. Solved: Undo a Hyperlink (4 replies)
  99. Record varying length of text in cells (1 replies)
  100. [SOLVED:] Add New sheet every day (1 replies)
  101. [SOLVED:] Source and location function (2 replies)
  102. Solved: Calculating average based on some criterion (2 replies)
  103. payroll weekly time excel formula (5 replies)
  104. Solved: Adding A "ScreenTip" or Pop-Up Message When A User Hovers Their Mouse Over An Image?? (4 replies)
  105. Function with circular reference - VBA (12 replies)
  106. Solved: how to avoid LITTLE GREEN TRIANGLE error (3 replies)
  107. Solved: VBA Code . Max of 4 nos and min of 4 nos (7 replies)
  108. Solved: How to do arithmetic on addresses (2 replies)
  109. Solved: Namespace (2 replies)
  110. Size chart to Word cell (1 replies)
  111. creating a folder then giving a user ID modify permissions to it (0 replies)
  112. Solved: Find Multiple Entries - Change Cell Value (13 replies)
  113. Email from excel (5 replies)
  114. Solved: password lock a worksheet using a userform (1 replies)
  115. Solved: How to merge Empty cells in a selection (2 replies)
  116. Excel search files (7 replies)
  117. Solved: Autofill a column with text (8 replies)
  118. Solved: How to Link two sets of ranges (5 replies)
  119. Solved: Delete the Row based on criteria (2 replies)
  120. how run a sumif column name is true (3 replies)
  121. Solved: MS Query on open workbook (1 replies)
  122. Solved: min of 2 nos, if positive (4 replies)
  123. Help with autocomplete in textBoxes (6 replies)
  124. Solved: Deleting Rows (2 replies)
  125. How To Count The Number Of Records Selected By AutoFilter (7 replies)
  126. Solved: Delete Sheets in Add-in (1 replies)
  127. Solved: How to copy a dynamic range (4 replies)
  128. Solved: Error when I attempt to filter worksheet (6 replies)
  129. Solved: Application-defined or object-defined error - Len(c.Offset(0,-1).value) (3 replies)
  130. Font Color Cell (1 replies)
  131. Solved: Really basic stuff (6 replies)
  132. Solved: send active worksheet to outlook mail recipient as an attachment (1 replies)
  133. Solved: Show the next months Lists (2 replies)
  134. Solved: connect with access (4 replies)
  135. VBA Check Cells - Easy but help! (0 replies)
  136. Solved: UDF Inserting Unwanted Quotation Marks (5 replies)
  137. Solved: Filter unique values and count their frequency (7 replies)
  138. Autofill Rows with formula (17 replies)
  139. Insert tabs in to an excel worksheet (7 replies)
  140. Set Focus On Excel Instead Of Powerpoint (1 replies)
  141. Solved: paste to last empty row and beyond (2 replies)
  142. Speed up calculation (2 replies)
  143. Crash after add-in install (2 replies)
  144. Solved: Run Userform via macro toolbar button (2 replies)
  145. Solved: Finding last row of a column (7 replies)
  146. assign macro to tollbar buttons(excel2003) (4 replies)
  147. Issue with ActiveWorkbook.FollowHyperlink (2 replies)
  148. Solved: Selecting range of cells (4 replies)
  149. Solved: Excel insert rows based on value of previous row (2 replies)
  150. [SOLVED:] How to format columns on 'Workbook Open' (4 replies)
  151. Cant Shift date problem! (1 replies)
  152. Solved: Colouring ranges based on data being entered by User (7 replies)
  153. [SLEEPER:] Replacement of IF function (1 replies)
  154. Solved: VBA , min of 2 nox , >0 (2 replies)
  155. Solved: how to sum rows in columns with Sun (21 replies)
  156. Solved: Drop-down for each cell under a column (5 replies)
  157. Time Stamp VBA - Need help please! (1 replies)
  158. Sleeper: Identifying the optimal solution in an array (0 replies)
  159. Solved: Worksheet_Change and .PasteSpecial (7 replies)
  160. Solved: Select Date Range (11 replies)
  161. [SOLVED:] Referencing User Selected Workbooks (6 replies)
  162. macros language help ? (3 replies)
  163. Solved: VBA- Smallest non-negative number in a range (12 replies)
  164. Solved: Controlling Dialog Boxes (7 replies)
  165. Solved: Which column is the calling button (mostly) in? (6 replies)
  166. Matching variable formats (0 replies)
  167. [SOLVED:] How to detect when the mouse leaves a control on a userform (22 replies)
  168. Solved: Adapt code by Tom Ogilvy (0 replies)
  169. Color Backgrounds for Independant Cells (4 replies)
  170. Solved: Capturing Error Message (4 replies)
  171. Implements Keyword in VBA (2 replies)
  172. Implied Volatility (3 replies)
  173. Solved: Store values meeting certain criteria and paste them into other area (12 replies)
  174. Voltage Ramp (6 replies)
  175. Using Find to Search for a Date (1 replies)
  176. macro deleting important data in column F:EC (2 replies)
  177. How to protect Excel Program more seriously? (1 replies)
  178. Auto shut down of spreadsheet if inactive. (2 replies)
  179. [SOLVED:] Separate every 3 entries into 2 arrays? (or other solution) (9 replies)
  180. Solved: runtime error '1004' unable to set the formula property of the series class. (18 replies)
  181. run time erro 424 (3 replies)
  182. Solved: Compare two workbooks and count matches (0 replies)
  183. Populating sheets with data from another sheet (0 replies)
  184. Solved: formula not changing the row values accorrdingly (2 replies)
  185. Import data file (3 replies)
  186. Solved: Excel to Word: A few issues on the Excel part of things (2 replies)
  187. [SOLVED:] How to combine 6 different file(but same format) become one (13 replies)
  188. Solved: Copy Paste Cell Value To Word as Text Only (3 replies)
  189. Search as You Type ~~ Narrow down List (18 replies)
  190. Setting checkboxes with Boolean effect (7 replies)
  191. Disable Copy Paste (7 replies)
  192. Solved: search for multiple characters in a cell (2 replies)
  193. For/IF problem (5 replies)
  194. vb help (7 replies)
  195. check my code pls (5 replies)
  196. Need help on loop (4 replies)
  197. Userforms and Other Excel Application (5 replies)
  198. Robin Hammond's Progress Bar? (2 replies)
  199. Solved: Check if 2 Values Exist in 2 Columns (4 replies)
  200. Sleeper: Do copy macro (5 replies)
  201. Solved: Ask for values and save as (6 replies)
  202. Ask for values and delete row (4 replies)
  203. Solved: Confused about Workbooks object (6 replies)
  204. Solved: (12 replies)
  205. Solved: dynamic named ranges (2 replies)
  206. Copy non blank rows from each workbook in a folder to current workbook under eachotha (1 replies)
  207. CheckIn, CheckOut API's - general question (3 replies)
  208. how to run a sumif after formula (5 replies)
  209. [SOLVED:] Moving rows up and down a table with VBA (9 replies)
  210. Worksheet Formulas and VBA (2 replies)
  211. Solved: Scheduling suggestions (13 replies)
  212. Solved: vba copy function (6 replies)
  213. Solved: Multipage and combo box (3 replies)
  214. Solved: Ignore error without converting to number (8 replies)
  215. Copy 2 sheets to Network and rename (5 replies)
  216. Solved: Clean up of Custom Menu items (2 replies)
  217. Solved: OnClick event (2 replies)
  218. Solved: Merge Data between worksheet (3 replies)
  219. Solved: Can text be copied out of a cell to another cell? (6 replies)
  220. [SOLVED:] Help with Case statement (16 replies)
  221. Solved: Enter today's date based on another cell (4 replies)
  222. Lock cell after entry (10 replies)
  223. [SLEEPER:] sum to the last column with data (11 replies)
  224. Solved: Need help easy formula (5 replies)
  225. Solved: Looping through a shapes listbox (2 replies)
  226. Unmerge cells & copy line from above (13 replies)
  227. Set default save path (6 replies)
  228. Solved: Find Multiple Entries Then Delete Row (3 replies)
  229. Solved: duplicate file & strip code from workbook (4 replies)
  230. Solved: Save and encrypt sheets (1 replies)
  231. Solved: sort will not sort - why? (7 replies)
  232. disable print screen (5 replies)
  233. [SOLVED:] Compile error (4 replies)
  234. amend formula (2 replies)
  235. [SOLVED:] Sort Multidimensional Array (13 replies)
  236. Solved: need to add a macro on save (2 replies)
  237. Read and Write Binary Registry Keys (3 replies)
  238. Solved: Using arrow keys to navigate through userform fields (9 replies)
  239. Solved: Do Loop until rowHeight is between two numbers (2 replies)
  240. Solved: Copy Paste from workbook to workbook (4 replies)
  241. Solved: add differenet worksheet names to current macro (3 replies)
  242. Solved: Workbook_Before Close problem (2 replies)
  243. OWC Spreadsheet Scrolling (1 replies)
  244. chart update problem help!! (31 replies)
  245. How do I "install" custom functions (7 replies)
  246. automatically scale pivot chart from highest to smallest (0 replies)
  247. Listboxes - automatically unselecting themselves?! (4 replies)
  248. Solved: Writing data to a table in word from excel vba (2 replies)
  249. Help With MsgBox if duplicate range (10 replies)
  250. Function for of sum of square of mean deviation (7 replies)