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: Non-Contiguous Reference Clear Contents (4 replies)
  2. Solved: Formula or vba required for most frequent text in an array. (6 replies)
  3. Centering Text in a Message Box (9 replies)
  4. Solved: Replace tilde character fails (9 replies)
  5. Presenting two datas in a graph (3 replies)
  6. Solved: Multidimensional Array (8 replies)
  7. Solved: DISPLAY "0" INSTEAD of #NUM! (7 replies)
  8. Solved: Clear white space off each column of each sheet of a workbook (4 replies)
  9. Weird runtime errors (1 replies)
  10. Code for a find sort and copy. (1 replies)
  11. Solved: How to add an Accelerator to a Caption? (2 replies)
  12. Solved: Putting String Array to cells directly (5 replies)
  13. MultiPage manipulation (6 replies)
  14. Named Range issue using file online (0 replies)
  15. Solved: Adding Sheets By Day Order (5 replies)
  16. Creating a Pivot Table using VBA (7 replies)
  17. VBA to grab data from other .XLS file (4 replies)
  18. How to show Form abobe selected cell? (1 replies)
  19. [SOLVED:] How do I force recalulation of custom function on Workbook_Open? (19 replies)
  20. Solved: How to tell if no value is selected in a listbox (10 replies)
  21. [SLEEPER:] Save a copy solution (11 replies)
  22. users access (2 replies)
  23. Solved: DisplayFullScreen Question (6 replies)
  24. adding image to vba loaded userform sourced in sheet (5 replies)
  25. freeze pan (1 replies)
  26. Solved: Range object Id property (10 replies)
  27. Solved: Passing & Returning array to/from Property Get and Let (4 replies)
  28. Solved: For Each Loop through Worksheets Collection (3 replies)
  29. Solved: referencing different cells for calculations (7 replies)
  30. pivot tables and (15 replies)
  31. Calling UserForms: FormName.Show or Dim Object/Set New? (6 replies)
  32. Values and formats of only visible sheets and ranges copied to a new book (1 replies)
  33. Test if Current Dir is Read Only (12 replies)
  34. Excel and Notepad: how avoid additional inverted commas after copy and paste? (1 replies)
  35. Forms, textboxes & labels (3 replies)
  36. Solved: Simple Floating Toolbar - enhancement (2 replies)
  37. Help with deleteing row conataining #VALUE! (1 replies)
  38. Solved: Pivot Table Formatting (3 replies)
  39. Listbox Count (2 replies)
  40. Store Value of Last Row even after the procedure ends and Excel Closes? (14 replies)
  41. Getting to know what element of ComboBox has been selected (13 replies)
  42. Creating the user GUi forms the right way (3 replies)
  43. Solved: Understanding VBA minutes (3 replies)
  44. How to position a chart? (2 replies)
  45. Check if workbook exists (10 replies)
  46. Scrollbars for a Frame? (1 replies)
  47. [SLEEPER:] The "BEST" formula function in Excel: (3 replies)
  48. Linking Problem (0 replies)
  49. stop clock help needed!!! (7 replies)
  50. code to tell excel which folders to look into. (4 replies)
  51. import worksheets from changing workbooks name (2 replies)
  52. SECURING VBA CODE (29 replies)
  53. insert pagebreak if chart is not fully displayed (4 replies)
  54. Help: HOw many color is there in Excel (5 replies)
  55. problem with paste to active workbook (1 replies)
  56. Leave out blank items in combobox (5 replies)
  57. Find Range & Fill Down (9 replies)
  58. how to get: Index function keep value? (1 replies)
  59. Self filling combo boxes (1 replies)
  60. Cell contents become ### (5 replies)
  61. Stop User from Entering Formulas (4 replies)
  62. Solved: Expiration Date (3 replies)
  63. Import Txt and Parse (9 replies)
  64. Solved: Value Added Tax conversion problem (2 replies)
  65. To Compare 2 Sets Of Data And Change The Values Accordingly (5 replies)
  66. Sharing: What VBAx Is All About- Give It Up & Smile (3 replies)
  67. Macro help.. (11 replies)
  68. Can't get a result of formula (6 replies)
  69. Solved: Hyperlink on menu button (14 replies)
  70. Return named range with vba (2 replies)
  71. Solved: Procedure Too large to complete message. (21 replies)
  72. Option choices - how do I export results? (1 replies)
  73. Solved: VBA Combo Box Coding (3 replies)
  74. Solved: VBE column references (4 replies)
  75. excel formaula (1 replies)
  76. Paste Special Bitmap Excel VBA to Word (11 replies)
  77. Solved: Formula - Runtime 1004 Error (6 replies)
  78. Backgrounf formatting in Text Control (10 replies)
  79. Forcing .xls to open in 2007 (1 replies)
  80. Solved: Copy/paste from all worksheets, except sheet1 (5 replies)
  81. Coloring of the tab of a worksheet (4 replies)
  82. Forms/windows or whatever it's called (10 replies)
  83. search data from other worksheet (1 replies)
  84. Challenging macro (6 replies)
  85. [SOLVED:] Excel data organization nightmare (13 replies)
  86. Highlight cells on combobox selection (3 replies)
  87. Excel Hyperlink (1 replies)
  88. Sumif with multiple criteria?s from another worksheet (7 replies)
  89. Adaptive Database/Table (1 replies)
  90. Solved: Change Cell Colors By CF (4 replies)
  91. How to find the Last Used Row on Each Sheet (2 replies)
  92. UnprotectGreenCells (3 replies)
  93. Help: How to make list value change with the source (5 replies)
  94. Excel procedure to run Access Query using ADO (2 replies)
  95. Problem with .PasteSpecial (xlPasteValues) (6 replies)
  96. Solved: any way to delete & refresh contents in a dropdownbox? (25 replies)
  97. Formula - (4 replies)
  98. List box from columns? (9 replies)
  99. Problem with Code (Inserting New Row) (16 replies)
  100. Solved: Two input variables at vlookup (13 replies)
  101. Solved: input data to post in worksheet (8 replies)
  102. [SOLVED:] Speeding up the processes (2 replies)
  103. Invalid forward reference error (6 replies)
  104. Solved: Delete duplicated, tally to make report (2 replies)
  105. hide textbox (3 replies)
  106. countif forumla (3 replies)
  107. EXCEL COMPATIBILITY DRAMA (10 replies)
  108. Placement of a method (2 replies)
  109. Automation Help (3 replies)
  110. Do While question (2 replies)
  111. [SOLVED:] Copy, cut, paste: on a hidden sheet, possible? (21 replies)
  112. Unload userforms (2 replies)
  113. Solved: Help with case statement (5 replies)
  114. Solved: VBE and continue (2 replies)
  115. [SLEEPER:] Crashing on closing (8 replies)
  116. Solved: Select Case Construct Help (0 replies)
  117. Solved: naming a dynamic array with 7 columns, fluctuating rows (3 replies)
  118. Solved: Check if user has selected more than one cell (3 replies)
  119. Solved: find last row and add border to bottom > Resize selection? (3 replies)
  120. Copying data from one sheet to another (12 replies)
  121. Drop down lists problem (2 replies)
  122. Solved: Pivot Table Creation: Error 438 (2 replies)
  123. Select issue (9 replies)
  124. Solved: Display Animation While Random Numbers procedure (10 replies)
  125. Copy data fields macro (2 replies)
  126. Solved: UserForm Show Input error Message before proceeding (7 replies)
  127. Solved: Entering only values that are different to a list box (4 replies)
  128. VBA Objects (getting a combobox) (2 replies)
  129. Automatic open, save, close problem. (3 replies)
  130. Sleeper: Macro to unsort data back to its original format - exact copy (3 replies)
  131. Changing/retaining format of cells (8 replies)
  132. Running FTP commands from Excel Macro (2 replies)
  133. Solved: Clearing a multi column listbox (2 replies)
  134. array (14 replies)
  135. Solved: Join 2 formulas to work as 1 (17 replies)
  136. Solved: Loop: IF Condition is getting skipped (17 replies)
  137. How to print 1st page of several excell workbooks (2 replies)
  138. UserForm has Color but when print must only print in Black (4 replies)
  139. running slow (2 replies)
  140. [SLEEPER:] what type of sheet (15 replies)
  141. Investigating the selection (5 replies)
  142. [SOLVED:] What happened to this sheet (4 replies)
  143. Auto adjust (0 replies)
  144. Magnify /Zoom sellectecd cell (4 replies)
  145. Solved: Find last filled row IN PARAGRAPH (13 replies)
  146. ActiveCell not working the way i'd expect (2 replies)
  147. Naming a selected range (1 replies)
  148. Highlighting changed cells (11 replies)
  149. Automatic Opening, Saving Closing a Workbook... (0 replies)
  150. Delete data starting from specific row (4 replies)
  151. get min and max from array... (3 replies)
  152. Solved: Inserting Day of the week on a userform TextBox (14 replies)
  153. Solved: Your Opinion, Please (4 replies)
  154. Formula to find last significant value in string (3 replies)
  155. Relate 2 Tables in Excel Database (3 replies)
  156. Pivot Table with ADO (2 replies)
  157. [SOLVED:] Pivot Table Calculated Field (2 replies)
  158. Formatting issues (15 replies)
  159. Solved: auto copy and sort on change 2 columns (6 replies)
  160. Solved: How to maintain control as nested subs exit? (10 replies)
  161. Sending Info from Excel to Word (1 replies)
  162. Solved: Write a Small Procedure for me please? (7 replies)
  163. Copy and paste based on two criteria (3 replies)
  164. Solved: Generating numbers in excel (4 replies)
  165. finding merged cells (8 replies)
  166. Solved: Macros wont run even with security set to low (1 replies)
  167. [SOLVED:] formatting macro in VBA (7 replies)
  168. Solved: Run-Time Error 5 Invalid proc. call or argument (3 replies)
  169. [SOLVED:] Check Outlook version (1 replies)
  170. Solved: Subscript out of range on .Find (2 replies)
  171. [SOLVED:] Macro Record: What Module does it store it in (5 replies)
  172. Mkdir (9 replies)
  173. Solved: Apportioning Query (4 replies)
  174. Finding correct blank cell (10 replies)
  175. import data to update charts (5 replies)
  176. Solved: Sheet names (2 replies)
  177. [SOLVED:] List Box Selection To Text Box (12 replies)
  178. Any help to tweak the following code much appreciated (3 replies)
  179. Solved: Run macro in other sheets. (1 replies)
  180. Solved: Run Time Error 91 (9 replies)
  181. Performing an operation on several cells at once (8 replies)
  182. Nested Loops? (8 replies)
  183. Solved: Copy Certain Rows into Master Workbook (8 replies)
  184. how to parse through pivot filtered items (0 replies)
  185. Cutting up a table (3 replies)
  186. How to Prevent Insertion / Deletion of Worksheet (4 replies)
  187. Coordinates for my shape and placing the cursor (12 replies)
  188. Finding the sum value of permutations... (21 replies)
  189. Solved: Does sumproduct work with OR (25 replies)
  190. cleaning a cell (6 replies)
  191. Getting the value that WAS in the cell just deleted (6 replies)
  192. Solved: Update Userform after changes have been made on another useform (14 replies)
  193. Userform Validation Issues (25 replies)
  194. Help with CreateObject function (0 replies)
  195. [SOLVED:] Row count of non-Active worksheet (6 replies)
  196. Excel behave like a multi-user database? (11 replies)
  197. Solved: Relative range for advanced filter (5 replies)
  198. Solved: Read 'live' LOG file (23 replies)
  199. [SLEEPER:] List Controls on Worksheet (6 replies)
  200. Solved: WINAPI problem:project:control any sw from vba(with sendkey+mouseclicks) (5 replies)
  201. Solved: Deactivate workbook close button (15 replies)
  202. Reversing the process (11 replies)
  203. Solved: Filling a simple array (4 replies)
  204. loop that copy sheets in the same workbook (13 replies)
  205. Autonumbering (6 replies)
  206. importing data from other spreadheet (3 replies)
  207. VB How far backwards compatible? (1 replies)
  208. Format Specific Rows (2 replies)
  209. New VBA Code needed (1 replies)
  210. code for all possible cases (3 replies)
  211. Deleting row when a condition is met (7 replies)
  212. Excel Sheets Opens Itself Again After ADO Query ! (8 replies)
  213. Conditional autofilter based on form (27 replies)
  214. Amending VBA Script (3 replies)
  215. Solved: Extremely Slow Performance (5 replies)
  216. Solved: Row copy (6 replies)
  217. Solved: Delete specific word from rows, add specific words to others (9 replies)
  218. Solved: auto sort 2 columns after second column input (3 replies)
  219. Generating data using a loop (4 replies)
  220. Solved: save user selected sheets into new workbook (10 replies)
  221. how to run when print is cancelled (3 replies)
  222. [SOLVED:] Remove last two characters from string (2 replies)
  223. Solved: ayto formatting (3 replies)
  224. Replace #DIV/0! ERROR as blank cell (3 replies)
  225. Solved: Method of 'Range' failed error (3 replies)
  226. Convert Formula from R1C1 to A1 (5 replies)
  227. Delete Data if Less then Yesterday (6 replies)
  228. Auto Sort Entries (5 replies)
  229. Locking a module rather than the whole project (3 replies)
  230. Find Last Used Cell of Visible Cells (9 replies)
  231. Cell comparison (3 replies)
  232. Solved: help for selective highlight of rows (8 replies)
  233. [SOLVED:] Left loop (3 replies)
  234. master detail filtering (2 replies)
  235. Solved: macro to format cells (4 replies)
  236. List of all open workbooks (17 replies)
  237. chart with vba (17 replies)
  238. How: to check whether an element in chart is exist or not (8 replies)
  239. Solved: countif query & more... (5 replies)
  240. Solved: Percentage in VBA (7 replies)
  241. Solved: Copy Filtered list from Sheet 1 to Sheet 2 (7 replies)
  242. Unlocking the Pasword Protected File (4 replies)
  243. Solved: www.youtube.com (2 replies)
  244. VBA code for Vlookup in 2 wkbooks and import to master (1 replies)
  245. Help: Set Chart Source (2 replies)
  246. [SOLVED:] Automation Error - Object has diconnected from Clients (5 replies)
  247. Userforms (6 replies)
  248. Solved: What's wrong with this picture (5 replies)
  249. Copy/Paste macro (7 replies)
  250. [SOLVED:] List of Worksheet Tab Names (11 replies)