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: Copy rows selectively (7 replies)
  2. VBA if..then comparison not working ??? (2 replies)
  3. Select or msgbox last cell edited by code? (3 replies)
  4. Solved: Compressing files (4 replies)
  5. Solved: Need Macro to pull data from Web (3 replies)
  6. Solved: Validating Excel data entry (5 replies)
  7. Solved: Creating Dynamic Validation Lists Based on A Selection from Another List (2 replies)
  8. Sending mails (0 replies)
  9. Solved: pivot table: sum column is incorrect (4 replies)
  10. pivot table and MS Queries (0 replies)
  11. Dropdowns and Zoom?? (1 replies)
  12. Environmental variables to get to ?My Docs? or "My Documents" location. (3 replies)
  13. Macro code to generate Email..help (2 replies)
  14. Excel 2007 Buttons in Print Preview Disabled (0 replies)
  15. Combo box (4 replies)
  16. Search a range of columns for values? (1 replies)
  17. Numbers Directory (2 replies)
  18. A Loop in a Loop (7 replies)
  19. Solved: Return DAY of Week based on Date (2 replies)
  20. Automatically Insert Hyperlink When Text Is Typed In Column (0 replies)
  21. Solved: Sort multi-dim array by one value? (4 replies)
  22. Solved: Backing Up in a Macro (6 replies)
  23. Button to unhide sheets (1 replies)
  24. Solved: Userform Commandbuttons query (3 replies)
  25. How to copy contents of text file to tab sheet of another excelsheet (2 replies)
  26. Solved: To check if to versions are identical (2 replies)
  27. Solved: Copy Paste in arranged manner (3 replies)
  28. Generate file name with date from cell (not current date) (3 replies)
  29. Using form to editing (10 replies)
  30. [SOLVED:] Compile error in hidden module: distMon (2 replies)
  31. Folder referance ? (6 replies)
  32. Solved: Conditional formatting not working unless I step into a cell (14 replies)
  33. For...Each Loop Backwards? (1 replies)
  34. Solved: Run macro in another workbook without its name (3 replies)
  35. Disable comments on mouse hover (2 replies)
  36. How to Retrieve the Last Search Term from Find() (0 replies)
  37. advanced find and replace loop (4 replies)
  38. [SLEEPER:] Ftp Folder (0 replies)
  39. Solved: Update buggy workbook links with .Activate (1 replies)
  40. Using Excel type formulae in VBA Forms (1 replies)
  41. [SOLVED:] VB code for greater than 1 or less than -1 (8 replies)
  42. [SOLVED:] Choose data for use in control limits (5 replies)
  43. Solved: Insert blank row below set value (6 replies)
  44. VBA help (0 replies)
  45. Creating fields (11 replies)
  46. [SLEEPER:] Even or odd week? (4 replies)
  47. [SLEEPER:] Display DownTimer in the UserForm & at the same time User should work with UserForm ? (4 replies)
  48. Solved: Match function in Vba (10 replies)
  49. Solved: Delete if matching colour (2 replies)
  50. ComboBox can't typing the value ? (1 replies)
  51. Solved: Redim Preserve (3 replies)
  52. [SOLVED:] UserForm help, assigning variable from option button selection (4 replies)
  53. Solved: Chose last of identical data from a column (4 replies)
  54. Use Find Across multiple workbooks/ multiple worksheet (4 replies)
  55. Solved: Counting different values (4 replies)
  56. Solved: Uhh... Corresponding number detection and copying (6 replies)
  57. Need Help (12 replies)
  58. Split range of cells into individual numbers? (1 replies)
  59. Receiving variables from a batch file (3 replies)
  60. Solved: Function/Sub with Parameters assigned to a Button (3 replies)
  61. Solved: Change font characteristics depending on value (2 replies)
  62. import large CSV file(more then 80k records) to MS Access table (1 replies)
  63. Delete Rows if Value in Column A (5 replies)
  64. Delete Sheets (1 replies)
  65. Solved: function match : error in vba (4 replies)
  66. Increment upper bound of loop (2 replies)
  67. Solved: x dimensions array, combobox and loop... (2 replies)
  68. making a "Formula like" userform (5 replies)
  69. Getting Error Message in Excel 2007 (2 replies)
  70. Solved: Referencing UDF from another workbook; Evaluate? (7 replies)
  71. Produce charts with range containing formula (1 replies)
  72. A Userform to enter data on a new line (25 replies)
  73. Please help me to write the code for this Excel-VBA problem? (5 replies)
  74. UDF Returns circular reference...? (1 replies)
  75. beforeclose, saving the workbook (1 replies)
  76. Solved: hiding columns (2 replies)
  77. Enter Formula in Cell Based on Heading in Another Cell (3 replies)
  78. VBA: If Date (range) Then (do this) (4 replies)
  79. Applying Template to Power Slides via Excel (0 replies)
  80. How can I create a Vlookup to certain columns in a closed workbook? (5 replies)
  81. How to replace Access data from EXCEL instead of adding to it? (2 replies)
  82. delay between codes (2 replies)
  83. Solved: Updating Excel Chart (2 replies)
  84. Solved: Check if data exists, then copy (11 replies)
  85. Solved: LOOKUP function not Functioning! (2 replies)
  86. Compare, Copy and Paste using VBA (20 replies)
  87. Broken macro - can't transfer from excel to access! (5 replies)
  88. how to optimise sumproduct function (13 replies)
  89. Solved: Excel Add-IN (4 replies)
  90. UserFrom if can edit (0 replies)
  91. Creating Addin that will work regardles saved folder location (15 replies)
  92. Creating buttons is very slow (1 replies)
  93. Send email notification when conditions are met (1 replies)
  94. Create a Letter and Label from Excel (2 replies)
  95. Active button coding (3 replies)
  96. Solved: beginning with userforms (4 replies)
  97. Copying from cells on same row selected by user (5 replies)
  98. chart base on category (0 replies)
  99. converting .ps to .pdf (0 replies)
  100. Solved: Numeric calculus for Matrices (11 replies)
  101. Solved: Excel macro to loop through rows, while looping format rows if meet criteria (11 replies)
  102. [SOLVED:] Split listbox text (5 replies)
  103. Problem with Range and Worksheets (1 replies)
  104. Solved: Function in add-in - How to reference workbook? (16 replies)
  105. Macro that automatically imports excel data into access database? (4 replies)
  106. Solved: [RESOLVED] Import a text file and keep the spaces (8 replies)
  107. Solved: Merge cells into one if value is smaller than... (2 replies)
  108. Javascript:_doPostback (11 replies)
  109. Search, copy, and paste (9 replies)
  110. Solved: Automatically Add Zeros in a cell (7 replies)
  111. Getting a line in a graph to change colors (3 replies)
  112. Fill data validation cell (4 replies)
  113. Solved: Regex Query (8 replies)
  114. ActiveCell.Text (2 replies)
  115. Solved: Print sheet in a loop procedure (5 replies)
  116. adding access levels (1 replies)
  117. getting string to resolve to variable (4 replies)
  118. Solved: Conditional Formatting for Numbers Only (3 replies)
  119. Copy multiple individual cells (24 replies)
  120. Random Combination (2 replies)
  121. flips left-to-right sequence of selected columns (8 replies)
  122. Disable macros on opening via Hyperlink (6 replies)
  123. Help Needed with Page Breaks (2 replies)
  124. Function does not output on Cells (7 replies)
  125. Solved: Headers & Footers - Multiple Sheets (6 replies)
  126. [SOLVED:] Creating Folders or Directories (6 replies)
  127. adding code in runtime (1 replies)
  128. Match 2 columns (1 replies)
  129. Image rendering in forms (5 replies)
  130. [SOLVED:] Create chart in seperated worksheet (6 replies)
  131. VBA Page Breaks in Excel (1 replies)
  132. Solved: macro to hide/unhide select cells (9 replies)
  133. Passing listbox values to cells (0 replies)
  134. Call Excel Solver from VBA (6 replies)
  135. Solved: Find and select a cell based on user input (6 replies)
  136. Solved: Copy information to an Activecell that Moves (8 replies)
  137. what does ^ mean in the formula (3 replies)
  138. Solved: Macro:To Many End With's (5 replies)
  139. Optimizing loop for find&delete shift column (8 replies)
  140. Creating Add-ins (7 replies)
  141. add function on print (3 replies)
  142. Solved: Select range by used rows and named range (10 replies)
  143. Excel - 2003 VBA Code Error - Run time error '380':Invalid Property (2 replies)
  144. Solved: Set variable to a cell address (6 replies)
  145. Solved: Multiline Textbox to Populate Multiple Cells (7 replies)
  146. Help with code for data entry (26 replies)
  147. Solved: Help on changing the year (6 replies)
  148. Macro to open workbook from another workbook (2 replies)
  149. [SLEEPER:] Send cell contents in email message body (2 replies)
  150. Solved: Select All Pictures, And Move And Size with cells (4 replies)
  151. Solved: Ideas to make this code faster (3 replies)
  152. Solved: Moving from 2003 to 2007 (8 replies)
  153. Solved: CountIF to find Average using VBA (12 replies)
  154. Solved: Delete Row but store a value first!! (10 replies)
  155. How to draw a vertical and horizontal line on a line-plot (3 replies)
  156. Horrible Listview problem... (2 replies)
  157. Code Wants help (5 replies)
  158. Conditional formatting in vba (more than three) select values from a worksheet (2 replies)
  159. Solved: macro to list unique data in a column (2 replies)
  160. Help with Macro code (8 replies)
  161. Solved: Opening unknown File names in known Folder (4 replies)
  162. Solved: problem with resize and autofill (2 replies)
  163. User Def Function to only act on active workbook (3 replies)
  164. Code using date not saving the result of output (14 replies)
  165. [SOLVED:] Creating Pareto Chart (20 replies)
  166. [SOLVED:] Quick question about loops (3 replies)
  167. Caopying and Pasting While Retaining the Original Cell Reference (5 replies)
  168. [SOLVED:] Word bookmark Help (8 replies)
  169. FileCopy to Network Drive (13 replies)
  170. CSV Import Issues (3 replies)
  171. Paste Copy special Value (5 replies)
  172. Solved: Automatically change font size (2 replies)
  173. Solved: Accounting format (2 replies)
  174. Userform will not Show after being Hidden (3 replies)
  175. Solved: Create New Sheet Based on Value In Column (7 replies)
  176. Copy, Find and add offset cell values (0 replies)
  177. Trim cells in variable range (1 replies)
  178. Getting a range to work in my vba code (4 replies)
  179. Solved: If value not found go to next cell (5 replies)
  180. Solved: Label blinking in the UserForm (1 replies)
  181. How to create a message box depending on values of the cell? Toughie =/ (10 replies)
  182. Solved: Userform Quick Q (2 replies)
  183. Tracking Changes / Sharing a workbook (6 replies)
  184. Looping through Range Vs Ranges (15 replies)
  185. Extract data from columns [sum] (1 replies)
  186. Solved: Renaming folder files (2 replies)
  187. Solved: Find unique values (3 replies)
  188. Solved: NETWORKDAYS formula amendment (8 replies)
  189. Form, listbox and multilines problem (1 replies)
  190. Solved: Changing TreeView Node Detail with Userform TextBox (2 replies)
  191. Solved: Adding rows with preconditioned cells (9 replies)
  192. Solved: How to re-apply named ranges (24 replies)
  193. Solved: Re: Shared Workbooks (2 replies)
  194. Command button to Hide/Unhide tabs (4 replies)
  195. Navigation menu to only show visible tabs (4 replies)
  196. Solved: Populate list box from selection in another. (2 replies)
  197. Generate random numbers based on odds (1 replies)
  198. Solved: Spell Check Unlocked Cells on Protected Sheet (1 replies)
  199. Solved: data going to wrong cell (4 replies)
  200. Solved: Formula help (2 replies)
  201. Function returning Arrays (3 replies)
  202. Difficult: Sum of days in consecutive months based on multiple criteria (7 replies)
  203. Which control does this? (2 replies)
  204. Quicker way to write a bunch of formulas?? (1 replies)
  205. Solved: Help with Experimental Grade Sheet (9 replies)
  206. Seperating records with a blank line (3 replies)
  207. Manipulating Arrays Using VBA (2 replies)
  208. For Each.. loop decisions (3 replies)
  209. Solved: Copy from one xls to other avoiding highlighted cells (6 replies)
  210. Amend VBA Code (2 replies)
  211. combo box help (1 replies)
  212. Excel in neverending loop (2 replies)
  213. Copy and paste withi selected range (12 replies)
  214. Solved: Importing multiple space delimited text file (6 replies)
  215. arranging data redux (4 replies)
  216. saving a backup file (2 replies)
  217. Split Cells help (9 replies)
  218. Solved: "Pick and choose" series to display on embedded chart (5 replies)
  219. Complie if error (5 replies)
  220. looping code with if's (0 replies)
  221. Solved: Camera tool use with picture object (6 replies)
  222. Solved: modifying existing chart Sourch data (5 replies)
  223. Creating a User controlled pause in VBA (2 replies)
  224. Downloading many html web pages, converting to text, then parsing out (5 replies)
  225. Ref Edit Control Missing (1 replies)
  226. EXCEL USING IF THEN STATEMENT (3 replies)
  227. Listbox Limit!! (4 replies)
  228. Move over Picture (1 replies)
  229. Using VBA for conditional Formatting (2 replies)
  230. Solved: save and rename workbook everyday at a given time (1 replies)
  231. Solved: How to check the type of an array (2 replies)
  232. question about forcemacros (1 replies)
  233. Linked Picture to be centred on Screen (8 replies)
  234. change part of a string (1 replies)
  235. Prevent 1004 Error For Select Method (11 replies)
  236. Using Formula To Find Last Used Column? (9 replies)
  237. lookup and conditional formatting with VBA (17 replies)
  238. TextBox Help (1 replies)
  239. Access Filter Criteria from Excel (0 replies)
  240. Solved: help optimizing case select (4 replies)
  241. Solved: userform and function call (3 replies)
  242. Solved: Generate numbers 1 - 90 for bingo (10 replies)
  243. Writing Excel cells with VBA variables (13 replies)
  244. Solved: Show current users on userform (2 replies)
  245. vb and command button help (3 replies)
  246. storing value, making registration tool (4 replies)
  247. [SOLVED:] Application.match failing (4 replies)
  248. Solved: add data based upon created categories (10 replies)
  249. progress bar is frozen (9 replies)
  250. Function returns empty array (9 replies)