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. need a method to create a chart (0 replies)
  2. Create New Workbook VB (15 replies)
  3. click web link (0 replies)
  4. Solved: Vlookup Help (9 replies)
  5. Solved: Changing to Button (2 replies)
  6. Solved: Preventing Excution of Command (3 replies)
  7. Worksheet.Protection userinterfaceonly:=true problem (3 replies)
  8. Solved: Concatenation of columns (5 replies)
  9. Solved: Multiple formulas in a single cell... (7 replies)
  10. create file as shared (0 replies)
  11. import txt to excel with VBA (7 replies)
  12. How to disable spell checker in Lotus Notes using VBA (0 replies)
  13. Help on some VBA (12 replies)
  14. Listing the Computers list in a specific OU in a active directory (1 replies)
  15. click website link (4 replies)
  16. default property of a class (2 replies)
  17. "clear" button not working (13 replies)
  18. Solved: Chart using VBA (2 replies)
  19. Time calculation (3 replies)
  20. Prevent users to leave blank cells before leaving the worksheet (16 replies)
  21. Solved: read from list and delete rows if cells contains expression from that list (12 replies)
  22. Solved: Protection issue with comments (10 replies)
  23. Error 1004 - Method 'Name' of object '_Worksheet' failed (9 replies)
  24. [SLEEPER:] Extracting data from emulator with excel (3 replies)
  25. Solved: Print ranges in workheets (2 replies)
  26. Solved: Converting USD to IDR and Sum itself (2 replies)
  27. [SOLVED:] Character adding (9 replies)
  28. [SLEEPER:] Calling Multiple Subs within A Sub - Having Issues (3 replies)
  29. Export Excel to .txt (5 replies)
  30. Modifying Pivot Tables programattically (0 replies)
  31. Impact on Performance of VBA based applications with VBE open! (4 replies)
  32. Solved: For loop, counter (4 replies)
  33. Solved: Conditional Formating or VBA? (2 replies)
  34. Excel Macro to find records exist in workbook (3 replies)
  35. Solved: Macro to Sum values in Range to new Column (6 replies)
  36. move negative sign to the front (4 replies)
  37. Solved: Make code more efficient (2 replies)
  38. Solved: Flag based on Criteria (9 replies)
  39. If...Then Execute Command (2 replies)
  40. Copy Selected Range as picture and add to email (7 replies)
  41. Macro - if red text then multiply by -1 (4 replies)
  42. Solved: Lock sheet (non-viewable) error (6 replies)
  43. Solved: why is this VBA code slow? (3 replies)
  44. Solved: Sort columns (2 replies)
  45. [SOLVED:] Place a subroutine name in a var (5 replies)
  46. Solved: Locking cells dependent on other cells (1 replies)
  47. Run Macros/Commands on different worksheets (17 replies)
  48. condtional formatting (1 replies)
  49. Comparing Data on two sheets (17 replies)
  50. Solved: Remove A Fraction Of A Range From A Range Variable (14 replies)
  51. How to call search function in excel using code (4 replies)
  52. Solved: Dynamic Range: Re-post (3 replies)
  53. copy paste looping between Ppt and Excel (0 replies)
  54. Solved: Dynamic Range (2 replies)
  55. Solved: VBA Help (9 replies)
  56. Stopwatch (11 replies)
  57. Solved: DynamicColumn Count (2 replies)
  58. deleting the last 5 digits per cell (2 replies)
  59. Executing Multiple SQL statements in Excel (3 replies)
  60. Solved: how do i merge two formulas (2 replies)
  61. Solved: Clear out Column when finished (4 replies)
  62. combining row data to make a label (9 replies)
  63. Extend conditional formatting with formula (1 replies)
  64. USB Communication (2 replies)
  65. Formula Help - Urgent (0 replies)
  66. Trying to deselect pivot items (0 replies)
  67. Solved: Why does my date change ? (2 replies)
  68. Solved: convert time (6 replies)
  69. [SOLVED:] Where and how to enter an Excel formula (10 replies)
  70. [SLEEPER:] Resizing borders (2 replies)
  71. Solved: countif problems (11 replies)
  72. Evaluate Cell --- for Data validation Drop down list (4 replies)
  73. VBA/Excel & SPSS (1 replies)
  74. Excel 2007 on Win XP Selected Cells Color (2 replies)
  75. [SOLVED:] Alignment of many controls on user form (3 replies)
  76. Pixel to Point ratio (2 replies)
  77. Solved: Hi Experts (8 replies)
  78. Solved: What Does "Me" Mean? (6 replies)
  79. Solved: Option buttons in outlook from VBA (7 replies)
  80. Using VBA to Enter Data into a Cell produces #DIV/0! Error (1 replies)
  81. No result when copying from workbook to workbook (5 replies)
  82. Image display while generating email in outlook using excel (2 replies)
  83. VBA - Find, Copy then Paste Special (4 replies)
  84. XMLHTTP connection timeout (6 replies)
  85. SEND EMAIL DUE DATES WITH FORMULAS IN SPREADSHEET (0 replies)
  86. If statement to run a module (0 replies)
  87. macro to remove headers in a multiple sheet spreadsheet (9 replies)
  88. Can I delete a control from a running form with code? (4 replies)
  89. Excel Macro help (4 replies)
  90. I'm a beginner, and even this program is driving me crazy (10 replies)
  91. Using list of locations, open excel files, extract data to new spreasheeet (0 replies)
  92. Solved: Possible Vlookup or Index/Match formula help (3 replies)
  93. multiple questions about listboxes (2 replies)
  94. macro help (2 replies)
  95. Find and Delete Multiple Rows based on Criteria (3 replies)
  96. Solved: Save only if path is true (4 replies)
  97. Solved: Copy fixed 3 cells from multiple files with 1 or 2 or 3 sheets (5 replies)
  98. Solved: Is this a Vlookup problem? (4 replies)
  99. Get values from excel in other machine (3 replies)
  100. Solved: Array help? (12 replies)
  101. [SLEEPER:] Paste to unused field (3 replies)
  102. Determining if a date meets a criteria (2 replies)
  103. Solved: Auto Numbering Requirement (6 replies)
  104. Copy columns based on cell value (1 replies)
  105. Solved: Don't allow user to delete formula in Validation (2 replies)
  106. [SOLVED:] Error Handler: Pass the Calling Macro Info (7 replies)
  107. Solved: Create Validation List In Next Cell (3 replies)
  108. Error: 'Cannot find project or library'. 2002/200 compatibility error? (8 replies)
  109. Solved: Creating Dynamic Named Range (1 replies)
  110. Paste Picture based on cell value (18 replies)
  111. I want to send a pic as an email attachment (0 replies)
  112. click link in web page (4 replies)
  113. Solved: Copy row with condition thru userform (2 replies)
  114. Recovering conditional Formatting after running Macro (1 replies)
  115. Find & Replace VBA help (1 replies)
  116. Solved: Two Vlookup's in one cell (3 replies)
  117. filtering data from two or more sheets (2 replies)
  118. [SOLVED:] Remove Excel Userform Using VBA (9 replies)
  119. Solved: Lost Focus (7 replies)
  120. Solved: Fill an Array based on Range Values (8 replies)
  121. Using Countif in VBA (2 replies)
  122. 2 sheets, matching many:1 date fields, copy value if true (1 replies)
  123. Quickly Delete or Hide Rows if Column N is blank (1 replies)
  124. Solved: switching between yes and no using data validation (2 replies)
  125. Solved: Split 1 Cell into 2 cells (2 replies)
  126. Help with storing varaible value to use later (2 replies)
  127. Solved: How to hide Formulas (6 replies)
  128. Only allow one input at any given time (3 replies)
  129. VBA to Set a sheetname as a Variable and call from another workBook (9 replies)
  130. [SLEEPER:] How to do multiple vlookups? (5 replies)
  131. Solved: Copy entire row to new worksheet on found cell (3 replies)
  132. Solved: Help to imrove the coding (4 replies)
  133. Solved: For Statement Inside Select Statement (4 replies)
  134. random columns to be copied (5 replies)
  135. S: Graph Whole Row but automatically omit columns with no data and do not graph these (5 replies)
  136. Solved: WITH statement must be inside Do...Loop? (3 replies)
  137. Solved: Insert Rows basis value in Cell (7 replies)
  138. Solved: VBA saving macro (1 replies)
  139. Displaying data from worksheet range in listbox (4 replies)
  140. Irregular do loops (5 replies)
  141. Can you use variable to change caption on command button (1 replies)
  142. Capturing headings of frequent data (0 replies)
  143. Pasting a worksheet to another worsheet in another workbook (0 replies)
  144. VBA userforms, control is command button is visible (7 replies)
  145. Display special values in Column B (2 replies)
  146. txt list function excluding zero (1 replies)
  147. Solved: calculating a %, based on the bg color of a cell (3 replies)
  148. [SOLVED:] Countname function (3 replies)
  149. [SOLVED:] Vlookup Sum help (2 replies)
  150. Calculating Days and Inactivating the columns (5 replies)
  151. Solved: move data in Excel (2 replies)
  152. Solved: Update worksheet data through userform (4 replies)
  153. If statement for Cells.Find (5 replies)
  154. Dynamic Sheets (9 replies)
  155. Solved: function to calculate average (4 replies)
  156. Button loses connection to macro when I "Save As". (5 replies)
  157. save as csv file codepage problem (7 replies)
  158. [SOLVED:] How to see when was a workbook last time opened (2 replies)
  159. Reading .txt Files (7 replies)
  160. [SLEEPER:] My macro stops half way through because of a dialog box (4 replies)
  161. Macro for refresh (0 replies)
  162. countdown timer (2 replies)
  163. Solved: Find Replace Macro for Selection (2 replies)
  164. Loop Conditional Statement through 2 columns and Copy/Paste from corresponding column (1 replies)
  165. Solved: Calling a sub procedure using variables from another sub procedure (10 replies)
  166. Solved: Special Cells - Count (8 replies)
  167. Synchrinizing excel file (15 replies)
  168. Solved: VBA to hide unrequired sheets? (3 replies)
  169. Solved: Prevent users from entering "Essential Position" in more than one worksheet (3 replies)
  170. Solved: Populate Combobox with spreadsheet col (7 replies)
  171. Solved: Multiple option buttons on user form (8 replies)
  172. update master worksheet from multiple workbooks (0 replies)
  173. Solved: Summing tasks for a Month period (2 replies)
  174. how to add columns from other excel files (3 replies)
  175. Solved: Excel VBA Groupwise (File names) (4 replies)
  176. Custom data transfer based on criteria (2 replies)
  177. Solved: Custom toolbar for use in all instances of Excel (3 replies)
  178. Select Unique values from a coulmn (1 replies)
  179. Solved: Where did the 07 known issues thrd go? (7 replies)
  180. How to remove protection password using Macro (3 replies)
  181. How to inser Row using VB (5 replies)
  182. [SOLVED:] Solved: Help with random sampling code (2 replies)
  183. Forget Password (3 replies)
  184. VBA combo-box printing pdfs (2 replies)
  185. VBA Error Subscript Out of Range (6 replies)
  186. Select last active cell, offset (-50, 0) copy (2 replies)
  187. ZIP the files using VBA (4 replies)
  188. Solved: Advanced Filter with empty cells (8 replies)
  189. Solved: Worksheet Function Compile Error (1 replies)
  190. Vb Error Prompt (7 replies)
  191. cell reference from one sheet to another (8 replies)
  192. Solved: Delete sheet greyed out (1 replies)
  193. Can't name a command button with code (0 replies)
  194. Solved: Fill the blank cell (3 replies)
  195. Formulas to measuer four two criterias (9 replies)
  196. File Access (3 replies)
  197. Problem pasting a Picture into an image control (0 replies)
  198. inserting rows (6 replies)
  199. Right Click Menu of Sheet tab (4 replies)
  200. save function not working properly (2 replies)
  201. [SOLVED:] Unmerge cells & Auto-fills (6 replies)
  202. [SOLVED:] Copy/Move Worksheet (1 replies)
  203. Modify Variables in One Workbook from another Workbook? (1 replies)
  204. How to create in excel a form with a menu? (19 replies)
  205. Solved: clear clipboard before closing excel (2 replies)
  206. [SOLVED:] Last Saved Information (4 replies)
  207. Solved: Problem in append data to next column (2 replies)
  208. Solved: getting values from files with changing names (9 replies)
  209. Can i use arrays here? (3 replies)
  210. Solved: Workbook Save Flag (4 replies)
  211. Merging two sheets (14 replies)
  212. How to add only 1 worksheet from an Add-in (5 replies)
  213. Get email address of the user log from excel vba (2 replies)
  214. populate list/combobox without duplicates (3 replies)
  215. Solved: Charts automation using vba, works with Excel 2007 but error with 2003. (4 replies)
  216. How to exit print preview mode? (3 replies)
  217. MULTIPLE CONDITIONAL FORMAT WITH FORMULA IN PIVOT TABLE (0 replies)
  218. macro to perform selective addition (0 replies)
  219. Check Version & Download Latest (4 replies)
  220. Sequence two or more loops - VBA code (2 replies)
  221. Filter the specific data and find the difference (8 replies)
  222. Solved: Complete excel sheet on command (4 replies)
  223. Solved: Filtering Columns (7 replies)
  224. How to avoid displaying a warning box on save? (5 replies)
  225. Solved: Using Comments to Document Formula (2 replies)
  226. How to format cells in one row (2 replies)
  227. Problems creating large numbers of sheets (7 replies)
  228. Solved: import and split a text file into worksheets by year (6 replies)
  229. Fill down formula with data pivot change (0 replies)
  230. tracking changes (3 replies)
  231. need help in excel sort (6 replies)
  232. Solved: Max Values - Formula solution (2 replies)
  233. Changing named range in loop (3 replies)
  234. Hide Checkboxes based on last column (4 replies)
  235. FTP an Excel File (3 replies)
  236. Using name ranges with sumproduct? (6 replies)
  237. Solved: Max Value and the date it occurred? (13 replies)
  238. Solved: validate Combo boxes (2 replies)
  239. Solved: Point And Figure Chart (10 replies)
  240. Solved: Parsing a field (4 replies)
  241. Aligning a chart to cells code (3 replies)
  242. Solved: Filter by Date Selection? (8 replies)
  243. copy contents of csv files (6 replies)
  244. Solved: Function Required for Mega Formula (9 replies)
  245. Paste the content from Excel to UserForm -> TextBox (4 replies)
  246. Userform Spinbutton to advance row and refresh (1 replies)
  247. Using Excel 07 for complex web queries? (10 replies)
  248. [SLEEPER:] Merge / Combine Multiple workbooks (3 replies)
  249. Solved: calculate percentages using sumproduct? (8 replies)
  250. Solved: Reference another Excel workbook without Activating it (3 replies)