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. Problems with FileCopy and Wb(name).close (11 replies)
  2. Solved: insert code to show progress (3 replies)
  3. add extra step to macro (4 replies)
  4. Appends the contents to the respective columns (6 replies)
  5. auto print (2 replies)
  6. Dynamic Range over extending issue (10 replies)
  7. How to write a VBA-Excel code to find geometric mean? (4 replies)
  8. Solved: I want to go to "File Save As" as soon as openned (7 replies)
  9. Solved: Days Difference between text box (6 replies)
  10. Row & Column Indicators (4 replies)
  11. Solved: sort ascending leaves blanks at the top (5 replies)
  12. Extracting information after B/C (1 replies)
  13. Multi Tracker Entry Help (13 replies)
  14. Checkboxes and Sheet Protection (4 replies)
  15. [SOLVED:] What is escape character for quotation marks? (4 replies)
  16. Solved: Extracting only part which is within brackats (4 replies)
  17. Solved: PLEASE: Chart Help (2 replies)
  18. Solved: Sub to Open workbooks, and update named ranges (5 replies)
  19. Solved: VBA hide columns or rows based on certain criteria (13 replies)
  20. Solved: UDF to convert long date to "mmmyy" String (7 replies)
  21. Solved: Creating A Shortcut Key (3 replies)
  22. Number of Objects Limitation in Sheet (2 replies)
  23. UserForm: Initialize a ListBox (3 replies)
  24. Excel VBA:ZeroPadding Mixed Number, Text, Number Content in Cell (4 replies)
  25. Shared Workbook Woes (5 replies)
  26. A reminder please, copying range from one ws to another (2 replies)
  27. Solved: sumif feature needed for multiple criteria using wildcards (4 replies)
  28. Running a User Defined Function in VBA (8 replies)
  29. Solved: Copy and Paste - File to File (All files are Password Protected) (7 replies)
  30. Solved: Check cells in an AutoFiltered Range (2 replies)
  31. Solved: Insert blank row, NOT "insert copied cells" (2 replies)
  32. Conditional Formatting with command button (5 replies)
  33. Solved: 2D Arrays (10 replies)
  34. Fix data position (1 replies)
  35. Solved: Writing to a word file from within excel (10 replies)
  36. Help! Excel User prompt for data input (8 replies)
  37. Solved: SUBTOTAL COUNT (10 replies)
  38. Solved: copy contents of one workbook into another (7 replies)
  39. Date format (3 replies)
  40. Dynamic Form CheckBoxes Controlls (3 replies)
  41. Solved: Returning data based on multiple criteria (8 replies)
  42. Convert to PDF on Legal Size Paper (2 replies)
  43. Adding multiple entries to Time Sheet (4 replies)
  44. Excel 2007 template - issue with vba macros (emailing) (0 replies)
  45. Use text from embedded object (0 replies)
  46. Solved: Run-time error '53': File Not Found (3 replies)
  47. Solved: Combine H and V lookup or better idea? (2 replies)
  48. Copying values (5 replies)
  49. getting a Macro not to call another macro ?? (1 replies)
  50. Excel File Sharing Communication Tool (4 replies)
  51. Solved: Returning an array from a function (6 replies)
  52. Using VBA to copy and paste the content of multiple worksheets to a new files (14 replies)
  53. Solved: vlookup non-contiguous ranges (7 replies)
  54. Solved: Preventing N/A# in Vlookup? (2 replies)
  55. Linked Picture; Add to Comment (14 replies)
  56. vlookup in Vba + preventing tabulations in a form field (2 replies)
  57. Enable paste (6 replies)
  58. [SOLVED:] Help Alter Code (1 replies)
  59. Solved: Excel Charts again (1 replies)
  60. Solved: pb: if condition = true then go to next iteration (2 replies)
  61. problem with combobox (4 replies)
  62. ERROr while running a macro (5 replies)
  63. vba if statement (14 replies)
  64. Solved: swicthing between formulas (5 replies)
  65. Putting variable values in a second sheet (3 replies)
  66. [SLEEPER:] How to automatically trigger a VBA code to respond to expected msgbox (9 replies)
  67. Solved: Worksheet freezes up (3 replies)
  68. Solved: Multiple 'On Error' commands in function doesn't work? (2 replies)
  69. Alpha Testers Wanted (5 replies)
  70. Why is this chunk of code freezing (5 replies)
  71. Copy Paste toggle not working (1 replies)
  72. Solved: Image to Excel (1 replies)
  73. auto filter (4 replies)
  74. BO reports (rep files) need to be refreshed from Excel Module (3 replies)
  75. Excel Chart Lists (0 replies)
  76. Solved: sort without worksheet? (2 replies)
  77. Solved: Using IsInPlace (1 replies)
  78. Why my program gets slow down after running for a while (6 replies)
  79. Why does .address put $ in value (1 replies)
  80. Charting an array as a series (3 replies)
  81. Autofill not working (3 replies)
  82. VBA Code for mail merger & Printing (3 replies)
  83. Copy row from workbook if... (2 replies)
  84. How to write a formula with a bunch of 'IF' statements (7 replies)
  85. Macros Paste Special to another Workbook (2 replies)
  86. Print ranges on worksheet (2 replies)
  87. User Forms behaving strangely (7 replies)
  88. Need help to get rid of unwanted " in text output file from an excel macro (2 replies)
  89. [SOLVED:] How to find the first and last row of merge Cells??? (3 replies)
  90. Solved: Save specific cells in Excel with a Macro (15 replies)
  91. Refreshing data from multiple large workbooks (11 replies)
  92. Solved: sum values based upon 2 or 3 conditions (4 replies)
  93. Image as Multipage Caption (3 replies)
  94. Excel - Email Groupwise HTML (1 replies)
  95. Create a consecutive character array? (3 replies)
  96. Update Checkbox across workbooks (2 replies)
  97. Solved: Trying to uninstall addin when closing file (3 replies)
  98. Solved: Form-Filling GUI: ComboBox problem (8 replies)
  99. Solved: Copy rows selectively (7 replies)
  100. VBA if..then comparison not working ??? (2 replies)
  101. Select or msgbox last cell edited by code? (3 replies)
  102. Solved: Compressing files (4 replies)
  103. Solved: Need Macro to pull data from Web (3 replies)
  104. Solved: Validating Excel data entry (5 replies)
  105. Solved: Creating Dynamic Validation Lists Based on A Selection from Another List (2 replies)
  106. Sending mails (0 replies)
  107. Solved: pivot table: sum column is incorrect (4 replies)
  108. pivot table and MS Queries (0 replies)
  109. Dropdowns and Zoom?? (1 replies)
  110. Environmental variables to get to ?My Docs? or "My Documents" location. (3 replies)
  111. Macro code to generate Email..help (2 replies)
  112. Excel 2007 Buttons in Print Preview Disabled (0 replies)
  113. Combo box (4 replies)
  114. Search a range of columns for values? (1 replies)
  115. Numbers Directory (2 replies)
  116. A Loop in a Loop (7 replies)
  117. Solved: Return DAY of Week based on Date (2 replies)
  118. Automatically Insert Hyperlink When Text Is Typed In Column (0 replies)
  119. Solved: Sort multi-dim array by one value? (4 replies)
  120. Solved: Backing Up in a Macro (6 replies)
  121. Button to unhide sheets (1 replies)
  122. Solved: Userform Commandbuttons query (3 replies)
  123. How to copy contents of text file to tab sheet of another excelsheet (2 replies)
  124. Solved: To check if to versions are identical (2 replies)
  125. Solved: Copy Paste in arranged manner (3 replies)
  126. Generate file name with date from cell (not current date) (3 replies)
  127. Using form to editing (10 replies)
  128. Solved: Compile error in hidden module: distMon (2 replies)
  129. Folder referance ? (6 replies)
  130. Solved: Conditional formatting not working unless I step into a cell (14 replies)
  131. For...Each Loop Backwards? (1 replies)
  132. Solved: Run macro in another workbook without its name (3 replies)
  133. Disable comments on mouse hover (2 replies)
  134. How to Retrieve the Last Search Term from Find() (0 replies)
  135. advanced find and replace loop (4 replies)
  136. Ftp Folder (0 replies)
  137. Solved: Update buggy workbook links with .Activate (1 replies)
  138. Using Excel type formulae in VBA Forms (1 replies)
  139. Solved: VB code for greater than 1 or less than -1 (8 replies)
  140. Solved: Choose data for use in control limits (5 replies)
  141. Solved: Insert blank row below set value (6 replies)
  142. VBA help (0 replies)
  143. Creating fields (11 replies)
  144. [SLEEPER:] Even or odd week? (4 replies)
  145. Display DownTimer in the UserForm & at the same time User should work with UserForm ? (4 replies)
  146. Solved: Match function in Vba (10 replies)
  147. Solved: Delete if matching colour (2 replies)
  148. ComboBox can't typing the value ? (1 replies)
  149. Solved: Redim Preserve (3 replies)
  150. UserForm help, assigning variable from option button selection (4 replies)
  151. Solved: Chose last of identical data from a column (4 replies)
  152. Use Find Across multiple workbooks/ multiple worksheet (4 replies)
  153. Solved: Counting different values (4 replies)
  154. Solved: Uhh... Corresponding number detection and copying (6 replies)
  155. Need Help (12 replies)
  156. Split range of cells into individual numbers? (1 replies)
  157. Receiving variables from a batch file (3 replies)
  158. Solved: Function/Sub with Parameters assigned to a Button (3 replies)
  159. Solved: Change font characteristics depending on value (2 replies)
  160. import large CSV file(more then 80k records) to MS Access table (1 replies)
  161. Delete Rows if Value in Column A (5 replies)
  162. Delete Sheets (1 replies)
  163. Solved: function match : error in vba (4 replies)
  164. Increment upper bound of loop (2 replies)
  165. Solved: x dimensions array, combobox and loop... (2 replies)
  166. making a "Formula like" userform (5 replies)
  167. Getting Error Message in Excel 2007 (2 replies)
  168. Solved: Referencing UDF from another workbook; Evaluate? (7 replies)
  169. Produce charts with range containing formula (1 replies)
  170. A Userform to enter data on a new line (25 replies)
  171. Please help me to write the code for this Excel-VBA problem? (5 replies)
  172. UDF Returns circular reference...? (1 replies)
  173. beforeclose, saving the workbook (1 replies)
  174. Solved: hiding columns (2 replies)
  175. Enter Formula in Cell Based on Heading in Another Cell (3 replies)
  176. VBA: If Date (range) Then (do this) (4 replies)
  177. Applying Template to Power Slides via Excel (0 replies)
  178. How can I create a Vlookup to certain columns in a closed workbook? (5 replies)
  179. How to replace Access data from EXCEL instead of adding to it? (2 replies)
  180. delay between codes (2 replies)
  181. Solved: Updating Excel Chart (2 replies)
  182. Solved: Check if data exists, then copy (11 replies)
  183. Solved: LOOKUP function not Functioning! (2 replies)
  184. Compare, Copy and Paste using VBA (20 replies)
  185. Broken macro - can't transfer from excel to access! (5 replies)
  186. how to optimise sumproduct function (13 replies)
  187. Solved: Excel Add-IN (4 replies)
  188. UserFrom if can edit (0 replies)
  189. Creating Addin that will work regardles saved folder location (15 replies)
  190. Creating buttons is very slow (1 replies)
  191. Send email notification when conditions are met (1 replies)
  192. Create a Letter and Label from Excel (2 replies)
  193. Active button coding (3 replies)
  194. Solved: beginning with userforms (4 replies)
  195. Copying from cells on same row selected by user (5 replies)
  196. chart base on category (0 replies)
  197. converting .ps to .pdf (0 replies)
  198. Solved: Numeric calculus for Matrices (11 replies)
  199. Solved: Excel macro to loop through rows, while looping format rows if meet criteria (11 replies)
  200. [SOLVED:] Split listbox text (5 replies)
  201. Problem with Range and Worksheets (1 replies)
  202. Solved: Function in add-in - How to reference workbook? (16 replies)
  203. Macro that automatically imports excel data into access database? (4 replies)
  204. Solved: [RESOLVED] Import a text file and keep the spaces (8 replies)
  205. Solved: Merge cells into one if value is smaller than... (2 replies)
  206. Javascript:_doPostback (11 replies)
  207. Search, copy, and paste (9 replies)
  208. Solved: Automatically Add Zeros in a cell (7 replies)
  209. Getting a line in a graph to change colors (3 replies)
  210. Fill data validation cell (4 replies)
  211. Solved: Regex Query (8 replies)
  212. ActiveCell.Text (2 replies)
  213. Solved: Print sheet in a loop procedure (5 replies)
  214. adding access levels (1 replies)
  215. getting string to resolve to variable (4 replies)
  216. Solved: Conditional Formatting for Numbers Only (3 replies)
  217. Copy multiple individual cells (24 replies)
  218. Random Combination (2 replies)
  219. flips left-to-right sequence of selected columns (8 replies)
  220. Disable macros on opening via Hyperlink (6 replies)
  221. Help Needed with Page Breaks (2 replies)
  222. Function does not output on Cells (7 replies)
  223. Solved: Headers & Footers - Multiple Sheets (6 replies)
  224. Solved: Creating Folders or Directories (6 replies)
  225. adding code in runtime (1 replies)
  226. Match 2 columns (1 replies)
  227. Image rendering in forms (5 replies)
  228. Solved: create chart in seperated worksheet (6 replies)
  229. VBA Page Breaks in Excel (1 replies)
  230. Solved: macro to hide/unhide select cells (9 replies)
  231. Passing listbox values to cells (0 replies)
  232. Call Excel Solver from VBA (6 replies)
  233. Solved: Find and select a cell based on user input (6 replies)
  234. Solved: Copy information to an Activecell that Moves (8 replies)
  235. what does ^ mean in the formula (3 replies)
  236. Solved: Macro:To Many End With's (5 replies)
  237. Optimizing loop for find&delete shift column (8 replies)
  238. Creating Add-ins (7 replies)
  239. add function on print (3 replies)
  240. Solved: Select range by used rows and named range (10 replies)
  241. Excel - 2003 VBA Code Error - Run time error '380':Invalid Property (2 replies)
  242. Solved: Set variable to a cell address (6 replies)
  243. Solved: Multiline Textbox to Populate Multiple Cells (7 replies)
  244. Help with code for data entry (26 replies)
  245. Solved: Help on changing the year (6 replies)
  246. Macro to open workbook from another workbook (2 replies)
  247. Send cell contents in email message body (2 replies)
  248. Solved: Select All Pictures, And Move And Size with cells (4 replies)
  249. Solved: Ideas to make this code faster (3 replies)
  250. Solved: Moving from 2003 to 2007 (8 replies)