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. Message box to appear once commandbutton is pressed? (4 replies)
  2. Password to open file via macro? (1 replies)
  3. Listbox items getting transferred in reverse order (3 replies)
  4. Sports league VBA program (6 replies)
  5. Solved: move to textbox in other sheet if is "TAB" pressed (12 replies)
  6. Need VBA help with populating missing data?? (3 replies)
  7. Solved: Modify Hyperlink Code (14 replies)
  8. Super Quick ComboBox Question (3 replies)
  9. Solved: Countif with a Range Name as the Criteria (5 replies)
  10. print preview , value of ending line on page (6 replies)
  11. Copying Data from different workbooks (1 replies)
  12. Solved: Flashing commandbutton? (6 replies)
  13. Multiple Excel ranges to multiple Word tables. (9 replies)
  14. Solved: run access macro from excel (2 replies)
  15. Same code - one set works but other does not... (5 replies)
  16. How to open a secured directory (0 replies)
  17. Solved: Copy the table in Word document to NEW Excel file (7 replies)
  18. Solved: Count Formula Based Currency Criteria (3 replies)
  19. UDF for Three Parameter hlookup (6 replies)
  20. How to tell user to get updated copy? (18 replies)
  21. Solved: Inserting an undetermined number of rows? (2 replies)
  22. DSO and File Properties (0 replies)
  23. Solved: Conditional Format VBA not using Range Name Value (2 replies)
  24. Special Calendar to fill textboxes (1 replies)
  25. Need help about listbox column count property (1 replies)
  26. Userform triggers Excel Crash (6 replies)
  27. I just want the Date, not the time (CDate(Now)) (1 replies)
  28. Date formula required (4 replies)
  29. How to know value of margin of the last row on page (1 replies)
  30. Solved: How To make Macro Interactive (4 replies)
  31. Solved: Distribution Graphs (6 replies)
  32. alerts out of a spreadsheet based on dates (3 replies)
  33. make textboxes visible at runtime? (4 replies)
  34. What Message Is Being Written? (2 replies)
  35. Help in Vlookup function error (2 replies)
  36. Event for Ctrl-G (3 replies)
  37. Linking to formula rather than paste special (4 replies)
  38. Solved: download files from internet thruugh VBA (2 replies)
  39. Make VBA Code Shorter (6 replies)
  40. Merge cells based on a cell value (4 replies)
  41. Solved: Delete Text to Left of First Number (9 replies)
  42. Problem with error type mismatch (5 replies)
  43. Solved: Unhide and activate sheet based on system date (9 replies)
  44. Solved: How do I sort a dynamic named range? (3 replies)
  45. Solved: How to sum a range of cell values based on common data field (3 replies)
  46. Applying Format To ALL sheets in Workbook (1 replies)
  47. Saving a Worksheet (1 replies)
  48. Solved: Changing Values Between Text Boxes (2 replies)
  49. delete blank rows (1 replies)
  50. Solved: Select copy & paste (2 replies)
  51. Different sound file question - simple ?? (1 replies)
  52. Loading malformed xml into MSXML2.DOMDocument (8 replies)
  53. How to Add a File to References List with VBA (7 replies)
  54. Solved: Select variable range of rows and then delete ?? (14 replies)
  55. Search value as the part of the Sheetname (24 replies)
  56. Solved: Range Error during loop (2 replies)
  57. Solved: Remove a shapes (3 replies)
  58. Using Variables in VBA formulas (1 replies)
  59. Solved: Join Sheets Cells By Common Field (2 replies)
  60. Solved: Delete emty rows. (6 replies)
  61. Rename controls in VBE (3 replies)
  62. Data Validation issues (5 replies)
  63. can't call subs automatically (2 replies)
  64. Stringlists or String arrays (7 replies)
  65. [SOLVED:] What Causes “Personal.xls” to be Opened? (1 replies)
  66. Chart Help::Stacked Column (4 replies)
  67. Excel form to database help (2 replies)
  68. Solved: Insert comment (2 replies)
  69. Solved: total by company (4 replies)
  70. Progress bar Running on top (1 replies)
  71. How to get to the single dictionary entry without knowing its key ro value? (7 replies)
  72. Solved: modify code to run on several sheets in a workbook (10 replies)
  73. use excel database to populate 2 different word doc (1 replies)
  74. Solved: Combobox linked to calender (2 replies)
  75. Solved: Date and time (3 replies)
  76. Solved: VBA to count characters in cell - getting error (2 replies)
  77. Solved: TextBox Character limit (14 replies)
  78. Solved: set row color based on value of a cell (5 replies)
  79. Solved: Closing Excel by clicking the Red X (0 replies)
  80. vlookup closest value (5 replies)
  81. Solved: Quick Concatenate Question (formatting) (3 replies)
  82. Compare VBA Code in Modules (1 replies)
  83. XL2000 Add-In Question: (4 replies)
  84. Solved: textbox disappears (3 replies)
  85. Error 461 (1 replies)
  86. problem unprotect vbproject (0 replies)
  87. Runtime Error 5: Invalid procedure call or argument (0 replies)
  88. Image Popup when mouse arrow is on Button (3 replies)
  89. Transform data to Columns (15 replies)
  90. Can’t Find Project on Library . . . (7 replies)
  91. 2007 Pivot Table Conditional Formatting macro problem (5 replies)
  92. Error Msg: MS Office is waiting for another application to complete an ole action (0 replies)
  93. modify nextrow code (15 replies)
  94. Solved: make visible based on value (2 replies)
  95. Conditional formatting (2 replies)
  96. Write to a text file (1 replies)
  97. Solved: Code Amend to OK Msg Box Before Close (1 replies)
  98. run code from personal.xls (0 replies)
  99. Solved: Text To Columns - passing FieldInfo value as a string (2 replies)
  100. Date Format (6 replies)
  101. [SOLVED:] Open access and run macro in access (2 replies)
  102. Formula to Prevent a higher % to be entered...Help (3 replies)
  103. Solved: Auto fit columns in whole workbook (1 replies)
  104. Count Files in Several Folders (7 replies)
  105. Inserting a Range on a Chart as TextBox ? (3 replies)
  106. Help uploading excel cells into website (2 replies)
  107. Summing Similar Conditons (1 replies)
  108. Drop down List (9 replies)
  109. Solved: Combine Data into one Cell (5 replies)
  110. Calculating An Average (1 replies)
  111. Solved: count all equal combinations (3 replies)
  112. Solved: BeforeDoubleClick Issue? (5 replies)
  113. Solved: I'm having trouble selecting a range (3 replies)
  114. string manipulation problem (3 replies)
  115. [SOLVED:] Return default save path for an excel add-in (11 replies)
  116. "INDIRECT" worksheet fuction problem (4 replies)
  117. Limit amount of rows formatted (1 replies)
  118. Open Template with file picker (2 replies)
  119. update procedure in excel file from personal.xls (2 replies)
  120. Speed up loop? (2 replies)
  121. [SOLVED:] Is this something that I can do in VBA? (2 replies)
  122. Dynamic pivot charts using pivot table (0 replies)
  123. Survey in Excel using Visual Basic Need to edit! (21 replies)
  124. Fairly simple problem (8 replies)
  125. Format Cell For Time (3 replies)
  126. [SOLVED:] Order an array from the smallest number to the biggest (22 replies)
  127. First date in week from <WeekNo, Year> (6 replies)
  128. Solved: search next value with textbox in other sheet (33 replies)
  129. [SOLVED:] Trying to get Code to run in excel 2007 (7 replies)
  130. Solved: Regression Analysis macro (4 replies)
  131. Excel chart in PowerPoint (3 replies)
  132. Extra Information alongside Pivot Table (0 replies)
  133. TAB Name (16 replies)
  134. Solved: search next value with textbox (6 replies)
  135. Excel to PDF (2 replies)
  136. need some code to move items into new sheets (7 replies)
  137. Problem with ComboBoxes (control toolbox ones) (4 replies)
  138. [HELP] Merging all the details of the work book in one sheet. (7 replies)
  139. How to Calculate Tax from Net Amount--Help (5 replies)
  140. [SOLVED:] Input more than 15 digits numbers in a cell in a worksheet (2 replies)
  141. [SLEEPER:] Automatically populate userform from row selection in excel (3 replies)
  142. display range value in message box (5 replies)
  143. Solved: Bar Chart doubt (2 replies)
  144. Highlight cells that did not match (1 replies)
  145. Highlight Row Based on Cell Value (1 replies)
  146. Solved: all caps combo box (3 replies)
  147. Solved: Sending Copy of WorkSheet from 1 Book to Another (5 replies)
  148. Faster method for VLOOKUP (14 replies)
  149. Query Table in Excel (3 replies)
  150. Excel to SQL Server (3 replies)
  151. Solved: Check date &amp; compare to another date (12 replies)
  152. Pulling folder content file info into worksheet (7 replies)
  153. Code to copy and insert rows (3 replies)
  154. Solved: Working with Shapes (2 replies)
  155. Vanishing controls... (3 replies)
  156. Solved: .formula not working with Excel (3 replies)
  157. Solved: Deleting / Reordering columns in a Worksheet (2 replies)
  158. SeriesCollection by name (1 replies)
  159. Solved: Extract Text to columns (9 replies)
  160. Solved: run DOS command without waiting ? (2 replies)
  161. time sum (2 replies)
  162. conditional formatting based on date? (27 replies)
  163. What Does This Mean?? (2 replies)
  164. Solved: VBA userform (3 replies)
  165. Solved: (6 replies)
  166. Column values based on entries on another sheet (1 replies)
  167. Hidden Module? (2 replies)
  168. Insert Chart Help Needed (4 replies)
  169. Solved: accidently save over file (2 replies)
  170. Group and filter the data (3 replies)
  171. Validating Textbox's on Worksheet using Class Modules` (5 replies)
  172. Deleting words in a string (2 replies)
  173. Removing pictures (3 replies)
  174. Will deleting defined name delete data?? (3 replies)
  175. userform apply code after userform end (4 replies)
  176. [SOLVED:] Shifting rows to a worksheet depending on a cell value (5 replies)
  177. Solved: script to copy multiple cell values into one cell (19 replies)
  178. copy & paste (1 replies)
  179. How to access the methods of .xla from VBA? (7 replies)
  180. Trendline data/info (4 replies)
  181. detect more than one border color along single edge of range (11 replies)
  182. Solved: Date formula in vba (4 replies)
  183. Solved: Filtering records older than one year ago (6 replies)
  184. Solved: vlookup with multiple criteria (4 replies)
  185. Solved: Save as &amp; file name\path problem (6 replies)
  186. [SOLVED:] Solved: Selectively copy ActiveCell onChange (4 replies)
  187. Import Address Book from Outlook (4 replies)
  188. Checking Tab Names (1 replies)
  189. Error Copying Data (8 replies)
  190. Solved: Text-to-column but right to left (4 replies)
  191. Error: Excel cannot complete task with available resources??? (4 replies)
  192. populating combobox at runtime (4 replies)
  193. Find the next date in column (17 replies)
  194. Finding a Value (9 replies)
  195. Working with Charts (4 replies)
  196. Solved: Need help with toggle button (2 replies)
  197. To random_noise (3 replies)
  198. retentive variable (5 replies)
  199. Frequency function and open intervals (22 replies)
  200. Find all xls files except one subfolder (3 replies)
  201. Excel generate a task in Outlook (1 replies)
  202. Solved: positioning a Chart (2 replies)
  203. Solved: repopulate formulas (4 replies)
  204. Change cell color to color of adjacent cell (3 replies)
  205. VBA (4 replies)
  206. Excel to PDF (3 replies)
  207. VBA (3 replies)
  208. Copying from one file to another (6 replies)
  209. Autofilter On One Column? (6 replies)
  210. Why is this ElseIF not the same as this Select Case? (5 replies)
  211. Solved: Excel 2007: Bypass Workbook_Open Code (2 replies)
  212. Removing HTMLCheckboxes (4 replies)
  213. Auto Scale Chart Font in Excel 2007 (1 replies)
  214. What is PERSONAL.xlsb?? (2 replies)
  215. Pull out the values which are not Unique (9 replies)
  216. Solved: Set column width in pixels (3 replies)
  217. get last cell value and add 1 for next number (7 replies)
  218. automatic spell check on open fields in protected document? (0 replies)
  219. Best Way to Loop Through Range? (3 replies)
  220. find next blank row and input information from form (3 replies)
  221. UDF causes other macro to fail w/ err 1004 (9 replies)
  222. Get CSV from a PHP script on a server (mysql 5) (0 replies)
  223. excel template error handling (1 replies)
  224. Solved: Adding a Treeview control to a Userform (2 replies)
  225. Solved: Excel Userform textbox's (6 replies)
  226. VBA cannot activate cell after first loop (4 replies)
  227. Solved: Set Print Area - Last Row/Cell Used (2 replies)
  228. VBA help - code to loop through a certain folder structure (10 replies)
  229. Solved: How to capture position info of a cell (4 replies)
  230. Need a macro to copy data to main file (4 replies)
  231. Solved: separate rows with blank rows (8 replies)
  232. Random Sampler (0 replies)
  233. ftp upload (0 replies)
  234. Solved: Lect combobox item, display wksheet name in listbox (2 replies)
  235. Problem using "range.find" in VBA (10 replies)
  236. Sender in VBA? (7 replies)
  237. filter by dates (26 replies)
  238. Or Function (1 replies)
  239. Solved: Need Windows Login of User who changed the data (3 replies)
  240. count matching cell colors (6 replies)
  241. Help With/Code To Enable Macros . . (5 replies)
  242. Solved: rename folder (1 replies)
  243. Solved: remove signs (wildcards) from a string (9 replies)
  244. Running Delete Row Code For All Tabs In A Spreadsheet (1 replies)
  245. Pivot table defaults (3 replies)
  246. Solved: paste value for filtered data (9 replies)
  247. Code to show if cell interior colour is red (1 replies)
  248. vba to automatically hit a key on the keyboard (3 replies)
  249. Help to enable VBA in excel 2007 (6 replies)
  250. Solved: Greater, Less than formula (1 replies)