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. code without select (27 replies)
  2. Solved: Hide Row based on particular word (2 replies)
  3. create a list of numbers in a single cell (5 replies)
  4. how to set a value to an external cell ? (9 replies)
  5. If statement help (9 replies)
  6. adding time 15min in a textbox (3 replies)
  7. script to pull email information onto excel (11 replies)
  8. Solved: Hyperlinks to Hidden Worksheets (2 replies)
  9. Solved: UF textbox 8th character (2 replies)
  10. Solved: If 8th character ...then (4 replies)
  11. Sleeper: Amend HTML file (2 replies)
  12. Solved: Data Validation Negitive (1 replies)
  13. Solved: Date and Time Difference 2 (4 replies)
  14. VBA CODE OLAP Pivot Table Excel 2007 (3 replies)
  15. Solved: ADO handling (3 replies)
  16. Solved: Number Based on Date (3 replies)
  17. Warning message open file (1 replies)
  18. Solved: The Trouble with For-Loops (17 replies)
  19. What am i Doing wrong (12 replies)
  20. Progress Bar (4 replies)
  21. Solved: Problem With .pagesetup.printarea (6 replies)
  22. Solved: Case statement (5 replies)
  23. Quick Question ABout Setting a Range (10 replies)
  24. Solved: VBA Graph - Tweaks Needed to Amend Font and Placement?!! HELP! (4 replies)
  25. Solved: Userform Pop-up when opening excel (8 replies)
  26. Code update with the help of form (8 replies)
  27. Need help for "Format" function (3 replies)
  28. How to populate missing digits in a date cell or convert US to UK date format (3 replies)
  29. Solved: I am the Worst:: Something is Terribly Wrong w/ My Code (5 replies)
  30. Solved: copy late items to new sheet (2 replies)
  31. Solved: unprotect sections of word document with excel (1 replies)
  32. Solved: date & time difference (5 replies)
  33. [SOLVED:] Type MisMatch!! (5 replies)
  34. IE login and logout from Excel (0 replies)
  35. Solved: What am I doing Wrong in this simple Code? (2 replies)
  36. Solved: Is there a Function in Excel to Determine the Row Length? (2 replies)
  37. How to get subtotal ignore subtotal which is netted in If() (2 replies)
  38. [SLEEPER:] Opening email with selected names and attachments (18 replies)
  39. Can Someone help with this For Loop? (6 replies)
  40. Solved: Close Excel Command Button (2 replies)
  41. Message box with options (2 replies)
  42. Sleeper: Problem with range selection (2 replies)
  43. Solved: Checking to see if a cell contains a Number or Letter (4 replies)
  44. Shapes and values the sequel (0 replies)
  45. Type Mismatch error (2 replies)
  46. Solved: Lookup Value, Copy and Paste Row Values?! (11 replies)
  47. Arraylist or something else help (3 replies)
  48. Solved: Activate vba in another workbook (8 replies)
  49. Solved: Lottery Checker (2 replies)
  50. Solved: How to Recognize this string properly? (3 replies)
  51. VBA sorting method (12 replies)
  52. Iterating through a list of cells (5 replies)
  53. [SLEEPER:] Capture user data (1 replies)
  54. Help with search form (3 replies)
  55. Arrange the values as per pre-defined orders (6 replies)
  56. Solved: Hyperlinks warning (2 replies)
  57. VBA to download data from website (0 replies)
  58. Macro from Number to Letter (6 replies)
  59. Problem with Contour Graphs (0 replies)
  60. Solved: VBA file names (and more) from folder on worksheet (6 replies)
  61. Search list, find value and return binary value. (10 replies)
  62. Syntax error (1 replies)
  63. Script to show up time zone in excel (3 replies)
  64. Auto increment number & Date Stamp (0 replies)
  65. Solved: Shapes & Values (6 replies)
  66. Workbook size (2 replies)
  67. Cell References (7 replies)
  68. Solved: How to rename a worksheet if name already exists (4 replies)
  69. Solved: Hyperlink activation of Script/Macro (11 replies)
  70. Solved: Format Date + 3 months (18 replies)
  71. Solved: Disable subs depending on which button is pressed (7 replies)
  72. auto serial number (32 replies)
  73. Solved: Clear shapes BUT save buttons (17 replies)
  74. Solved: Goto previous cell (3 replies)
  75. Solved: Partial file name (2 replies)
  76. Solved: Why doesn't this work? (3 replies)
  77. Solved: Summing of Totals (2 replies)
  78. Solved: Sub to Go Back to Stored Range (2 replies)
  79. Solved: Comparing Cells (2 replies)
  80. Call Sub when cell is double clicked (9 replies)
  81. [SOLVED:] Cannot select multiple cells at a time (2 replies)
  82. Solved: password policy when opening an excel sheet (4 replies)
  83. Solved: Increase value of a Cell by 1 (3 replies)
  84. Solved: Variables in message box (4 replies)
  85. Solved: Clear corresponding cells when changing one cell in a row (4 replies)
  86. list names of all saved files (2 replies)
  87. Solved: Incorrect Date Brings Up MsgBox (2 replies)
  88. Solved: open Excel filename with only certain characters (2 replies)
  89. VBA and XML::Conversion of Sorts (2 replies)
  90. Check if Column Exist & it in sequance (0 replies)
  91. Using embedded pics (6 replies)
  92. Date variables (1 replies)
  93. insert image (7 replies)
  94. Macro to copy formulas across a worksheet (2 replies)
  95. Enum replacement for saving double datatype (6 replies)
  96. Solved: extract values in a range (5 replies)
  97. access invoice to excel combo box vba urgently need help (1 replies)
  98. Solved: input box loop (6 replies)
  99. Advanced Find & Replace (2 replies)
  100. Solved: Finding complicated average (5 replies)
  101. Solved: Automatic addition of comments to entire column (3 replies)
  102. Solved: Add to comment? (4 replies)
  103. Write to Output File w/out Overwriting Everytime? (7 replies)
  104. Solved: Find Empty Column Range (3 replies)
  105. Recording web application using a macro? (1 replies)
  106. Solved: RANK (??) (2 replies)
  107. Solved: Find value and count occurances of text (4 replies)
  108. Solved: use GetOpenFilename with only few files displayed (10 replies)
  109. Solved: Script to add values in new sheet without blank rows (8 replies)
  110. VBA Compare Excel Files Macro (8 replies)
  111. VBA to disable close (14 replies)
  112. ActiveSheet.Paste Error (2 replies)
  113. convert Exif photo data to excel (2 replies)
  114. Solved: Auto-repeating input error (1 replies)
  115. Incremental Change in Values of Data Table (3 replies)
  116. Solved: Change caption of a button on spreadsheet without selecting it (4 replies)
  117. Solved: Prompt comment? (1 replies)
  118. Chart source data depends on the sheets choosen on the Combo box (1 replies)
  119. Displaying text with freeze panes (1 replies)
  120. Clearing and resetting CTRL+END (1 replies)
  121. Solved: When replacing a sheet, how to fix refs? (3 replies)
  122. Print PDF file (4 replies)
  123. Solved: Reduce size of current region (2 replies)
  124. Solved: Add opened file into a summary workbook (2 replies)
  125. Solved: Invintory Project. (7 replies)
  126. Solved: Low inventory alert (10 replies)
  127. Solved: Custom Prompt box w/ multiple buttons (5 replies)
  128. Truncating cell data to fit in cell (2 replies)
  129. Vlookup the price in latest date (4 replies)
  130. Solved: add to existing value by matching (11 replies)
  131. [SOLVED:] Why do create a temporary variable and then set the value to a function? (1 replies)
  132. Solved: Excel equivalent to MS Word's DOCVARIABLE? (2 replies)
  133. Solved: VBA lookup to insert value into cell. (7 replies)
  134. Solved: Loop through user specified folder (3 replies)
  135. Solved: Find is not matching expected values (3 replies)
  136. Chart Colouring Macros (4 replies)
  137. Solved: Make chart where source data range is variable (2 replies)
  138. filter - hide active cell content (11 replies)
  139. Solved: Create a marco that will autofill a formula but the range is variable (2 replies)
  140. Solved: clear cells without form appearing (8 replies)
  141. Dynamic graph (0 replies)
  142. Buttons to Start and Stop Macro (2 replies)
  143. Solved: VBA code to periodically copy data (3 replies)
  144. Vlookup (6 replies)
  145. Selecting more than cell VBA (7 replies)
  146. Solved: Explanation of Advanced Filter (5 replies)
  147. Using FieldInfo with variable array content (6 replies)
  148. Solved: Limit input to textbox (9 replies)
  149. Solved: MS Excel: Password Problem (11 replies)
  150. Solved: How to open all files in folder using input box (7 replies)
  151. Sorting then send (6 replies)
  152. Solved: Assign Macro to Runtime-Generated Textbox Event (4 replies)
  153. Strange combobox problem (2 replies)
  154. Query-Style Custom Function needs speed boost! (4 replies)
  155. Macros help (1 replies)
  156. Solved: Deleting data within a named range (xl '97) (7 replies)
  157. Solved: Copy selected cells in all worksheets and paste into another worksheet (6 replies)
  158. Solved: Excel VBA Open / Save As (14 replies)
  159. Solved: IF Formula problems (3 replies)
  160. Solved: sumproduct formula error (14 replies)
  161. Excel Vba for Macros... (2 replies)
  162. Code to Filter, Copy, Paste and Save Data (3 replies)
  163. Loop fifty files into one file (3 replies)
  164. Solved: User Form syntax (2 replies)
  165. VBA to open Excel & Enable Macro (4 replies)
  166. Solved: Deleteing unused word bookmarks (3 replies)
  167. Sorting Collections (7 replies)
  168. Solved: Copy string to clipboard in VBA (3 replies)
  169. Pivot Chart and Table Problem (2 replies)
  170. Excel Formula Help (1 replies)
  171. Solved: Conditional Formatting a worksheet based on value in a cell in another worksheet (3 replies)
  172. Count of rows excluding a set of values in the another sheet (12 replies)
  173. Change Array Arguments to read horizontal instead of vertical (5 replies)
  174. Copying data from DB in a Sheet (1 replies)
  175. How to exclude hidden pivot field items in count (3 replies)
  176. Excel VBA recognizing the variable as Date wrong (3 replies)
  177. Delete the duplicate value/cell in selected range (5 replies)
  178. Need Help developing an Algorithm to Decode MathML (XML) (6 replies)
  179. Solved: how to reference previous cell value (2 replies)
  180. Solved: Webbrowser page depending on listbox value (2 replies)
  181. Continual Import of Excel data into Sharepoint list (1 replies)
  182. Solved: Sorting a column alphabetically, however a blank row between names must be retained. (8 replies)
  183. Load Excel Userform from Powerpoint Button (6 replies)
  184. AutoCorrelation and Partial AutoCorrelation series Generation (5 replies)
  185. Solved: Need Help with the Logic of my Program (9 replies)
  186. Inventory control (11 replies)
  187. Solved: Iserror in VBA setup (4 replies)
  188. Macro to copy paste data (3 replies)
  189. Nested Collections (8 replies)
  190. Solved: Adding 2 worksheets to an existing workbook (11 replies)
  191. Solved: Macro need to direct a cell value to the corresponding named worksheet. (2 replies)
  192. Hyperlink Problem when print Excel to PDF (2 replies)
  193. Keyboard shortcuts (5 replies)
  194. Solved: VBA - form/workbook problem (3 replies)
  195. VBA - Need Help for a SQL Query (1 replies)
  196. Solved: MsgBox if birthdate is <1 year ago? (25 replies)
  197. Solved: Looping: Copy two worksheets to new workbook (9 replies)
  198. Code to insert info needs tweaking (10 replies)
  199. Macro letting the user decide where to save the file (and decide the filename) (1 replies)
  200. Solved: Save document with new filename, close it and re-open original file (2 replies)
  201. 2007 title bar (2 replies)
  202. Changing Cell Value Code (3 replies)
  203. Solved: Save a document with today's date in a macro (9 replies)
  204. Reformat Data with Macro (4 replies)
  205. Sleeper: Excel UDF Error - Connecting to SPSS (1 replies)
  206. Solved: VBA to Save a workbook with an incrementing Version Number (9 replies)
  207. Solved: Update a Word TOC from Excel VBA (1 replies)
  208. Solved: Hide rows (13 replies)
  209. Help Opening Embedded Word File (9 replies)
  210. Solved: Message while running macros (5 replies)
  211. long data type in ADO recordset (1 replies)
  212. A really annoying Loop, Help please! (8 replies)
  213. Solved: How to validate data in a userform prior to the data being transferred to a worksheet (2 replies)
  214. Solved: Excel/Access - SQL statement - WHERE/AND (Office '97) (3 replies)
  215. How to Get the Name of Executing Macro (1 replies)
  216. Solved: find same value in two different lists and copy rows in new sheet (7 replies)
  217. Solved: find same value in two different lists and copy cells in new sheet (18 replies)
  218. Solved: 50% Excel, 50%Outlook, 100% fail (17 replies)
  219. Solved: Dependent in Invoicing (13 replies)
  220. Solved: Addin Command Bar Not Loading (1 replies)
  221. Solved: sort dates (5 replies)
  222. Updating duplicate worksheet (23 replies)
  223. Userform Problems (7 replies)
  224. Solved: Code not summing properly (5 replies)
  225. dynamically merging cells in different rows based on the position on the worksheet (9 replies)
  226. Solved: UserForm, Passing Variable (Excel '97) (2 replies)
  227. Solved: IF Statement Help (2 replies)
  228. Solved: Search column a for value select and past rows to next sheet (2 replies)
  229. Solved: Random Numbers Repeating (2 replies)
  230. Force an opening workbook to open in an alternate instance of Excel (0 replies)
  231. Enable copy and paste (2 replies)
  232. export/update from excel workbook to access database file (1 replies)
  233. Solved: Join an array and join a Range (3 replies)
  234. Auto calculate active worksheet (4 replies)
  235. Excel Data to Word Labels (1 replies)
  236. Insert-Delete Rows with Formulas Error (0 replies)
  237. Solved: AutoFill Active Cell (13 replies)
  238. [SOLVED:] VBA Hiding Unused Cells (11 replies)
  239. Solved: VBA to Delete rows using IsError (8 replies)
  240. VBA Advanced Filter (4 replies)
  241. To open Another Excel in a different Window using code (2 replies)
  242. Solved: Excel formula needed for if or countif or both (3 replies)
  243. assign values next to the last used cell (7 replies)
  244. Creating a userform to perform a search function (5 replies)
  245. Cells Index (6 replies)
  246. Need VBA help - coming up with runtime error when remote users run a macro (1 replies)
  247. Solved: Recordset Seek method issues (0 replies)
  248. Solved: Select case statement problem (8 replies)
  249. Solved: Userform & enabling textboxes (8 replies)
  250. Average with vba (7 replies)