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: Use a variable to reference a control? (11 replies)
  2. Solved: Reverse code on a macro (4 replies)
  3. Solved: copy data in sheet1 and paste in sheet2 (7 replies)
  4. Code to install addin feature (3 replies)
  5. Solved: Check contents of cells in header row (7 replies)
  6. Solved: Search Form Help (4 replies)
  7. Do While Loop Help (9 replies)
  8. creating a chart using VBA (3 replies)
  9. How to plot on a image file embedded in excel (0 replies)
  10. [SOLVED:] To edit data using UserForm (2 replies)
  11. Solved: Extract info of a point on a chart (2 replies)
  12. Un-wanted audio alert (3 replies)
  13. Append File Names to an Existing List of File Names (5 replies)
  14. problem with filter condition (2 replies)
  15. Display HTML code in Form textbox (2 replies)
  16. userform review function (2 replies)
  17. [HELP] Charts.Add and Range (3 replies)
  18. Check if a Dynamic Array has been ReDim'ed... (1 replies)
  19. Solved: Process checklist (5 replies)
  20. Solved: Floating listbox to navigate within a single worksheet (3 replies)
  21. Solved: Formula in VBA code - modification requested to avoid Error (7 replies)
  22. Select last 30 cells (2 replies)
  23. Solved: Match function (5 replies)
  24. Clear constants in a selection (3 replies)
  25. compile error (1 replies)
  26. workbook_open: simple question (3 replies)
  27. worksheets order + protection (2 replies)
  28. Solved: The use of [] brackets for assigning values or arrays (5 replies)
  29. How to check the data column and empty column??? (3 replies)
  30. Solved: How to loop through the columns??? (2 replies)
  31. Solved: Using For Loop to get info from Text box (3 replies)
  32. determining user domain account (AD) from VBA (2 replies)
  33. Solved: Edit MP3 tags in Excel / VBA (2 replies)
  34. Conting consective cells based on criteria (1 replies)
  35. Solved: send sheet (2 replies)
  36. Solved: Check and copy rows (11 replies)
  37. Cell Formatting (1 replies)
  38. Compare Sheet1 and Sheet2 Results in Sheet3 (2 replies)
  39. Solved: autofilter question (3 replies)
  40. insert comments from countif (7 replies)
  41. [SLEEPER:] Copying Data to Specific Tab (13 replies)
  42. Workbooks.Open using network path (6 replies)
  43. Alignment of new data and add boarders (3 replies)
  44. Solved: Charting Macro Problem (5 replies)
  45. Save File Without Showing Window (2 replies)
  46. Solved: Matching (21 replies)
  47. Looping/Copying/Other (1 replies)
  48. Showing Formula with values in other language (36 replies)
  49. DRJ's conditional formatting (11 replies)
  50. Solved: Replacing Text (4 replies)
  51. [SOLVED:] If cell = "" then highlight cell (21 replies)
  52. removing 0's macro based on columns (1 replies)
  53. Ideas to speeds up PivotTable VBA (2 replies)
  54. 2nd Userform amend posted worksheet to not show UFC Column B (1 replies)
  55. Solved: Sumproduct (Formula not working correctly) (2 replies)
  56. Subtotal calculation using Macro (1 replies)
  57. Solved: move records (5 replies)
  58. Solved: Password Protecting particular rows in excel (11 replies)
  59. Solved: trying to import csv in macro from web. (5 replies)
  60. Trying to call access functions in excel (3 replies)
  61. Disable 'Save' and 'Save As' dialogs (15 replies)
  62. Validating an entry against a database (3 replies)
  63. How to disable the selection of Workbook (5 replies)
  64. Solved: Validating a textbox (1 replies)
  65. [SLEEPER:] Write To Web Page (1 replies)
  66. Copy a sheet from all workbooks in a folder (4 replies)
  67. Solved: Copy a file to the users desktop (3 replies)
  68. Excel (2 replies)
  69. Solved: How to make the mouse Scroll locked (2 replies)
  70. macroto recreate fucntion of grey ADD/REMOVE button onto blue ADD/remove button (0 replies)
  71. Grabbing the cell value before it is changed (or on cell selection) (3 replies)
  72. Solved: Merging two columns as a unique column (11 replies)
  73. Datediff in vba (4 replies)
  74. Refresh Data (1 replies)
  75. need help protecting source code.. (10 replies)
  76. Solved: Problem in auto loading toolpak add-in (6 replies)
  77. Data Extraction (3 replies)
  78. Merge all unique values into one in a required column (14 replies)
  79. Format Msgbox (1 replies)
  80. Finding Unique ID Number & Fill the Cells (19 replies)
  81. Formula help for counting indexed cells? (7 replies)
  82. Extract certain data from file. (1 replies)
  83. Challenging Macro to reverse the function of an existing macro (2 replies)
  84. Solved: Find Empty column (3 replies)
  85. How to hide the workbook while exeuting macro? (6 replies)
  86. Undo option (6 replies)
  87. Code to match two sheets and display differences (3 replies)
  88. Solved: VBA help... Gaining access to training or information (6 replies)
  89. Solved: Mandatory fields (9 replies)
  90. Solved: Tricky formula help? (4 replies)
  91. [SOLVED:] Macro can only be executed if specific cells are selected (21 replies)
  92. Solved: If value in a row = value in another column store in another cell (3 replies)
  93. [SLEEPER:] Set trial time limit on workbook? (10 replies)
  94. Solved: How to insert values in rows through for loop (2 replies)
  95. [SOLVED:] How find the empty column immediately after the data column??? (6 replies)
  96. Test if vba password is set. (2 replies)
  97. [SOLVED:] Disable 'Save As' dialog (4 replies)
  98. Solved: combine mulitple columns (5 replies)
  99. Solved: Matching two sheets help needed (6 replies)
  100. Solved: DTPicker1 in Userform help (6 replies)
  101. Solved: Painfully slow Copy & Paste from Web onto a sheet. (4 replies)
  102. Solved: Condition with StatusBar based on Row number (4 replies)
  103. Solved: Code to automatically enter data update date (6 replies)
  104. Solved: Macro hangs and need an extra step add to the macro (12 replies)
  105. remove corrupt excel names - programmatically? (8 replies)
  106. Solved: Getting 2 pieces of data from one source (cell) (12 replies)
  107. Solved: VBA VLOOKUP error (2 replies)
  108. [SOLVED:] How to skip no dates data in chart (2 replies)
  109. Solved: Sheet name in formula instead of caption (15 replies)
  110. Solved: Conditional Print Preview (9 replies)
  111. Solved: VBA Hyperlink from a Cell ? (4 replies)
  112. Solved: A function as a variable? Pass function as parameter? function pointer? (5 replies)
  113. Grouping Cells + Printing (2 replies)
  114. Solved: selecting and copying a range where a variable is found (5 replies)
  115. Range assignment in chart (1 replies)
  116. Solved: Add a extra step to current macro button (6 replies)
  117. Copy between Excel applications (7 replies)
  118. [SOLVED:] non-modal userform to reflect values with Worksheet_SelectionChange (7 replies)
  119. Problems grabbing hrefs in HTML docs (2 replies)
  120. Swapping multiple cells accross a row (11 replies)
  121. Solved: Dollar symbol in formula (5 replies)
  122. Solved: eliminating blank spaces inside string (2 replies)
  123. Problems with calculating hours worked (11 replies)
  124. Solved: Trying to work out which userform has been opened (4 replies)
  125. Combobox Selection Problem (7 replies)
  126. Autorun externally held macro without opening external file (3 replies)
  127. Data Validation: Listbox (4 replies)
  128. How to do Unit testing in Excel as part of Test Driven Development? (2 replies)
  129. Solved: how to use variables with rows selection (3 replies)
  130. Print selected rows to labels (4 replies)
  131. compare records (6 replies)
  132. Solved: Print information from rows (2 replies)
  133. Excel bug? (5 replies)
  134. saving changes to xlt doc (1 replies)
  135. Error when deleting (1 replies)
  136. View/Print Non-empty columns only (3 replies)
  137. Multiformat Lookup (3 replies)
  138. UserForm (11 replies)
  139. Solved: Copy format Range into another Range (4 replies)
  140. Solved: Filtering Pivot Items by value (4 replies)
  141. Permutation with a handicap (5 replies)
  142. To show multiple contacts pick one (2 replies)
  143. change the defined name range names to correspond to workbook (book1.xls) - (1 replies)
  144. Combobox.value reference (8 replies)
  145. Solved: Glitch in Macro (16 replies)
  146. Improuvement af this macros (1 replies)
  147. Unknown Symbols keep appearing!! (4 replies)
  148. Accessing Web page from Excel (1 replies)
  149. Transpose Row into Combobox (7 replies)
  150. Solved: Delete row if meet the criteria (3 replies)
  151. How do i add the custom toolbars programmatically (1 replies)
  152. Sorting - data in columns - arranged finally in one column (3 replies)
  153. Solved: Adding More Cell Ranges to BeforeDoubleClick and BeforeRightClick Macro (38 replies)
  154. Illegal Characters in Excel File Name (2 replies)
  155. Solved: Define Name from a function (6 replies)
  156. Range copying issues (1 replies)
  157. Challenging Macro (11 replies)
  158. generating emails from excel fields (6 replies)
  159. Solved: Adding Second Symbol (4 replies)
  160. How add new table ellement faster? (2 replies)
  161. Solved: Display if Found, if not edit??? (2 replies)
  162. Solved: Convert a number into a string with a leading zero (12 replies)
  163. Solved: Redirect save when given drive is not accessible (10 replies)
  164. Excel VBA Variant Variable Assigned a Number Tests as Number when assigned to ?? (15 replies)
  165. Solved: Amend vba code to apply same font and styling (6 replies)
  166. Saving Excell Data to File (More complicated then the title says) (3 replies)
  167. Solved: Open User Form in specified range (2 replies)
  168. Remove Duplicates in ComboBox (4 replies)
  169. Solved: Prevent numeric or symbol and if function in userform (5 replies)
  170. Add another call function to an exiting macro button (3 replies)
  171. Help to Modify An macros to compare (3 replies)
  172. Solved: Single click on cell should store value in another cell (3 replies)
  173. When to Use "Application.CutCopyMode" Statement (6 replies)
  174. MS Excel 2007: what is wrong with standard colors when constructing a chart? (6 replies)
  175. Delete row if cell does not contain a particular value (2 replies)
  176. User Defined Function - Write value to a range (3 replies)
  177. Solved: Formula help for odd money calculation? (5 replies)
  178. Spreadsheet maintainance automation required? (1 replies)
  179. Solved: Insert comment pictures fill down. (4 replies)
  180. Regular Express (19 replies)
  181. Solved: conditional formatting by color (8 replies)
  182. Saving data in incremental way in dat format-Help Needed. (0 replies)
  183. How Can I save data in incremental way-Help needed (2 replies)
  184. Solved: Choosing random samples (2 replies)
  185. Scripting.FileSystemObject (2 replies)
  186. Solved: column loop (9 replies)
  187. Solved: Textbox format (2 replies)
  188. Solved: unchecking checkboxes (12 replies)
  189. Solved: Copy only filtered rows (5 replies)
  190. Error Popup (3 replies)
  191. Internet Explorer dialog pop-up from Excel (1 replies)
  192. Solved: double case statement (16 replies)
  193. [SOLVED:] Getting Month and Year from a date cell (3 replies)
  194. Solved: Search through range and fill corresponding offset? (8 replies)
  195. Find Major Lows and Highs in Series (13 replies)
  196. Solved: Add sheet & name (12 replies)
  197. Email several sheets in one workbook password protected (8 replies)
  198. Solved: Deleting Unwanted Rows (7 replies)
  199. How to close the dialog with Excel VBA (5 replies)
  200. Solved: What to do when executing a code freezes Excel? (5 replies)
  201. Can you help me?I want code (2 replies)
  202. Saving (11 replies)
  203. Solved: deleting an asterik (4 replies)
  204. Solved: To copy part of the table data (7 replies)
  205. Solved: Merged Cells Null Value (8 replies)
  206. Help with ADSI spreadsheet (5 replies)
  207. Solved: Pie chart data labels percent formatting (6 replies)
  208. Compare two columns to two other columns (2 replies)
  209. Deselect range after Macro runs (6 replies)
  210. How to Parse a string with VBA (12 replies)
  211. Solved: xlCellTypeVisible question (2 replies)
  212. [SOLVED:] Autofilter OR function (10 replies)
  213. Solved: Time and Date log using VBA (21 replies)
  214. Solved: Locking Merged Cells (6 replies)
  215. [SOLVED:] Get Tenor - Bucket Function (2 replies)
  216. Solved: Loop to Get and put values (5 replies)
  217. Movies and scales (8 replies)
  218. Solved: UserForm turtorial (2 replies)
  219. Looping and shaking (1 replies)
  220. Solved: ActiveSheet Printing (5 replies)
  221. Solved: how to copy value with criteria to other worksheet? (4 replies)
  222. Multi Text Criteria (18 replies)
  223. Pivot table to NOT summarize data? (1 replies)
  224. Solved: Need someone to discreetly look at my code (8 replies)
  225. How can I disable the links and query alerts (3 replies)
  226. VBA search through workbooks to return answer help (7 replies)
  227. Data update does not work from VBS initiated open (4 replies)
  228. Solved: Add a count variable & increment it appropriately in this code (4 replies)
  229. Solved: Autofilter for multiple condition (5 replies)
  230. Solved: Check conditional format colour? (8 replies)
  231. Solved: Create folders and filename (11 replies)
  232. Solved: getting rid of a "If" + improving my code (5 replies)
  233. [SOLVED:] Can't Find Project or Library (9 replies)
  234. Array Formula (sum of ranges) (7 replies)
  235. Solved: Macros men? (10 replies)
  236. Deleting headers between two found variables? (3 replies)
  237. [SOLVED:] Disable Cut, Copy, Paste Macro for One Column (25 replies)
  238. Solved: Excel Macro Help - Hyperlinking (3 replies)
  239. Solved: Textbox formatting question (4 replies)
  240. Creating a lagged correlation matrix (5 replies)
  241. Want to have a static column referring to a dynamic range of data (5 replies)
  242. Solved: using a worksheet function in VBA (9 replies)
  243. Pull Access cells into Excel (4 replies)
  244. Solved: Calendar (4 replies)
  245. VLookup and column indicator (7 replies)
  246. [SLEEPER:] Fill PDF form from Excel (0 replies)
  247. [SOLVED:] Changing Names to Numbers (9 replies)
  248. Solved: Amend vba code to add and extra step (7 replies)
  249. Sleeper: Copying single values instead of range (6 replies)
  250. Alternative to late Binding? (6 replies)