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. Solved: Advanced help needed :S (4 replies)
  2. List Last nonblank cell in comment box or popup (1 replies)
  3. Calculus graphing (1 replies)
  4. Solved: Reverse code result (9 replies)
  5. Solved: Find a defined name with VBA (2 replies)
  6. Macro running extremely slow (3 replies)
  7. A40 last cell (2 replies)
  8. Solved: Checkbox not allowing me to check (8 replies)
  9. Solved: Useless Data Because of Abbreviations? (15 replies)
  10. [SOLVED:] Run this with a condition (3 replies)
  11. Solved: Print Reports Based on Cell Value (2 replies)
  12. [SOLVED:] User Form - Restrict Entry (5 replies)
  13. Problem with "Fill combobox with ordered list" (8 replies)
  14. Solved: Automating histograms (2 replies)
  15. Code needed for popup message box asking for password to open & use workbook (8 replies)
  16. Solved: Force users to enable macros (4 replies)
  17. 3rd party VBA editor (1 replies)
  18. Chart use array as sourcedata (3 replies)
  19. Macro to check and send data to Array. (4 replies)
  20. select all sheets (13 replies)
  21. How to Cycle through 5 different Pay Scale Possibilities? (16 replies)
  22. Solved: Creating multiple charts in single worksheet vith VBA (5 replies)
  23. Showing Progress in a Label (2 replies)
  24. Solved: SORT of need help (4 replies)
  25. Email help request. (1 replies)
  26. Clear all except first row (2 replies)
  27. Multiple rows slection for operation with rows (4 replies)
  28. How to insert required rows instead of a single row (1 replies)
  29. Fun Excel - Spiral through a range (11 replies)
  30. VBAProject (3 replies)
  31. Solved: workbook protection allowing admin / user access (26 replies)
  32. A simple database project (8 replies)
  33. Solved: strange problem-macro fails every ALTERNATE time!! (7 replies)
  34. Arrays (21 replies)
  35. Help with countif, 2 crteria required (5 replies)
  36. Interesting Excel Question (0 replies)
  37. Not sure if you can help me... Noobie here (5 replies)
  38. Solved: Pivot Table VBA problem - simple ? (2 replies)
  39. For Each Next Loop problems (3 replies)
  40. sum with conditions (2 replies)
  41. Solved: Multiple tasks for one command button (4 replies)
  42. Solved: simple activation key macro (12 replies)
  43. Solved: Blank Null Space (2 replies)
  44. Solved: Cut Header from a set of data and paste the same next to the Data in C& D Col (1 replies)
  45. Sum cell values on several worksheets (14 replies)
  46. Assigning label caption to a variable (2 replies)
  47. Grab worksheet From Closed Workbook (22 replies)
  48. Amend vba to add file name on save as (7 replies)
  49. Open work sheet (3 replies)
  50. Capture names from 2 arrays and create three new arrays (1 replies)
  51. Check for the Date (11 replies)
  52. Procedure stops running after UserForm.Show (6 replies)
  53. VBA -how to get every second row? (2 replies)
  54. Solved: Consolodate data on one sheet (2 replies)
  55. Solved: macro to save file in my documents (1 replies)
  56. Run-time error and invalid reference (related) (6 replies)
  57. Solved: Last Row in Range (again) (8 replies)
  58. Data referencing problem (10 replies)
  59. About excel vba objects (4 replies)
  60. Revisit Last Accessed Cell (9 replies)
  61. Solved: Renaming / Reorganizing files / directories (6 replies)
  62. Insert row with criteria (5 replies)
  63. VBA: return an item from an array (without using a loop) (7 replies)
  64. Create Chart using VBA function (2 replies)
  65. how to validate cell input for 10 digits only? (4 replies)
  66. Solved: check Ctrl + Shift + Enter array size (4 replies)
  67. Change Pictures (5 replies)
  68. Solved: Dates in Filter macro (4 replies)
  69. Chart Range References (2 replies)
  70. Move rows if conditions meet (6 replies)
  71. Solved: Using Programmed Array in Worksheet Function (12 replies)
  72. Solved: Sum of unique value using sumproduct (6 replies)
  73. Solved: Date + 1 year (1 replies)
  74. Copy/Paste Data turns black (2 replies)
  75. HELP! (18 replies)
  76. Solved: Match 3 cells? (6 replies)
  77. Help using activeX controls in VBA code (5 replies)
  78. Solved: Passing Procedure or Function name as variable (3 replies)
  79. Solved: "Auto" update (5 replies)
  80. Selecting Non contiguous Range (2 replies)
  81. Solved: Help with Dynamic formula (5 replies)
  82. SOLVED: Create multiple named ranges on sheet based on cell values (5 replies)
  83. Solved: Size of Array (5 replies)
  84. Solved: SUMPRODUCT across 4 columns (2 replies)
  85. Solved: Data Summary (10 replies)
  86. Excel spreadsheet help (4 replies)
  87. Excel Date (1 replies)
  88. Solved: List help (4 replies)
  89. Run Time Error: 1004 (2 replies)
  90. Solved: Ambigous Name Error (3 replies)
  91. Solved: Pivot table or SUMPRODUCT (14 replies)
  92. Solved: Comple error (11 replies)
  93. Solved: Display folders in excel (5 replies)
  94. Solved: Replace lookup formula (8 replies)
  95. Solved: import csv from the web (2 replies)
  96. [SOLVED:] Iterate through array with date criteria (5 replies)
  97. Solved: ENCRYPTS (4 replies)
  98. Changing reference between sheet cells in different excel file (6 replies)
  99. Solved: Reading one cell value into an array (14 replies)
  100. Scatter Plot chart (0 replies)
  101. Refedit issue (3 replies)
  102. Transpose specific row data to columns (9 replies)
  103. Find Multiple Cell Values (1 replies)
  104. Macro for Word and Excel (4 replies)
  105. Inventory Management (7 replies)
  106. Solved: copy and paste locks cells on a protected sheet (3 replies)
  107. Solved: Select Grand Total in Pivot Table (3 replies)
  108. Solved: create a list from other files (9 replies)
  109. Solved: Code to insert a row at the end of the current sheet (1 replies)
  110. Conditional format help (7 replies)
  111. Solved: Using a function in another function (5 replies)
  112. Data validation (8 replies)
  113. How to shorten this down? (2 replies)
  114. Auto printing command (19 replies)
  115. Macro to Copy only 10 rows per worksheet (1 replies)
  116. Solved: Macro help: Loops (25 replies)
  117. Solved: compile error with simple macro (2 replies)
  118. Solved: deleting rows beneath active cell one by one till value is found in column (16 replies)
  119. Solved: Visual Basic Programming (3 replies)
  120. Solved: Copy/Paste rows on two sheets simultaneously.. (4 replies)
  121. [SOLVED:] Adding two cells together (4 replies)
  122. Solved: Range help (6 replies)
  123. [SOLVED:] Enter date in Column A based on another row (4 replies)
  124. Solved: Problem with separator in functions... (1 replies)
  125. I would like to encrypt some data. How? (1 replies)
  126. questions of copy (2 replies)
  127. Excel ranges don't save as strings (8 replies)
  128. MI Data via User Form (6 replies)
  129. open protected excel (1 replies)
  130. Macro to un-filter data (1 replies)
  131. Solved: automate =sum for two lines (4 replies)
  132. Solved: enter value in cell based on another cell (5 replies)
  133. Closing Word Application from Excel (3 replies)
  134. Range Select (1 replies)
  135. How to check if a file is open using Excel VBA? (4 replies)
  136. How to integrate an undo command into conditional formatting VBA code (3 replies)
  137. Solved: hide columns in other sheet based on dates match (6 replies)
  138. Solved: E-mailing from excel (7 replies)
  139. Solved: Formatting a number in TextBox (13 replies)
  140. Solved: Show/Hide Columns and rows depending on cell value (5 replies)
  141. Solved: Individual Cell Selection and Format Changes (12 replies)
  142. Copy Data From Closed Workbook Without Opening (10 replies)
  143. Solved: Run a macro with the opening of a file (4 replies)
  144. Solved: User Input - Amend A List (2 replies)
  145. Redim Multidimensional Array and perform worksheet-based calculations (1 replies)
  146. Solved: Find the first Row (38 replies)
  147. Stop & Resume Timer Control in Excel VBA (3 replies)
  148. Solved: Code breaks in iteration of loop. (13 replies)
  149. Remote File Updates (0 replies)
  150. Solved: Fix the Controls (3 replies)
  151. automating register (7 replies)
  152. Solved: Autofill to just above next cell with value? (10 replies)
  153. Solved: Date Format (4 replies)
  154. Find group of records that match index and then do xxx (1 replies)
  155. Need help with assignment -Datafiltration (2 replies)
  156. Solved: Find the last row in a range (6 replies)
  157. Excel VBA Coding (extracting information from a list box) (1 replies)
  158. Solved: Usernname in a cell (7 replies)
  159. Excel VBA Coding (3 replies)
  160. Nested If (4 replies)
  161. Using VBA to Add A Reference (0 replies)
  162. Solved: Pushing Excel data to a Word template (4 replies)
  163. blank cell values (4 replies)
  164. Confusion about Union method (2 replies)
  165. Delete Rows in which a given cell contains a text string (3 replies)
  166. Solved: Get last cell in Worksheet (14 replies)
  167. Trim in VBA (2 replies)
  168. Excel 2003 / 2007 Compatibility Problem? (6 replies)
  169. Grouping (2 replies)
  170. deleting rows based on content of rows below (7 replies)
  171. Date Problems on VBA Forms (64 replies)
  172. hiding a property of a cell (2 replies)
  173. Solved: Double click to delete as shift column (7 replies)
  174. Solved: Excel photo handler : Malcolm Question (2 replies)
  175. Inserting a New Row (3 replies)
  176. Searching and copying (10 replies)
  177. Solved: activesheet.type always 3? (8 replies)
  178. Extracting Unique Highest Values (8 replies)
  179. Solved: Macro to change file format. (11 replies)
  180. Need help for "if" in excel (4 replies)
  181. calculating the joint variance of two distinct cell ranges (1 replies)
  182. Checking & Deleting (3 replies)
  183. [SOLVED:] Improve my code? (23 replies)
  184. Array Of Variables (9 replies)
  185. Solved: Combination list using VBA (8 replies)
  186. Macro to choose Specific Workbook from a directory (6 replies)
  187. Solved: Total (7 replies)
  188. Floating Comments over Command Button (14 replies)
  189. Solved: deleting rows based on content of cells (4 replies)
  190. Solved: Insert a specific row at the ActiveCell (4 replies)
  191. select/copy cells in a range that contain data (8 replies)
  192. Solved: Unprotect Worksheets (3 replies)
  193. Copy Errors (5 replies)
  194. Solved: InString Function (1 replies)
  195. Format Command Button (Form based) (2 replies)
  196. Add Comment Picture: Maintain Perspective Ratio (7 replies)
  197. changing range (4 replies)
  198. Solved: Problems formatting different date formats (6 replies)
  199. Solved: Frame On Excel (8 replies)
  200. Solved: PLZ HELP...muliple criteria in Excel (5 replies)
  201. Autorun a macro when workbook is open (7 replies)
  202. Reposition Jpg in the middle of the screen? (2 replies)
  203. Solved: Do not know how to approach this one? (13 replies)
  204. New line in tiptext (2 replies)
  205. Solved: Count unique records using multiple criteria (3 replies)
  206. ADODB.Connection Error: Compile Error (4 replies)
  207. Add New Worksheet to Include Date (2 replies)
  208. domain availability (3 replies)
  209. [SOLVED:] Ignore Message Box in excel (2 replies)
  210. Solved: Add data to a closed workbook (20 replies)
  211. Delete Selected Sheet (5 replies)
  212. Logic of multiple search criteria. Help Please! (2 replies)
  213. Need front end for db form?? (10 replies)
  214. Application.calculatefull problems! (17 replies)
  215. copy contents of a template sheet to another sheet (4 replies)
  216. Solved: Calculate 2 cells (3 replies)
  217. Environ Function Help! (9 replies)
  218. Copy excel settings from a pc to another (2 replies)
  219. Else error (2 replies)
  220. Solved: Parsing string elements in an array (7 replies)
  221. excel cannot complete this task with available resources (5 replies)
  222. Replace/Remove word/characters from a String (2 replies)
  223. Extract STATE from address string (3 replies)
  224. Solved: How to prevent user from selecting other background color (3 replies)
  225. listbox multi selection problem (4 replies)
  226. Sheet to Sheet Range To Range Copy (VBA) (1 replies)
  227. VBA Conditional Page breaks (0 replies)
  228. Parse Phone Numbers (Main, Office, Cell) (3 replies)
  229. Solved: Which button is Chosen (3 replies)
  230. Different access for different users (10 replies)
  231. Unique Rows In New Workbook (2 replies)
  232. Solved: Adding and apostophe to the beginning of numbers within cell (5 replies)
  233. Emailing in Excel using VBA Groupwise (0 replies)
  234. Excel 2007 Color Compatibility Issue (0 replies)
  235. Change series of a chart without using relative reference.... (0 replies)
  236. Help needed with this function call (3 replies)
  237. [SOLVED:] stupid questions (5 replies)
  238. Save As File Type 'Options' (3 replies)
  239. Sleeper: Unfinished Macro Copy cells from different Workbooks to a Main Workbook (7 replies)
  240. Excel sends email with low importance (3 replies)
  241. Copy and paste part of data to new workbook and save in specific directory (2 replies)
  242. Excel 2003 speed up code??? (3 replies)
  243. determine if "File Download" window is there (3 replies)
  244. Help!! Excel Data gets cut off when pasting to ppt slide (0 replies)
  245. Solved: Userform query (4 replies)
  246. Solved: Find & Replace problem (6 replies)
  247. Conditional [Color] Formatting not recognized with formula (8 replies)
  248. Problems with Evaluate method in VBA: Variance of the product of two ranges (1 replies)
  249. Excel crasches while opening files with references.addfromfile (0 replies)
  250. Solved: Autofilter (3 replies)