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. Copy/Paste Data turns black (2 replies)
  2. HELP! (18 replies)
  3. Solved: Match 3 cells? (6 replies)
  4. Help using activeX controls in VBA code (5 replies)
  5. Solved: Passing Procedure or Function name as variable (3 replies)
  6. Solved: "Auto" update (5 replies)
  7. Selecting Non contiguous Range (2 replies)
  8. Solved: Help with Dynamic formula (5 replies)
  9. SOLVED: Create multiple named ranges on sheet based on cell values (5 replies)
  10. Solved: Size of Array (5 replies)
  11. Solved: SUMPRODUCT across 4 columns (2 replies)
  12. Solved: Data Summary (10 replies)
  13. Excel spreadsheet help (4 replies)
  14. Excel Date (1 replies)
  15. Solved: List help (4 replies)
  16. Run Time Error: 1004 (2 replies)
  17. Solved: Ambigous Name Error (3 replies)
  18. Solved: Pivot table or SUMPRODUCT (14 replies)
  19. Solved: Comple error (11 replies)
  20. Solved: Display folders in excel (5 replies)
  21. Solved: Replace lookup formula (8 replies)
  22. [SOLVED:] Import csv from the web (2 replies)
  23. [SOLVED:] Iterate through array with date criteria (5 replies)
  24. Solved: ENCRYPTS (4 replies)
  25. Changing reference between sheet cells in different excel file (6 replies)
  26. Solved: Reading one cell value into an array (14 replies)
  27. Scatter Plot chart (0 replies)
  28. Refedit issue (3 replies)
  29. Transpose specific row data to columns (9 replies)
  30. Find Multiple Cell Values (1 replies)
  31. Macro for Word and Excel (4 replies)
  32. Inventory Management (7 replies)
  33. Solved: copy and paste locks cells on a protected sheet (3 replies)
  34. Solved: Select Grand Total in Pivot Table (3 replies)
  35. Solved: create a list from other files (9 replies)
  36. Solved: Code to insert a row at the end of the current sheet (1 replies)
  37. Conditional format help (7 replies)
  38. Solved: Using a function in another function (5 replies)
  39. Data validation (8 replies)
  40. How to shorten this down? (2 replies)
  41. Auto printing command (19 replies)
  42. Macro to Copy only 10 rows per worksheet (1 replies)
  43. Solved: Macro help: Loops (25 replies)
  44. Solved: compile error with simple macro (2 replies)
  45. [SOLVED:] Deleting rows beneath active cell one by one till value is found in column (16 replies)
  46. Solved: Visual Basic Programming (3 replies)
  47. Solved: Copy/Paste rows on two sheets simultaneously.. (4 replies)
  48. [SOLVED:] Adding two cells together (4 replies)
  49. Solved: Range help (6 replies)
  50. [SOLVED:] Enter date in Column A based on another row (4 replies)
  51. Solved: Problem with separator in functions... (1 replies)
  52. I would like to encrypt some data. How? (1 replies)
  53. questions of copy (2 replies)
  54. Excel ranges don't save as strings (8 replies)
  55. MI Data via User Form (6 replies)
  56. open protected excel (1 replies)
  57. Macro to un-filter data (1 replies)
  58. Solved: automate =sum for two lines (4 replies)
  59. Solved: enter value in cell based on another cell (5 replies)
  60. Closing Word Application from Excel (3 replies)
  61. Range Select (1 replies)
  62. How to check if a file is open using Excel VBA? (4 replies)
  63. How to integrate an undo command into conditional formatting VBA code (3 replies)
  64. Solved: hide columns in other sheet based on dates match (6 replies)
  65. Solved: E-mailing from excel (7 replies)
  66. Solved: Formatting a number in TextBox (13 replies)
  67. Solved: Show/Hide Columns and rows depending on cell value (5 replies)
  68. Solved: Individual Cell Selection and Format Changes (12 replies)
  69. Copy Data From Closed Workbook Without Opening (10 replies)
  70. Solved: Run a macro with the opening of a file (4 replies)
  71. Solved: User Input - Amend A List (2 replies)
  72. Redim Multidimensional Array and perform worksheet-based calculations (1 replies)
  73. [SOLVED:] Find the first Row (38 replies)
  74. Stop & Resume Timer Control in Excel VBA (3 replies)
  75. Solved: Code breaks in iteration of loop. (13 replies)
  76. Remote File Updates (0 replies)
  77. Solved: Fix the Controls (3 replies)
  78. automating register (7 replies)
  79. Solved: Autofill to just above next cell with value? (10 replies)
  80. Solved: Date Format (4 replies)
  81. Find group of records that match index and then do xxx (1 replies)
  82. Need help with assignment -Datafiltration (2 replies)
  83. Solved: Find the last row in a range (6 replies)
  84. Excel VBA Coding (extracting information from a list box) (1 replies)
  85. Solved: Usernname in a cell (7 replies)
  86. Excel VBA Coding (3 replies)
  87. Nested If (4 replies)
  88. Using VBA to Add A Reference (0 replies)
  89. Solved: Pushing Excel data to a Word template (4 replies)
  90. blank cell values (4 replies)
  91. Confusion about Union method (2 replies)
  92. Delete Rows in which a given cell contains a text string (3 replies)
  93. Solved: Get last cell in Worksheet (14 replies)
  94. Trim in VBA (2 replies)
  95. Excel 2003 / 2007 Compatibility Problem? (6 replies)
  96. Grouping (2 replies)
  97. deleting rows based on content of rows below (7 replies)
  98. Date Problems on VBA Forms (64 replies)
  99. hiding a property of a cell (2 replies)
  100. Solved: Double click to delete as shift column (7 replies)
  101. Solved: Excel photo handler : Malcolm Question (2 replies)
  102. Inserting a New Row (3 replies)
  103. Searching and copying (10 replies)
  104. Solved: activesheet.type always 3? (8 replies)
  105. Extracting Unique Highest Values (8 replies)
  106. Solved: Macro to change file format. (11 replies)
  107. Need help for "if" in excel (4 replies)
  108. calculating the joint variance of two distinct cell ranges (1 replies)
  109. Checking & Deleting (3 replies)
  110. [SOLVED:] Improve my code? (23 replies)
  111. Array Of Variables (9 replies)
  112. Solved: Combination list using VBA (8 replies)
  113. Macro to choose Specific Workbook from a directory (6 replies)
  114. Solved: Total (7 replies)
  115. Floating Comments over Command Button (14 replies)
  116. Solved: deleting rows based on content of cells (4 replies)
  117. Solved: Insert a specific row at the ActiveCell (4 replies)
  118. select/copy cells in a range that contain data (8 replies)
  119. Solved: Unprotect Worksheets (3 replies)
  120. Copy Errors (5 replies)
  121. Solved: InString Function (1 replies)
  122. Format Command Button (Form based) (2 replies)
  123. Add Comment Picture: Maintain Perspective Ratio (7 replies)
  124. changing range (4 replies)
  125. Solved: Problems formatting different date formats (6 replies)
  126. Solved: Frame On Excel (8 replies)
  127. Solved: PLZ HELP...muliple criteria in Excel (5 replies)
  128. Autorun a macro when workbook is open (7 replies)
  129. Reposition Jpg in the middle of the screen? (2 replies)
  130. Solved: Do not know how to approach this one? (13 replies)
  131. New line in tiptext (2 replies)
  132. Solved: Count unique records using multiple criteria (3 replies)
  133. ADODB.Connection Error: Compile Error (4 replies)
  134. Add New Worksheet to Include Date (2 replies)
  135. domain availability (3 replies)
  136. [SOLVED:] Ignore Message Box in excel (2 replies)
  137. Solved: Add data to a closed workbook (20 replies)
  138. Delete Selected Sheet (5 replies)
  139. Logic of multiple search criteria. Help Please! (2 replies)
  140. Need front end for db form?? (10 replies)
  141. Application.calculatefull problems! (17 replies)
  142. copy contents of a template sheet to another sheet (4 replies)
  143. Solved: Calculate 2 cells (3 replies)
  144. Environ Function Help! (9 replies)
  145. [SOLVED:] Copy excel settings from a pc to another (2 replies)
  146. Else error (2 replies)
  147. Solved: Parsing string elements in an array (7 replies)
  148. excel cannot complete this task with available resources (5 replies)
  149. Replace/Remove word/characters from a String (2 replies)
  150. Extract STATE from address string (3 replies)
  151. Solved: How to prevent user from selecting other background color (3 replies)
  152. listbox multi selection problem (4 replies)
  153. Sheet to Sheet Range To Range Copy (VBA) (1 replies)
  154. VBA Conditional Page breaks (0 replies)
  155. Parse Phone Numbers (Main, Office, Cell) (3 replies)
  156. Solved: Which button is Chosen (3 replies)
  157. Different access for different users (10 replies)
  158. Unique Rows In New Workbook (2 replies)
  159. Solved: Adding and apostophe to the beginning of numbers within cell (5 replies)
  160. Emailing in Excel using VBA Groupwise (0 replies)
  161. Excel 2007 Color Compatibility Issue (0 replies)
  162. Change series of a chart without using relative reference.... (0 replies)
  163. Help needed with this function call (3 replies)
  164. [SOLVED:] stupid questions (5 replies)
  165. Save As File Type 'Options' (3 replies)
  166. Sleeper: Unfinished Macro Copy cells from different Workbooks to a Main Workbook (7 replies)
  167. Excel sends email with low importance (3 replies)
  168. Copy and paste part of data to new workbook and save in specific directory (2 replies)
  169. Excel 2003 speed up code??? (3 replies)
  170. determine if "File Download" window is there (3 replies)
  171. Help!! Excel Data gets cut off when pasting to ppt slide (0 replies)
  172. Solved: Userform query (4 replies)
  173. Solved: Find & Replace problem (6 replies)
  174. Conditional [Color] Formatting not recognized with formula (8 replies)
  175. Problems with Evaluate method in VBA: Variance of the product of two ranges (1 replies)
  176. Excel crasches while opening files with references.addfromfile (0 replies)
  177. Solved: Autofilter (3 replies)
  178. Pivot Table - Blank rows/columns (9 replies)
  179. saving a MSP file to open up in Excel and back (1 replies)
  180. Use vlookup formual in data validation (0 replies)
  181. Chart scaling and adjusting (2 replies)
  182. Solved: Switching the Worksheet Deletion Warning Off? (2 replies)
  183. Can you make VLOOKUPS conditional? (5 replies)
  184. Compare Data from one sheet to another (2 replies)
  185. Solved: Copy input range (2 replies)
  186. Solved: Randomly picked winners (2 replies)
  187. Drop down in one cell & fill another cell (8 replies)
  188. Solved: Help with Excel roster matching... (2 replies)
  189. VBA Split Workbook macro (5 replies)
  190. Solved: Read in Excel, Write out to Text (3 replies)
  191. Apply macros to an other workbook (4 replies)
  192. Conditional count (4 replies)
  193. Solved: Help opening csv files in Excel (23 replies)
  194. Importing data; action when ready (0 replies)
  195. Trying to modify an macros (13 replies)
  196. Select All Data (8 replies)
  197. Data Values in chart (9 replies)
  198. [SOLVED:] Chart titles with varied font sizes (6 replies)
  199. changing chart colours dynamically (1 replies)
  200. Solved: IF(IsNumber (7 replies)
  201. Compare Private Function help. (1 replies)
  202. Class Project for bnwhite (4 replies)
  203. [SOLVED:] How to check if a shape Exists? (5 replies)
  204. Solved: Auto_Run macro that only auto_runs once (7 replies)
  205. (Limited) Loop Through Sheets. (1 replies)
  206. Solved: Copy cells with no spaces and paste with semi-colon (15 replies)
  207. search for mulitiple text strings, return value (6 replies)
  208. Converting English number Fomat to German number Format (5 replies)
  209. Solved: ActiveCell rw,col (2 replies)
  210. Adding rows and copying cells (3 replies)
  211. Solved: How to insert ToolTips in Cell? (2 replies)
  212. How to write this kind of code (14 replies)
  213. delete row is A(x) is blank (4 replies)
  214. [SOLVED:] List all sheets of opened workbook into ComboBox (8 replies)
  215. Extract entire row based on the cell value (5 replies)
  216. i want to learn VBA (7 replies)
  217. Values from Spreadsheet into Userform Textbox (7 replies)
  218. Comment box listing sheet names from active cell (4 replies)
  219. VBA "ignoring" request to not copy from sheet (2 replies)
  220. [Excel] Data transfer to new file (1 replies)
  221. Linking-updating worksheets? (10 replies)
  222. Solved: Why is the sorted array Not being returned? (9 replies)
  223. Solved: Copy Entire Row based on Cell (4 replies)
  224. VBA Copy/Paste Offset Values Between Sheets (2 replies)
  225. Solved: Why is vba not obeying an if statement to skip a sheet? (2 replies)
  226. Modeless Userform event (6 replies)
  227. Trying to call a amcro on selection of a cell in a range (2 replies)
  228. Populate Array from a range in a closed workbook in vba (4 replies)
  229. "one hundred" converted to 100 (5 replies)
  230. auto populate cell in worksheet (3 replies)
  231. How do I reference the current cell? (2 replies)
  232. Solved: Finding avg of ranges (7 replies)
  233. Wildcard in SUMPRODUCT (5 replies)
  234. Solved: Newbie VBA help in Excel (Moving cells) (6 replies)
  235. Solved: Excel accounting spreadsheet macro (24 replies)
  236. Solved: If loops (7 replies)
  237. [SLEEPER:] Activating Excel VBA References programatically (5 replies)
  238. Regarding Application.ScreenUpdating=False (3 replies)
  239. Solved: Help Basics Input Data (19 replies)
  240. Error (1 replies)
  241. Auto Enable Macro in 2007 (2 replies)
  242. excel 2007 stop pop up (7 replies)
  243. Solved: cycle through rows (6 replies)
  244. InputBox (7 replies)
  245. Solved: Export Shapes to PowerPoint (3 replies)
  246. Solved: VBA active cell (5 replies)
  247. Solved: Splitting cell values into two defferent columns (13 replies)
  248. Solved: Select Cases using two columns (5 replies)
  249. Attached alpha numeric based on criteria (3 replies)
  250. Create Copies of Workbook (4 replies)