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. Exclude a single xl file from macro (13 replies)
  2. Excel Macro that creates an Auto Macro (1 replies)
  3. Formula Referencing other cells (5 replies)
  4. Cant read txt file with Unicode symbols and store it to cell (2 replies)
  5. Solved: vba to make formulas work (3 replies)
  6. Closed: sendkeys (1 replies)
  7. entirecolumn.hidden with autofilter result (3 replies)
  8. Solved: VBA code for a button with user supplied titles (1 replies)
  9. Filling an array with a for..each construct (4 replies)
  10. Case Select Statement (4 replies)
  11. Solved: Combo Box inside pop-up Message Box ? (13 replies)
  12. Call tracker - VBA coding help (15 replies)
  13. multiple search and filter (1 replies)
  14. Unhide a Hidden Workbook (4 replies)
  15. Solved: Force users to enable macros in a workbook code by Ken Puls. (2 replies)
  16. problem with activecell is blank or zero (1 replies)
  17. Problem with Cancel Button in Input Box (6 replies)
  18. enter commas (3 replies)
  19. Really Quick Precision Question (2 replies)
  20. Solved: Using Bold with .Cells Object? (2 replies)
  21. Compare Workbook to 2nd workbook (Newbie) (3 replies)
  22. removing items from collections (7 replies)
  23. Solved: Extracting 5 or 6 digit numbers from a cell (31 replies)
  24. optionbuttons and vba (4 replies)
  25. Excel multi criteria search (8 replies)
  26. Solved: Copy module from present file to PERSONAL.XLS (10 replies)
  27. Imbedding Image File Instead of Referencing? (9 replies)
  28. Carriage Return not working (2 replies)
  29. Trouble With Assigning Value to Cell (5 replies)
  30. Delete VBA Project (3 replies)
  31. Solved: Initializing Entire Array at Once:: Syntax Error (4 replies)
  32. zodiac userform to display zodiac sign picture based on users birthdate (5 replies)
  33. Save As Issues (excel 2003 and excel 2007) (1 replies)
  34. Need a String Function (7 replies)
  35. Delete WB-Open sub as WB is saved (2 replies)
  36. Custom menu top left (8 replies)
  37. force users enable macros and auto save&close if idle (9 replies)
  38. Solved: Deleting rows from selected cells. (3 replies)
  39. Not Highlighting Errors (2 replies)
  40. Solved: Argument Not Optional Error (1 replies)
  41. Solved: Find string in the cell and then output value (11 replies)
  42. Return a value from an activex (2 replies)
  43. [SOLVED:] Extract Data From Text File (2 replies)
  44. Combining vba for forcing macros and expiry (3 replies)
  45. Array help, deleting columns. (3 replies)
  46. Pasting charts in the same document - avoiding new instance creation (3 replies)
  47. Solved: Passing variables between suns and functions (3 replies)
  48. Solved: Command Buttons to SAVE, SAVE and EXIT and to EXIT without SAVING (5 replies)
  49. Update the value from B file to A file (4 replies)
  50. Searching a record or row. (2 replies)
  51. Solved: .bas vba export question (9 replies)
  52. Solved: copying dynamic range from Sheet1 to Sheet2 (11 replies)
  53. Solved: to accept changes (5 replies)
  54. Remove the file extention from the file list (5 replies)
  55. Insert A row in workbook A automatically if a row is inserted in WOrkbook B (4 replies)
  56. transferring selections from one list box to another (1 replies)
  57. Solved: strange Unload Me behaviour (1 replies)
  58. Solved: Arrows in Excel Document (3 replies)
  59. Solved: Delete row (numbered) all other rows (numbers) change in sequence (31 replies)
  60. Fusing chart and shapes before copying (1 replies)
  61. Finding mode of array in VBA (1 replies)
  62. Need to nest .Find routines in VBA (4 replies)
  63. Solved: Multidimensional Array Sort (3 replies)
  64. Check for visible rows after filter (4 replies)
  65. Solved: Deleting multiple values within range of rows (2 replies)
  66. Insert Template Macro (3 replies)
  67. Solved: Small macro, simpler way of writing it? (4 replies)
  68. calculate % of each items total in a year in Pivot Table (5 replies)
  69. Solved: counting number of observations under condition (5 replies)
  70. Solved: Filter Workbook when protection is on (2 replies)
  71. Solved: UDF for mann-whitney statistical test? (21 replies)
  72. Solved: Batch Renaming all files in a folder (2 replies)
  73. parsing in vbscript (18 replies)
  74. Combination from binary bit to Hexdecimal (5 replies)
  75. Solved: add slash in string (2 replies)
  76. copying information from another tab (1 replies)
  77. Reading pdf file into excel 2007. (6 replies)
  78. Delete Custom Document Properties? (1 replies)
  79. Solved: From Excel, create table of selected rows in Word (11 replies)
  80. Count all unique entries in a column (mission impossible?!) (12 replies)
  81. Solved: VBA to delete text between < > (4 replies)
  82. Solved: Excel insists on changing the format of cells (4 replies)
  83. Selecting a sheet within a workbook by using a macro (11 replies)
  84. ListBox Item queries (2 replies)
  85. Set TextOrProperty attribute change the name of company (4 replies)
  86. Autohyperlink to and replace file names in worksheet (4 replies)
  87. calculating monthly returns in table from historical data (6 replies)
  88. Late-binding --pls sort out the confusion (3 replies)
  89. Using data in a worksheet and vba to complete a form on a website. (0 replies)
  90. Solved: Highlight only certain words in cells (2 replies)
  91. is it possible to do screen tips without hyperlinks (4 replies)
  92. Worksheet change - single click>value entered (1 replies)
  93. Solved: Set X-Axis Value to match row numbers (9 replies)
  94. EXCEL TO WORD BOOKMARK (0 replies)
  95. Sorting CurrentRegion? (1 replies)
  96. Solved: Printout Problems (5 replies)
  97. Importing part of textfile (3 replies)
  98. start search from beginning with static variable (3 replies)
  99. Excel 2003 File Size (12 replies)
  100. How to make a text box mandatory? (5 replies)
  101. checkbox to populate 2 textboxes? (2 replies)
  102. Mega Sort (1 replies)
  103. Solved: Code randomly stops without CancelKey Disabled (5 replies)
  104. textbox validation help please :-) (6 replies)
  105. Copying from a PDF file (1 replies)
  106. Message box to appear once commandbutton is pressed? (4 replies)
  107. Password to open file via macro? (1 replies)
  108. Listbox items getting transferred in reverse order (3 replies)
  109. Sports league VBA program (6 replies)
  110. Solved: move to textbox in other sheet if is "TAB" pressed (12 replies)
  111. Need VBA help with populating missing data?? (3 replies)
  112. Solved: Modify Hyperlink Code (14 replies)
  113. Super Quick ComboBox Question (3 replies)
  114. Solved: Countif with a Range Name as the Criteria (5 replies)
  115. print preview , value of ending line on page (6 replies)
  116. Copying Data from different workbooks (1 replies)
  117. Solved: Flashing commandbutton? (6 replies)
  118. Multiple Excel ranges to multiple Word tables. (9 replies)
  119. Solved: run access macro from excel (2 replies)
  120. Same code - one set works but other does not... (5 replies)
  121. How to open a secured directory (0 replies)
  122. Solved: Copy the table in Word document to NEW Excel file (7 replies)
  123. Solved: Count Formula Based Currency Criteria (3 replies)
  124. UDF for Three Parameter hlookup (6 replies)
  125. How to tell user to get updated copy? (18 replies)
  126. Solved: Inserting an undetermined number of rows? (2 replies)
  127. DSO and File Properties (0 replies)
  128. Solved: Conditional Format VBA not using Range Name Value (2 replies)
  129. Special Calendar to fill textboxes (1 replies)
  130. Need help about listbox column count property (1 replies)
  131. Userform triggers Excel Crash (6 replies)
  132. I just want the Date, not the time (CDate(Now)) (1 replies)
  133. Date formula required (4 replies)
  134. How to know value of margin of the last row on page (1 replies)
  135. Solved: How To make Macro Interactive (4 replies)
  136. Solved: Distribution Graphs (6 replies)
  137. alerts out of a spreadsheet based on dates (3 replies)
  138. make textboxes visible at runtime? (4 replies)
  139. What Message Is Being Written? (2 replies)
  140. Help in Vlookup function error (2 replies)
  141. Event for Ctrl-G (3 replies)
  142. Linking to formula rather than paste special (4 replies)
  143. Solved: download files from internet thruugh VBA (2 replies)
  144. Make VBA Code Shorter (6 replies)
  145. Merge cells based on a cell value (4 replies)
  146. Solved: Delete Text to Left of First Number (9 replies)
  147. Problem with error type mismatch (5 replies)
  148. Solved: Unhide and activate sheet based on system date (9 replies)
  149. Solved: How do I sort a dynamic named range? (3 replies)
  150. Solved: How to sum a range of cell values based on common data field (3 replies)
  151. Applying Format To ALL sheets in Workbook (1 replies)
  152. Saving a Worksheet (1 replies)
  153. Solved: Changing Values Between Text Boxes (2 replies)
  154. delete blank rows (1 replies)
  155. Solved: Select copy & paste (2 replies)
  156. Different sound file question - simple ?? (1 replies)
  157. Loading malformed xml into MSXML2.DOMDocument (8 replies)
  158. How to Add a File to References List with VBA (7 replies)
  159. Solved: Select variable range of rows and then delete ?? (14 replies)
  160. Search value as the part of the Sheetname (24 replies)
  161. Solved: Range Error during loop (2 replies)
  162. Solved: Remove a shapes (3 replies)
  163. Using Variables in VBA formulas (1 replies)
  164. Solved: Join Sheets Cells By Common Field (2 replies)
  165. Solved: Delete emty rows. (6 replies)
  166. Rename controls in VBE (3 replies)
  167. Data Validation issues (5 replies)
  168. can't call subs automatically (2 replies)
  169. Stringlists or String arrays (7 replies)
  170. What Causes “Personal.xls” to be Opened? (1 replies)
  171. Chart Help::Stacked Column (4 replies)
  172. Excel form to database help (2 replies)
  173. Solved: Insert comment (2 replies)
  174. Solved: total by company (4 replies)
  175. Progress bar Running on top (1 replies)
  176. How to get to the single dictionary entry without knowing its key ro value? (7 replies)
  177. Solved: modify code to run on several sheets in a workbook (10 replies)
  178. use excel database to populate 2 different word doc (1 replies)
  179. Solved: Combobox linked to calender (2 replies)
  180. Solved: Date and time (3 replies)
  181. Solved: VBA to count characters in cell - getting error (2 replies)
  182. Solved: TextBox Character limit (14 replies)
  183. Solved: set row color based on value of a cell (5 replies)
  184. Solved: Closing Excel by clicking the Red X (0 replies)
  185. vlookup closest value (5 replies)
  186. Solved: Quick Concatenate Question (formatting) (3 replies)
  187. Compare VBA Code in Modules (1 replies)
  188. XL2000 Add-In Question: (4 replies)
  189. Solved: textbox disappears (3 replies)
  190. Error 461 (1 replies)
  191. problem unprotect vbproject (0 replies)
  192. Runtime Error 5: Invalid procedure call or argument (0 replies)
  193. Image Popup when mouse arrow is on Button (3 replies)
  194. Transform data to Columns (15 replies)
  195. Can’t Find Project on Library . . . (7 replies)
  196. 2007 Pivot Table Conditional Formatting macro problem (5 replies)
  197. Error Msg: MS Office is waiting for another application to complete an ole action (0 replies)
  198. modify nextrow code (15 replies)
  199. Solved: make visible based on value (2 replies)
  200. Conditional formatting (2 replies)
  201. Write to a text file (1 replies)
  202. Solved: Code Amend to OK Msg Box Before Close (1 replies)
  203. run code from personal.xls (0 replies)
  204. Solved: Text To Columns - passing FieldInfo value as a string (2 replies)
  205. Date Format (6 replies)
  206. [SOLVED:] Open access and run macro in access (2 replies)
  207. Formula to Prevent a higher % to be entered...Help (3 replies)
  208. Solved: Auto fit columns in whole workbook (1 replies)
  209. Count Files in Several Folders (7 replies)
  210. Inserting a Range on a Chart as TextBox ? (3 replies)
  211. Help uploading excel cells into website (2 replies)
  212. Summing Similar Conditons (1 replies)
  213. Drop down List (9 replies)
  214. Solved: Combine Data into one Cell (5 replies)
  215. Calculating An Average (1 replies)
  216. Solved: count all equal combinations (3 replies)
  217. Solved: BeforeDoubleClick Issue? (5 replies)
  218. Solved: I'm having trouble selecting a range (3 replies)
  219. string manipulation problem (3 replies)
  220. Solved: Return default save path for an excel add-in (11 replies)
  221. "INDIRECT" worksheet fuction problem (4 replies)
  222. Limit amount of rows formatted (1 replies)
  223. Open Template with file picker (2 replies)
  224. update procedure in excel file from personal.xls (2 replies)
  225. Speed up loop? (2 replies)
  226. Is this something that I can do in VBA? (2 replies)
  227. Dynamic pivot charts using pivot table (0 replies)
  228. Survey in Excel using Visual Basic Need to edit! (21 replies)
  229. Fairly simple problem (8 replies)
  230. Format Cell For Time (3 replies)
  231. Order an array from the smallest number to the biggest (22 replies)
  232. First date in week from <WeekNo, Year> (6 replies)
  233. Solved: search next value with textbox in other sheet (33 replies)
  234. [SOLVED:] Trying to get Code to run in excel 2007 (7 replies)
  235. Solved: Regression Analysis macro (4 replies)
  236. Excel chart in PowerPoint (3 replies)
  237. Extra Information alongside Pivot Table (0 replies)
  238. TAB Name (16 replies)
  239. Solved: search next value with textbox (6 replies)
  240. Excel to PDF (2 replies)
  241. need some code to move items into new sheets (7 replies)
  242. Problem with ComboBoxes (control toolbox ones) (4 replies)
  243. [HELP] Merging all the details of the work book in one sheet. (7 replies)
  244. How to Calculate Tax from Net Amount--Help (5 replies)
  245. Input more than 15 digits numbers in a cell in a worksheet (2 replies)
  246. [SLEEPER:] Automatically populate userform from row selection in excel (3 replies)
  247. display range value in message box (5 replies)
  248. Solved: Bar Chart doubt (2 replies)
  249. Highlight cells that did not match (1 replies)
  250. Highlight Row Based on Cell Value (1 replies)