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. How do I Drag and Drop to a Userform Control? (5 replies)
  2. Solved: Copy information in named range to another workbook (2 replies)
  3. Solved: Variable as AutoFilter Criteria (8 replies)
  4. delete all #n/a (4 replies)
  5. moving data to another tab in Excel (6 replies)
  6. Help with Function in 2003 conversion to 2007 (7 replies)
  7. Solved: Forms - creating a wizard with moving parts (1 replies)
  8. Solved: default program for a file type (6 replies)
  9. [SOLVED:] Counting cells in one column based on values in a different column. (4 replies)
  10. Solved: event to capture changing the height or width of a cell (2 replies)
  11. Drawing Borders in VBA (6 replies)
  12. Solved: remove/delete cells (7 replies)
  13. Solved: macro to delete rows (2 replies)
  14. [SOLVED:] creating subfolders and saving files in them (7 replies)
  15. Solved: if formula (2 replies)
  16. Insert row after data change (4 replies)
  17. Opening and saving an email attachment from outlook (0 replies)
  18. Solved: Copy Paste Loop Multiple Sheets (5 replies)
  19. 1004 / Out of memory (2 replies)
  20. Vba Code Error (10 replies)
  21. Solved: remove/delete empty rows (3 replies)
  22. Solved: formatt numbers macro (2 replies)
  23. Solved: I want to set column H to column V as the email body (15 replies)
  24. Solved: if formula (2 replies)
  25. macro to speed up deleting empty rows process (7 replies)
  26. Excel VBA code to get Autofiltered data to array (9 replies)
  27. Solved: Yield to Maturity (5 replies)
  28. Error Copying Data (3 replies)
  29. screen redraw problem (not ScreenUpdating) (2 replies)
  30. iexplorer macro (0 replies)
  31. Solved: Chart Format (2 replies)
  32. Response Time UDF needs to be modified (3 replies)
  33. Solved: Parse cell data into seperate columns (7 replies)
  34. Solved: VBA Sources (3 replies)
  35. Solved: Macro for finding rows and copying to a new sheet. (2 replies)
  36. Sorting items in a multi-column listbox (1 replies)
  37. vlookup macro tricky (1 replies)
  38. [SOLVED:] Using Ampersand "Showing a Zero" (9 replies)
  39. Solved: Userform - Code as written will not populate all 22 data elements (7 replies)
  40. Solved: macro to edit/format data in excel 2007 (6 replies)
  41. Solved: New to VBA (18 replies)
  42. Dealing with #N/A and non-continuous sums (2 replies)
  43. Multiple Column Listbox help (6 replies)
  44. open xlsm vs. xls (6 replies)
  45. adding code to a sheet that is added at runtime (2 replies)
  46. Click on cell to open item for editing (7 replies)
  47. Solved: Application-defined or object-defined error (3 replies)
  48. Getting the integer of the month (3 replies)
  49. Manipulate the Ribbon from VBA directly (3 replies)
  50. Disable or enable (2 replies)
  51. Problem Importing Files (1 replies)
  52. Error 438 FileDialog Filters.Add (5 replies)
  53. Formating Data (1 replies)
  54. Solved: Rearrange the location in txt file by EXcel VBA (1 replies)
  55. folders and subfolders troubles (4 replies)
  56. Automate Lagging of Variables (8 replies)
  57. Solved: vlookup with condition (4 replies)
  58. Solved: code to turn on update links (5 replies)
  59. excel date activated self destruct (1 replies)
  60. right click menu (2 replies)
  61. error when changing data in a Pivot table usinga macro (2 replies)
  62. Filtering data with userform (11 replies)
  63. Solved: copy range issue (15 replies)
  64. Solved: worksheet scrolling (8 replies)
  65. [SOLVED:] Excel userform ListBox multicolumn (3 replies)
  66. Paste Multiple lines into single Cell (2 replies)
  67. Sort Alphanumeric Data & Retaining Leading Zeros (2 replies)
  68. Solved: ListBox as a Variable? (6 replies)
  69. Formating Subtotals (3 replies)
  70. Syntax on Application.Average (2 replies)
  71. [SOLVED:] Why Is my code so painfully slow? (3 replies)
  72. Copying a Textbox and Combobox at runtime (4 replies)
  73. Filter in Excel (1 replies)
  74. function (1 replies)
  75. Solved: MsgBox to ensure proper values are used (4 replies)
  76. Solved: How incorporate an OR( into a MAX(IF( function? (6 replies)
  77. [SOLVED:] How to Reference Sheet Name in Formula (2 replies)
  78. HELP with Removing Styles: error029120_01.xml (0 replies)
  79. [SOLVED:] Drop List for a column... (3 replies)
  80. Hi I have a workbook with sheets named from A to Z. These sheets suport a smalboboxes (5 replies)
  81. Using 1 file to create 2. (1 replies)
  82. Auto Run Macro (4 replies)
  83. Move sheets to a password protected closed workbook (1 replies)
  84. Cannot delete SendTo or My Docs folder with DeleteFolder (3 replies)
  85. Standard open/save file forms in VBA (3 replies)
  86. Outlook Manipulation via Excel VBA (0 replies)
  87. vba validation list (2 replies)
  88. Solved: Private Sub Worksheet_Change(ByVal Target As range) (3 replies)
  89. Sleeper: Biffed something in the code... (5 replies)
  90. Solved: Using months and weeks in Lookup formulae (5 replies)
  91. suffix (1 replies)
  92. delete spaces (1 replies)
  93. Solved: Probably not the right tool but...can Excel.. (16 replies)
  94. fill column when a row criteria was satisfied (2 replies)
  95. Userform On Website? (3 replies)
  96. open a new instance of Excel (9 replies)
  97. Solved: Create folders if don't exist (2 replies)
  98. application defined error - VBA (1 replies)
  99. Comparison on 2 sheets base on a unique name (3 replies)
  100. [SLEEPER:] verify text of IE (1 replies)
  101. Solved: convert number to text (6 replies)
  102. how to highlight the first value in a listbox (8 replies)
  103. [SLEEPER:] Detail MsgBox (1 replies)
  104. Excel - WebBrowser Control - Vista/IE7 (4 replies)
  105. How to show Detail Box (10 replies)
  106. a word of thanks to all those that help in this forum (0 replies)
  107. [SOLVED:] VBA to convert .exe (6 replies)
  108. Listbox with zero entries (9 replies)
  109. Solved: recursive sheet deactivate event (10 replies)
  110. Script out of range error (7 replies)
  111. manipulating Excel's "Normal" style (11 replies)
  112. Solved: Find records and return values to new column (5 replies)
  113. Solved: Dynamic Drop down list based on filtered list (2 replies)
  114. Having problems trapping error 76 (6 replies)
  115. Open File for Output:: What if file does not exist? (2 replies)
  116. Solved: VBA coding help (5 replies)
  117. Solved: Forms with hyperlinks (3 replies)
  118. Wanted: Testing and feedback of Duplicate Master addin V2.0 (14 replies)
  119. Click listbox and Show picture (3 replies)
  120. Help with For Loop Structure (3 replies)
  121. Solved: VB control of IE Dialog box (7 replies)
  122. Solved: Find last row and set range name programmatically (2 replies)
  123. Solved: Repeating Rows at the BOTTOM (7 replies)
  124. Solved: Creating a look-up and complete macro (12 replies)
  125. Change sheet to PDF & Delete Sheet (3 replies)
  126. Solved: excel vba book recommendations (2 replies)
  127. Solved: can you get vba to declare variables based on an argument passed (1 replies)
  128. Do Update only Loop, NOT again from start Sub with DDE link (2 replies)
  129. How to update a list to fill combobox (14 replies)
  130. Solved: How to check if user has PI tag addin if not add it? (2 replies)
  131. Solved: need help for ranking a list (2 replies)
  132. Update excel record to existing DBtable (4 replies)
  133. Extract string within tags (1 replies)
  134. Checking each cell in a row (8 replies)
  135. Placing data on a closed excel file in Sharepoint (1 replies)
  136. [Urgent] Getting NetWare Info for Owner of File into Excel 2003 via VBA? (3 replies)
  137. Copy & Pasting in VBA (3 replies)
  138. Solved: Macro won't run (5 replies)
  139. Loop OK manually, but "freezes", when run with DDE update (1 replies)
  140. Trouble with pasting a formula (3 replies)
  141. Delete Macro (7 replies)
  142. Solved: Percentrank :CSE (6 replies)
  143. Copy Paste of Filtered data with hidden columns (2 replies)
  144. Switch off subtotal on pivot table (2 replies)
  145. record and play macro to create commandbutton gives different results (10 replies)
  146. Referencing worksheet name using code name (7 replies)
  147. Solved: Instr & bold (2 replies)
  148. Hyperlink to Search Folder for a Number (20 replies)
  149. Solved: Error::Can'tDeclare Array as 'Public' ::What is Excel's Problem now? (4 replies)
  150. Not able to access input boxes on a web page (3 replies)
  151. Delete Row if Cell Contents = "ABC" (6 replies)
  152. Solved: Copy rows from one worksheet to another with some condition. (4 replies)
  153. Auto sort consolidation book (7 replies)
  154. Solved: Data Validation list based on a filtered list. (2 replies)
  155. Pivot Table Stored Proc with Parameter (1 replies)
  156. save sheets as new version: changes required in existing macro (1 replies)
  157. Solved: Copy the text from WORD to EXCEL (4 replies)
  158. Absolute value (1 replies)
  159. Sorting a table (1 replies)
  160. excel save as csv (4 replies)
  161. Using 'IsNumber' in a Select Case (2 replies)
  162. Solved: Timing a For Loop (2 replies)
  163. referring to numbers/alphabets (8 replies)
  164. Solved: (VBA) Recursively list files and output to csv (2 replies)
  165. Pivot Table - Getting Correct Profit % (2 replies)
  166. ADO Version (2 replies)
  167. Solved: locking VBA project (5 replies)
  168. Solved: Inserting formulae into Used range (2 replies)
  169. Solved: Deleting Rows (2 replies)
  170. Scrolling not working for TreeView (0 replies)
  171. Need comments (1 replies)
  172. [SOLVED:] Delete Sheet In VBA Project Window (1 replies)
  173. Printing In Excel (2 replies)
  174. Solved: Problem Launching Excel from Access with CreateObject (2 replies)
  175. Solved: hiding Rows using index number (3 replies)
  176. Solved: worksheet value change affecting 2 cells (5 replies)
  177. Solved: Why is this not working? (7 replies)
  178. how come temp files keep showing up (2 replies)
  179. Solved: little sub that can MERGE (3 replies)
  180. ODBC in VBA excel (5 replies)
  181. Solved: intersection of named range and a column (3 replies)
  182. preserve regional settings when saving to xlTextPrinter (1 replies)
  183. Run macro whenever you change sheets (2 replies)
  184. Format values copied and concatenated (2 replies)
  185. How to use ' to ignore large section of codes (4 replies)
  186. Count Empty Range and MsgBox (4 replies)
  187. Input Box/User Form (3 replies)
  188. Chart object fails (8 replies)
  189. ListBox Transfer Query (2 replies)
  190. Solved: Search directory and return values (19 replies)
  191. Import range from closed excel file (1 replies)
  192. Using if statements in PivotTable formulas (2 replies)
  193. Folder Search File List (4 replies)
  194. Passing data between a main code and an UserForm (6 replies)
  195. Find matching columns/cells and copying over data (1 replies)
  196. using wildcards in Formulas (1 replies)
  197. Verify that a Hyperlink successfully opened (0 replies)
  198. Adding a,b,c letter to duplicates (4 replies)
  199. how to check if file is read only, but from other file (4 replies)
  200. Excel refresh page (3 replies)
  201. Solved: Resize autofilter (2 replies)
  202. Changing Colour Palette (3 replies)
  203. Evaluating a string of an array (3 replies)
  204. Solved: Lookup Column A value and add Column X- then copy to other sheet (5 replies)
  205. Solved: Copying formula down used range (2 replies)
  206. Convert entity in excel (1 replies)
  207. Need to know how to copy into next blank column (1 replies)
  208. [SOLVED:] Auto Fill into Text Box / cell (3 replies)
  209. [SLEEPER:] Renaming not working correctly (7 replies)
  210. Solved: Problems with creating a shift-plan for a new year (10 replies)
  211. Sleeper: Activecell.offset (3 replies)
  212. append color text (VBA) (2 replies)
  213. 3D Chart (10 replies)
  214. Filter data (8 replies)
  215. Solved: OFFSET and MATCH formula not working (4 replies)
  216. Creating a standard form (1 replies)
  217. Why does the path appears in some function formulas but not in others? (5 replies)
  218. Solved: Need errorhandling for "print sheet" buttons (6 replies)
  219. Lookup on two values and copy cells when match found (7 replies)
  220. [SOLVED:] Subscript out of range' Error ... (20 replies)
  221. Button macro (9 replies)
  222. Get data from protected file, changes required in existing code (4 replies)
  223. Copy row data another worksheet in columns (0 replies)
  224. File Chooser Needed (6 replies)
  225. auto conversion (0 replies)
  226. .Find and Dates.. (13 replies)
  227. Have worksheet refresh only for changes in certain cells (3 replies)
  228. Excel 2007 Legend Border (1 replies)
  229. Solved: pivot table problem (5 replies)
  230. return column of change (3 replies)
  231. Solved: Remove first word in a string (13 replies)
  232. Solved: Worksheet Protection except Specific Column (3 replies)
  233. Solved: Excel: Sumproduct or Nested IF statement help (3 replies)
  234. Intersect function to find matching row AND column? (3 replies)
  235. Counting Forward x number of months from given date (1 replies)
  236. E-mail attachment with VBA from Excel (4 replies)
  237. Solved: Insert Row every nth row (3 replies)
  238. Vlookup from autoupdating master (5 replies)
  239. Help! Macro to copy worksheet from different templates (6 replies)
  240. Test 3 spots (1 replies)
  241. Solved: Determining Type of Data in a Column (5 replies)
  242. Using VBA to create WordArt (4 replies)
  243. Adding Comments to a Formula (8 replies)
  244. Multicolumn ListBox - Moving item upwards (1 replies)
  245. Print Multiple Pages from DropDown Box using Macros? (5 replies)
  246. Conditional selection in excel VBA? (3 replies)
  247. [SOLVED:] Need Help : VBA in EXCEL / (if possible in DIAdem software) (25 replies)
  248. Vlookup from two cells (5 replies)
  249. highlighting over due dates (1 replies)
  250. Simple find? (8 replies)