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: Search rows and copy and save them (4 replies)
  2. How to Show Blank Cell Instead Of #DIV/0! (2 replies)
  3. [SOLVED:] Compile all xls file column by column (6 replies)
  4. [SLEEPER:] custom 'Filename' function (2 replies)
  5. [SOLVED:] percentual match of cells (8 replies)
  6. tough charting code (6 replies)
  7. Solved: 'Else without If' error... (3 replies)
  8. Macro HELP PLEASE (5 replies)
  9. [SLEEPER:] latency issue with web query? (2 replies)
  10. Solved: prevent typing in a Data Val drop-down (9 replies)
  11. Solved: How to stop it closing??!! (1 replies)
  12. [SOLVED:] Auto attach Worksheet to new outlook email (1 replies)
  13. Solved: Populating a Listbox from multiple name ranges (Excel '97) (10 replies)
  14. Copying Values and Pictures into new workbook: VBA (0 replies)
  15. Solved: Formatting with Calulated Values (3 replies)
  16. Solved: Chart ControlTipText (1 replies)
  17. Extracting Chart Data and Automated VBA Procedure for Slope (1 replies)
  18. Copy Worksheet code needs to copy VALUES (8 replies)
  19. Solved: Preventing Excel from opening in IE (8 replies)
  20. Changing function input from Cell dropdown to Combobox (4 replies)
  21. Solved: Runtime Error 1004 for Application.Username (12 replies)
  22. Updating Data on a Worksheet from a Userform (Excel '97) (0 replies)
  23. Check if CommandBarPopup exists (2 replies)
  24. [SOLVED:] Clearing a Userform (3 replies)
  25. Solved: Row Color Range When Cell Changes Color (4 replies)
  26. How to calculate loss or profit for multiple trades (3 replies)
  27. Solved: UDF, VBA or Formula for multi-conditional SUMIF? (2 replies)
  28. Solved: Column Heading Search (7 replies)
  29. Help with cell referencing (6 replies)
  30. Call vba function from flash embedded in excel (1 replies)
  31. Solved: If Cell is certain value THEN hide rows (7 replies)
  32. Solved: Sumproduct Syntax (9 replies)
  33. Show picture in Userform (8 replies)
  34. [SOLVED:] Moving data from columns to rows (6 replies)
  35. How to Join 2 Macro into 1 (7 replies)
  36. Change Read-Only Status (Excel '97) (2 replies)
  37. Solved: Formula not entered by macro (5 replies)
  38. Solved: Custom Function for UpTime Calculation (5 replies)
  39. Need help with Range (5 replies)
  40. check multiple conditions in a excel sheet through VBA (11 replies)
  41. Solved: Custome Function Returns Wrong Value (2 replies)
  42. Solved: AutoFilter (3 replies)
  43. Hyperlinks to many Sheets within a Workbook (9 replies)
  44. Getting file name from sharepoint (0 replies)
  45. Count number of .pst files from excel vba (1 replies)
  46. [SLEEPER:] Print PDF (1 replies)
  47. Solved: Closing file takes A LONG TIME (5 replies)
  48. Solved: Dates in text String (4 replies)
  49. Solved: Hyperlink Cell to Include Cell Value in Link (11 replies)
  50. Solved: Comma delimited CSV (23 replies)
  51. Solved: Normal distribution (2 replies)
  52. Select first non-hidden row below starting cell (3 replies)
  53. SOLVED: Delete row with Autofilter takes ages after ADO code (5 replies)
  54. [SLEEPER:] Problem with Application.Quit (2 replies)
  55. Delete Excel sheet without prompt (1 replies)
  56. Copy dat to another sheet Macro (1 replies)
  57. Point to pixel conversion (1 replies)
  58. Excel VBA Worksheet Consolidation Help (0 replies)
  59. VBA Tutor wanted in Philadelphia area (3 replies)
  60. How to format chart? (1 replies)
  61. PageBreak, AutoFilter, SpecialCells (4 replies)
  62. Solved: Use Worksheet Variable in vlookup code (7 replies)
  63. Textbox Macro Comes Up Empty (5 replies)
  64. Update value window (2 replies)
  65. Custom Function Help Features (2 replies)
  66. Solved: Leading Zero with a twist (3 replies)
  67. data control (5 replies)
  68. Referencing Data in a different location (4 replies)
  69. Bold text in userform tabs (1 replies)
  70. Solved: Delete Row From UF (2 replies)
  71. Solved: CODE TO CLEAR ROW CONTENTS BASED ON MATCH NAME (3 replies)
  72. Solved: HTTP File Download (1 replies)
  73. Lots of problems, excell beginner (0 replies)
  74. Split a string (3 replies)
  75. Join two tables with conditions (4 replies)
  76. Solved: If Statement Using Named Ranges (10 replies)
  77. Solved: how to find the value with 2 conditions (2 replies)
  78. Refreshing external data on individual sheets in a specific sequence. (2 replies)
  79. CDO attaches all file in Loop (0 replies)
  80. Read Only Visible Columns from a range (1 replies)
  81. Return values from a cell (3 replies)
  82. message box (2 replies)
  83. [SOLVED:] Help With Form (2 replies)
  84. Solved: Add Labels Together (11 replies)
  85. Need help getting an Excel Session to ignore .xls files from the web...(Not the usual (0 replies)
  86. Solved: using "--" (6 replies)
  87. [SOLVED:] Copy a Chart into another Sheet without Links (3 replies)
  88. Problem importing data from an xml file (0 replies)
  89. Report Macro (7 replies)
  90. Solved: Move excel files to a difference folder if sheet name is not "Payment Request" (4 replies)
  91. Problem toggling details (4 replies)
  92. Excel VBA to print the entire Workbook single sided (0 replies)
  93. Using an Excel Spreadsheet as a DataSource using DAO (3 replies)
  94. Sub string help (5 replies)
  95. Solved: Inserting data from Excel into Access (10 replies)
  96. Solved: Formula Problems (3 replies)
  97. Solved: Calculate cell (6 replies)
  98. Solved: SUMIF "criteria" (17 replies)
  99. [SLEEPER:] Extracting highest value correlations and series names from Correlation Matrix (10 replies)
  100. Stop Excel from Updating Formula to external Workbook when copying the formula (5 replies)
  101. Solved: useform help filling list from DB VBA (1 replies)
  102. VBA Code Help (0 replies)
  103. Print specific pages of PDF in Excel using VBA (0 replies)
  104. I need help with a click proceedure attached to a dynamic label (5 replies)
  105. Solved: UserForm change width- Left Border? (13 replies)
  106. Process works in debug (2 replies)
  107. Refresh pivots on close AND on data being entered (2 replies)
  108. Solved: wb close and form close (5 replies)
  109. First & Last name comparisons (2 replies)
  110. Special macro for range goal seek (7 replies)
  111. Shifting data in cell from a work book to another based on some condition. (5 replies)
  112. Solved: Detect if workbook is Read Only (4 replies)
  113. Add subject, body, and attachments to emails thru excell/groupwise (4 replies)
  114. Solved: Limit length of input text box.. (2 replies)
  115. Solved: Centralized Log Manager (7 replies)
  116. Solved: Prevent Sql injection in User Form (1 replies)
  117. Solved: Macro to Add Link to Each Worksheet? (5 replies)
  118. Can Excel 2007 help with website accessibility? (1 replies)
  119. Passing a UDT member/element (4 replies)
  120. Varying the cell range around a sum formulae (5 replies)
  121. Solved: How to chk on duplicated cell values & show msg box (15 replies)
  122. Workbook OPEN Event Code - Update Links (6 replies)
  123. Userform input value to macro (3 replies)
  124. Combine 2 or more Cells into 1 Cell VBA (2 replies)
  125. File Lister (2 replies)
  126. Is it possible to create VBA or even VB just by entering data into a worksheet? (1 replies)
  127. VBA for Pivot Tables Help (Dates) (1 replies)
  128. Solved: Dynamic code based on cell values (3 replies)
  129. Copy and Paste Range in the body email (0 replies)
  130. Solved: Hyperlink - full address from displayed text (2 replies)
  131. Solved: import data from another workbook (3 replies)
  132. Remove zero chart labels (4 replies)
  133. Solved: Moving Rows with repeated value to different Tab (3 replies)
  134. Solved: Changing Arrangement of Text in a cell (3 replies)
  135. VLOOKUP or HLOOKUP (1 replies)
  136. Solved: find, copy and paste (10 replies)
  137. Solved: Data Validation , multiple selection same cell (16 replies)
  138. Unable to copy excel spreadsheet to another spreadsheet (1 replies)
  139. Public Variables don't work (10 replies)
  140. Help With Formula (2 replies)
  141. Solved: Hide Unhide Worksheets based on Name (23 replies)
  142. Wrapping UserForm Modules. (1 replies)
  143. Solved: Error 1004 in Transpose macro (2 replies)
  144. RibbonX code (1 replies)
  145. Capture Printer from Printer Dialog (1 replies)
  146. Working on Code efficiency... (2 replies)
  147. Forward stepwise regression using VBA (6 replies)
  148. Do Loop Help (6 replies)
  149. [SOLVED:] Need Help Trying to Unlock Certain Cells (3 replies)
  150. Generate a message to Save and Not Open when downloading a file (6 replies)
  151. Solved: Remove blank series from a chart using VBA ? (4 replies)
  152. Hiding sepecific column on based of condition (3 replies)
  153. autofilling formulae across columns (1 replies)
  154. Making a cell noneditable based on dropdown value in another cell (8 replies)
  155. [SOLVED:] Database Connectivity Using Singleton Pattern (7 replies)
  156. Solved: Code to find a given string in a worksheet (4 replies)
  157. Solved: Excel Update Links Problem (4 replies)
  158. Solved: UserForm KeyDown Button Forces cursor to jump to next textbox (6 replies)
  159. Incorporating lastrow variables into sumproduct formula (8 replies)
  160. [SOLVED:] Looping through a range code (5 replies)
  161. Delete Copied Data (3 replies)
  162. Using Progress Bars (3 replies)
  163. VBA Statements work in debug, but not otherwise. (2 replies)
  164. Solved: Sheet Calculate Event Not Working (1 replies)
  165. Solved: Macro to add value to cell based on previous available cell valu (9 replies)
  166. Paste Combo Boxes so Cell Link is always in same row (3 replies)
  167. Disabling ActiveXControls Prompt (7 replies)
  168. Decent Grids (2 replies)
  169. Solved: Check list of folder files (5 replies)
  170. Match value in two columns & delete non-matching rows (13 replies)
  171. Self Destruct VBA Code (10 replies)
  172. Solved: Find a sheet name (4 replies)
  173. Copy to first filtered row problem (3 replies)
  174. Solved: Sync ListViews items (1 replies)
  175. Excel 2007 and if statements (3 replies)
  176. Unable to copy, paste; Right click disabled (14 replies)
  177. Solved: Insert a formula if a different cell is not blank (3 replies)
  178. Solved: Copy range from multiple excel files in one file (5 replies)
  179. Solved: Get cell reference from one cell (5 replies)
  180. move items in column up/down by criteria (5 replies)
  181. Update specific data in one sheet with NEW data from another? (4 replies)
  182. problem comparing cells based on a condition (6 replies)
  183. Functions (7 replies)
  184. How do I check if a word file is open from code? (9 replies)
  185. Selected Cell Color / Personal.xlsb (3 replies)
  186. Solved: clicking on option button (6 replies)
  187. Maximum users of an Excel File? (1 replies)
  188. Solved: Pattern match to find worksheet name (3 replies)
  189. Trapping UserForm Events In A Seperate Class (3 replies)
  190. Finding String2 in String1 (2 replies)
  191. Copy from a cell and insert in another on a new line with a date (4 replies)
  192. Excel 2007 Pivot chart - showing filters on pivot area (1 replies)
  193. Using Template To Produce Reports Where Number Of DataItems Changes - Advanced. (2 replies)
  194. Error when passing data from Excel into Access (Office '97) (2 replies)
  195. Solved: Calendar Control (3 replies)
  196. Tracking Deadlines with Excel and Groupwise (1 replies)
  197. Select/De-select items in list box (3 replies)
  198. Closed: My Macro keeps crashing! (2 replies)
  199. My Macro stinks (2 replies)
  200. Solved: Prevent duplicate data entry? (15 replies)
  201. [SOLVED:] Macro to make linegraphs (13 replies)
  202. How To Use Vertical Spacing - Make Equal (1 replies)
  203. Solved: vlookup problems, even formatted as numbers (4 replies)
  204. Referenzen permanent verfügbar machen (5 replies)
  205. How to open Other file types (3 replies)
  206. Option Button first IF not working..... (5 replies)
  207. Bot (1 replies)
  208. Icon Librarys (2 replies)
  209. Professional Looking UI Forms (1 replies)
  210. Sleeper: The opposite of TRIM (2 replies)
  211. Running a function of another file (3 replies)
  212. Pivot Table Macro to lock manual filter/remove blank rows from datasheet (0 replies)
  213. Solved: vlookup not cooperating with other code (0 replies)
  214. Getting user to log changes before workbook is closed. (4 replies)
  215. Solved: Split Control (6 replies)
  216. Pass date as parameter (3 replies)
  217. Error message for missing data in userform (6 replies)
  218. Solved: Copy/Import based on Column Header Name (0 replies)
  219. Source Control Of Spreadsheets (6 replies)
  220. Returning Arrays From Functions (4 replies)
  221. VBA Code to Automate Grouping (3 replies)
  222. How do I disable inserting of rows? (1 replies)
  223. Preparation of excel spreadsheet data for google motion charts api (VBA?) (1 replies)
  224. Column Formatting Works in one instance, but not another (6 replies)
  225. How to deal with quotes within a string (1 replies)
  226. How to line up input boxes on forms? (3 replies)
  227. VBA Strongly Typed Arguments (4 replies)
  228. Get help for telling me how to code VBA to pass argument from Userform to worksheet (6 replies)
  229. Comparing data against table of values to output new data. (2 replies)
  230. [SOLVED:] EXCEL communicating with hyperterminal (6 replies)
  231. Listbox items from an array (10 replies)
  232. filter based on active cell (23 replies)
  233. Solved: Loop and Compare cell value & value returned from ado query (0 replies)
  234. Finding average of a range with macro (3 replies)
  235. Solved: Print Preview (2 replies)
  236. Naming ranges of cells using cell content (4 replies)
  237. Deleting All Shapes Deletes Data Validation Forms (6 replies)
  238. Separating prices by month (1 replies)
  239. Solved: Simple delete entire row (6 replies)
  240. How to extract data from Oracle Database into Excel Spreadsheet via VBA code (5 replies)
  241. Scrollbar (1 replies)
  242. Thank You VBA Express. (6 replies)
  243. Solved: how to wrap pages in multipage control (2 replies)
  244. Solved: write log of changes in workbook (7 replies)
  245. Userform in Defult text box (4 replies)
  246. Solved: Search Macro and Merged Cells (5 replies)
  247. [SOLVED:] Date format incorrect from Text File (11 replies)
  248. Invoice (35 replies)
  249. Solved: Select numerous cells from active cell (2 replies)
  250. Cascading Lists via VBA (2 replies)