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: command for Sheets("All")?? (11 replies)
  2. Solved: Expand/Contract a User Form (3 replies)
  3. Save a single sheet (4 replies)
  4. Solved: File name in status bar (3 replies)
  5. Solved: date format problem with macro.... (6 replies)
  6. Solved: Looping through all workbooks in a folder? (5 replies)
  7. Special type of excel files (3 replies)
  8. Solved: File Save As (11 replies)
  9. Import a plain file of data into tab (4 replies)
  10. Solved: Formulas, Code, and my ignorance.... (6 replies)
  11. Sorting through two lists (3 replies)
  12. VBA Duplicate Name Check and Calculating the Values (22 replies)
  13. Solved: VBA Macros Problem (20 replies)
  14. [SOLVED:] Add Border to last Row (11 replies)
  15. [SOLVED:] Loop Through WorkSheets: Help Needed (14 replies)
  16. save excel file with different icon (1 replies)
  17. VBA problem (0 replies)
  18. Solved: MS Query and Excel (0 replies)
  19. Excel Formatting in VBA (0 replies)
  20. Excel Formula (11 replies)
  21. Time Capture To Log Files using VBA (8 replies)
  22. Find and subtract (4 replies)
  23. Solved: Sending an email from excel (11 replies)
  24. Solved: Setting a benchmark line in an excel bar graph (3 replies)
  25. [SOLVED:] Return true or false if defined name is there? (2 replies)
  26. VBA to extract data from 2 excels (2 replies)
  27. Solved: macro to open all hyperlink files and save as different sheets in the workbook (5 replies)
  28. [SOLVED:] Versions 97, 2000, & 2003 vbGeneralDate (3 replies)
  29. VBA Simulating a mouse double click (3 replies)
  30. Resize Range Method (4 replies)
  31. Solved: Display result to 3DP? (3 replies)
  32. Excel VBA Export Import Module (0 replies)
  33. Print a document double sided (0 replies)
  34. differenec between two cells - tricky one (2 replies)
  35. Solved: Form & Filter (2 replies)
  36. Create control associated with row (7 replies)
  37. xllastrow range - problem (1 replies)
  38. Seating problem (11 replies)
  39. Solved: How to insert "Are you sure? -> Yes/No" in code (2 replies)
  40. Converting Text to Dates... Fast! (7 replies)
  41. Need Creative Input (0 replies)
  42. Named Range Operations (1 replies)
  43. Need help with correct finding/sorting. Explanation and example file enlcosed. (8 replies)
  44. Find and replace multiple items (4 replies)
  45. Solved: SpecialCells bug (8 replies)
  46. Solved: How to kill that finger (macro pointer) (5 replies)
  47. Solved: Check for Vowel or Consonant (11 replies)
  48. Code needed: Find or Vlookup (0 replies)
  49. Interesting project? (9 replies)
  50. Solved: Edit KB Encrypt Code (10 replies)
  51. Solved: Create a list dependant on dropdown (7 replies)
  52. Orthoganally adjacent placement. (1 replies)
  53. Syntax Help (3 replies)
  54. copying cells (3 replies)
  55. export txt file data into excel and filter out req'd data (5 replies)
  56. Solved: Send mail to 100 mail address (2 replies)
  57. Solved: JOB: copying data from one sheet to others (3 replies)
  58. Project of the Week (11 replies)
  59. ComboBox retrieval. (1 replies)
  60. Deleting Rows (2 replies)
  61. MULTIPLY LISTBOX QUESTION - RANGE (2 replies)
  62. How to save screen as gif file (9 replies)
  63. Update cell data based on Listbox selection (9 replies)
  64. Solved: Many comboboxes with one name (2 replies)
  65. VBA Save As (1 replies)
  66. Excel Shrink (1 replies)
  67. extract row number (1 replies)
  68. Solved: trouble getting a progress bar working (6 replies)
  69. General Build Questions (2 replies)
  70. Code doesnt work as add-in (7 replies)
  71. Dierctly copying a cell that might be merged (2 replies)
  72. Solved: macro to copy and paste only 5 rows of the filtered data from sheet2 to sheet1 (3 replies)
  73. ADO recordset search (2 replies)
  74. Syntax Help (4 replies)
  75. Buttons thats copy the Caption in a cell (2 replies)
  76. How do i match up two columns of data? (3 replies)
  77. help Excel code (2 replies)
  78. EXCEL HELP (1 replies)
  79. Lookup data in Oracle database (4 replies)
  80. export date from text box to the right sheet (2 replies)
  81. Solved: Advanced help needed :S (4 replies)
  82. List Last nonblank cell in comment box or popup (1 replies)
  83. Calculus graphing (1 replies)
  84. Solved: Reverse code result (9 replies)
  85. Solved: Find a defined name with VBA (2 replies)
  86. Macro running extremely slow (3 replies)
  87. A40 last cell (2 replies)
  88. Solved: Checkbox not allowing me to check (8 replies)
  89. Solved: Useless Data Because of Abbreviations? (15 replies)
  90. [SOLVED:] Run this with a condition (3 replies)
  91. Solved: Print Reports Based on Cell Value (2 replies)
  92. [SOLVED:] User Form - Restrict Entry (5 replies)
  93. Problem with "Fill combobox with ordered list" (8 replies)
  94. Solved: Automating histograms (2 replies)
  95. Code needed for popup message box asking for password to open & use workbook (8 replies)
  96. Solved: Force users to enable macros (4 replies)
  97. 3rd party VBA editor (1 replies)
  98. Chart use array as sourcedata (3 replies)
  99. Macro to check and send data to Array. (4 replies)
  100. select all sheets (13 replies)
  101. How to Cycle through 5 different Pay Scale Possibilities? (16 replies)
  102. Solved: Creating multiple charts in single worksheet vith VBA (5 replies)
  103. Showing Progress in a Label (2 replies)
  104. Solved: SORT of need help (4 replies)
  105. Email help request. (1 replies)
  106. Clear all except first row (2 replies)
  107. Multiple rows slection for operation with rows (4 replies)
  108. How to insert required rows instead of a single row (1 replies)
  109. Fun Excel - Spiral through a range (11 replies)
  110. VBAProject (3 replies)
  111. Solved: workbook protection allowing admin / user access (26 replies)
  112. A simple database project (8 replies)
  113. Solved: strange problem-macro fails every ALTERNATE time!! (7 replies)
  114. Arrays (21 replies)
  115. Help with countif, 2 crteria required (5 replies)
  116. Interesting Excel Question (0 replies)
  117. Not sure if you can help me... Noobie here (5 replies)
  118. Solved: Pivot Table VBA problem - simple ? (2 replies)
  119. For Each Next Loop problems (3 replies)
  120. sum with conditions (2 replies)
  121. Solved: Multiple tasks for one command button (4 replies)
  122. Solved: simple activation key macro (12 replies)
  123. Solved: Blank Null Space (2 replies)
  124. Solved: Cut Header from a set of data and paste the same next to the Data in C& D Col (1 replies)
  125. Sum cell values on several worksheets (14 replies)
  126. Assigning label caption to a variable (2 replies)
  127. Grab worksheet From Closed Workbook (22 replies)
  128. Amend vba to add file name on save as (7 replies)
  129. Open work sheet (3 replies)
  130. Capture names from 2 arrays and create three new arrays (1 replies)
  131. Check for the Date (11 replies)
  132. Procedure stops running after UserForm.Show (6 replies)
  133. VBA -how to get every second row? (2 replies)
  134. Solved: Consolodate data on one sheet (2 replies)
  135. Solved: macro to save file in my documents (1 replies)
  136. Run-time error and invalid reference (related) (6 replies)
  137. Solved: Last Row in Range (again) (8 replies)
  138. Data referencing problem (10 replies)
  139. About excel vba objects (4 replies)
  140. Revisit Last Accessed Cell (9 replies)
  141. Solved: Renaming / Reorganizing files / directories (6 replies)
  142. Insert row with criteria (5 replies)
  143. VBA: return an item from an array (without using a loop) (7 replies)
  144. Create Chart using VBA function (2 replies)
  145. how to validate cell input for 10 digits only? (4 replies)
  146. Solved: check Ctrl + Shift + Enter array size (4 replies)
  147. Change Pictures (5 replies)
  148. Solved: Dates in Filter macro (4 replies)
  149. Chart Range References (2 replies)
  150. Move rows if conditions meet (6 replies)
  151. Solved: Using Programmed Array in Worksheet Function (12 replies)
  152. Solved: Sum of unique value using sumproduct (6 replies)
  153. Solved: Date + 1 year (1 replies)
  154. Copy/Paste Data turns black (2 replies)
  155. HELP! (18 replies)
  156. Solved: Match 3 cells? (6 replies)
  157. Help using activeX controls in VBA code (5 replies)
  158. Solved: Passing Procedure or Function name as variable (3 replies)
  159. Solved: "Auto" update (5 replies)
  160. Selecting Non contiguous Range (2 replies)
  161. Solved: Help with Dynamic formula (5 replies)
  162. SOLVED: Create multiple named ranges on sheet based on cell values (5 replies)
  163. Solved: Size of Array (5 replies)
  164. Solved: SUMPRODUCT across 4 columns (2 replies)
  165. Solved: Data Summary (10 replies)
  166. Excel spreadsheet help (4 replies)
  167. Excel Date (1 replies)
  168. Solved: List help (4 replies)
  169. Run Time Error: 1004 (2 replies)
  170. Solved: Ambigous Name Error (3 replies)
  171. Solved: Pivot table or SUMPRODUCT (14 replies)
  172. Solved: Comple error (11 replies)
  173. Solved: Display folders in excel (5 replies)
  174. Solved: Replace lookup formula (8 replies)
  175. Solved: import csv from the web (2 replies)
  176. [SOLVED:] Iterate through array with date criteria (5 replies)
  177. Solved: ENCRYPTS (4 replies)
  178. Changing reference between sheet cells in different excel file (6 replies)
  179. Solved: Reading one cell value into an array (14 replies)
  180. Scatter Plot chart (0 replies)
  181. Refedit issue (3 replies)
  182. Transpose specific row data to columns (9 replies)
  183. Find Multiple Cell Values (1 replies)
  184. Macro for Word and Excel (4 replies)
  185. Inventory Management (7 replies)
  186. Solved: copy and paste locks cells on a protected sheet (3 replies)
  187. Solved: Select Grand Total in Pivot Table (3 replies)
  188. Solved: create a list from other files (9 replies)
  189. Solved: Code to insert a row at the end of the current sheet (1 replies)
  190. Conditional format help (7 replies)
  191. Solved: Using a function in another function (5 replies)
  192. Data validation (8 replies)
  193. How to shorten this down? (2 replies)
  194. Auto printing command (19 replies)
  195. Macro to Copy only 10 rows per worksheet (1 replies)
  196. Solved: Macro help: Loops (25 replies)
  197. Solved: compile error with simple macro (2 replies)
  198. Solved: deleting rows beneath active cell one by one till value is found in column (16 replies)
  199. Solved: Visual Basic Programming (3 replies)
  200. Solved: Copy/Paste rows on two sheets simultaneously.. (4 replies)
  201. [SOLVED:] Adding two cells together (4 replies)
  202. Solved: Range help (6 replies)
  203. [SOLVED:] Enter date in Column A based on another row (4 replies)
  204. Solved: Problem with separator in functions... (1 replies)
  205. I would like to encrypt some data. How? (1 replies)
  206. questions of copy (2 replies)
  207. Excel ranges don't save as strings (8 replies)
  208. MI Data via User Form (6 replies)
  209. open protected excel (1 replies)
  210. Macro to un-filter data (1 replies)
  211. Solved: automate =sum for two lines (4 replies)
  212. Solved: enter value in cell based on another cell (5 replies)
  213. Closing Word Application from Excel (3 replies)
  214. Range Select (1 replies)
  215. How to check if a file is open using Excel VBA? (4 replies)
  216. How to integrate an undo command into conditional formatting VBA code (3 replies)
  217. Solved: hide columns in other sheet based on dates match (6 replies)
  218. Solved: E-mailing from excel (7 replies)
  219. Solved: Formatting a number in TextBox (13 replies)
  220. Solved: Show/Hide Columns and rows depending on cell value (5 replies)
  221. Solved: Individual Cell Selection and Format Changes (12 replies)
  222. Copy Data From Closed Workbook Without Opening (10 replies)
  223. Solved: Run a macro with the opening of a file (4 replies)
  224. Solved: User Input - Amend A List (2 replies)
  225. Redim Multidimensional Array and perform worksheet-based calculations (1 replies)
  226. Solved: Find the first Row (38 replies)
  227. Stop & Resume Timer Control in Excel VBA (3 replies)
  228. Solved: Code breaks in iteration of loop. (13 replies)
  229. Remote File Updates (0 replies)
  230. Solved: Fix the Controls (3 replies)
  231. automating register (7 replies)
  232. Solved: Autofill to just above next cell with value? (10 replies)
  233. Solved: Date Format (4 replies)
  234. Find group of records that match index and then do xxx (1 replies)
  235. Need help with assignment -Datafiltration (2 replies)
  236. Solved: Find the last row in a range (6 replies)
  237. Excel VBA Coding (extracting information from a list box) (1 replies)
  238. Solved: Usernname in a cell (7 replies)
  239. Excel VBA Coding (3 replies)
  240. Nested If (4 replies)
  241. Using VBA to Add A Reference (0 replies)
  242. Solved: Pushing Excel data to a Word template (4 replies)
  243. blank cell values (4 replies)
  244. Confusion about Union method (2 replies)
  245. Delete Rows in which a given cell contains a text string (3 replies)
  246. Solved: Get last cell in Worksheet (14 replies)
  247. Trim in VBA (2 replies)
  248. Excel 2003 / 2007 Compatibility Problem? (6 replies)
  249. Grouping (2 replies)
  250. deleting rows based on content of rows below (7 replies)