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. select a sheet from list (3 replies)
  2. Optional argument in a function error (3 replies)
  3. Solved: create the button on file A, but use it for file B (11 replies)
  4. Reduce macro code size (6 replies)
  5. How can I read a text file and write values into an excel sheet (3 replies)
  6. How to count nbr of QueryTables in workbook (1 replies)
  7. Solved: Find values and distribute in cells (10 replies)
  8. Solved: Renewing data upon opening workbook (2 replies)
  9. Solved: Populate values multiple times date wise (15 replies)
  10. open Microsoft windows mail and attach (4 replies)
  11. Solved: Data Collection (5 replies)
  12. Chart/picture location problem (0 replies)
  13. File on hard drive or network drive (1 replies)
  14. display negative number if greater then 0 (1 replies)
  15. Tab from specific cell to cell (3 replies)
  16. Solved: combo bug in userform (it makes roller) (11 replies)
  17. Solved: How to display information in other columns with missing information (10 replies)
  18. Application.Run (RptObj.Name & "!Main") vs Application.ExecuteExcel4Macro "RUN(""Main (0 replies)
  19. How To Do Relative xPath In CustomXMLNode? (1 replies)
  20. Solved: countdown timer (2 replies)
  21. match/copy/paste (4 replies)
  22. Create "Save As" button on UserForm (2 replies)
  23. Excel 2003/2007 - AutoComplete is inconsistent (0 replies)
  24. VB Inserting image to specific cell in excel (2 replies)
  25. Solved: Macro with launch button (5 replies)
  26. Solved: Excel 2003 - Delete rows with no values in Columns A thru E (5 replies)
  27. Excel VBA - How to Create Read Write Edit Del by ADO - Jet.OLEDB - Access - MDB (3 replies)
  28. Solved: Exporting word data to Excel vba (16 replies)
  29. UserForm Trouble (13 replies)
  30. Solved: Copy values to Empty cells below filled cells in selection (4 replies)
  31. Returning Values (4 replies)
  32. [SLEEPER:] Different pivot charts 'different windows' in the same worksheet (0 replies)
  33. Modifying The Code to Check if the entry exists (2 replies)
  34. Solved: Design Time Vs Run Time (7 replies)
  35. Connecting oracle and excel sheet (10 replies)
  36. Excel 2003 - Need to detect Cell Insert shift left or shift down or Entire Column (5 replies)
  37. Solved: Response Time Formula (2 replies)
  38. userform cancel button (5 replies)
  39. Solved: Change Event not triggering with "Tab" key (2 replies)
  40. Excel-Copy worksheet and timestamp (1 replies)
  41. Solved: MsgBox Item (12 replies)
  42. Powerball Reconciliation (10 replies)
  43. Control Internet Explorer using active URL (1 replies)
  44. Classic 2003 Excel Menu add-in for 2007? (3 replies)
  45. Solved: Autofill till cell left of it is empty (6 replies)
  46. insert control Toolbox failed (2 replies)
  47. Automatically copy cell contents (1 replies)
  48. Copying Contents from one sheet to another (4 replies)
  49. Solved: Drop Down List (6 replies)
  50. Solved: Print different sheets - Print area does not clear - Print_area already exists (2 replies)
  51. Solved: Excel 2003 - Need to determine if any text has been entered into a numbers only cell (1 replies)
  52. Solved: Excel 2003 - Need to clean extra commas from string (8 replies)
  53. Using Index Match across multiple worksheets (5 replies)
  54. Solved: Import Module via VBA code and delete existing Module with same name (4 replies)
  55. Solved: Number Formatting (7 replies)
  56. Input restriction (3 replies)
  57. Updating fields on external input (5 replies)
  58. Changing Tooltip size and color (21 replies)
  59. VBA for Find & Replace (1 replies)
  60. Copying Columns from One Sheet to Another (4 replies)
  61. insert figure end of formula (2 replies)
  62. getting values dynamically from cells A1 t0 A100 (22 replies)
  63. Selecting Blank Cells with in the selection (6 replies)
  64. Solved: Select Collumn based on Cell Value (6 replies)
  65. end(xlup) cant work (6 replies)
  66. Open text file and write to excel file (9 replies)
  67. formula to vba (7 replies)
  68. [SOLVED:] ListBox on a worksheet from Forms Controls Toolbox (9 replies)
  69. Search (3 replies)
  70. code from snow (4 replies)
  71. Asking for VBA help (1 replies)
  72. Solved: Word to Excel (4 replies)
  73. indirect address + skipping cell (0 replies)
  74. macro for workbook source change (1 replies)
  75. Show/Hide button - Excel vba macro - List (5 replies)
  76. Solved: Using Variable Cell in IF Statement Formula (2 replies)
  77. How to create one button for locking/unlocking all sheets (3 replies)
  78. Numbers from strings (6 replies)
  79. Solved: COPY/PASTE OR JOIN (2 replies)
  80. VBA Help (3 replies)
  81. [SOLVED:] Slow Down On Running Code (23 replies)
  82. Stuck in OFFICE12 folder after SendMail (1 replies)
  83. Solved: LOAD only visible cells to combobox in userform (4 replies)
  84. find/place based on cell but absolute reference issue/macro mainting sequential order (0 replies)
  85. Solved: copy cell data (2 replies)
  86. Solved: multiple Application objects (3 replies)
  87. copy (3 replies)
  88. Not able to get HTML text including formatting (4 replies)
  89. Solved: Check cell string in column (10 replies)
  90. HELP with VB/HTML code. (5 replies)
  91. Archiving weekly data (7 replies)
  92. Office clipboard as datasource (0 replies)
  93. Solved: Select Case with multiple criteria (12 replies)
  94. VBA Forms - Passing a Variable (4 replies)
  95. Create workbook from template, enable link updating (1 replies)
  96. Solved: WorksheetFunction.Match can't find date (5 replies)
  97. Solved: Excel 2003 - Something faster than a Loop to check the used range surrounding Border (3 replies)
  98. Solved: referencing a tab name in a sumproduct formula (4 replies)
  99. scrolling text on a form (2 replies)
  100. Solved: Color banding (7 replies)
  101. Fill combobox from different worksheet (10 replies)
  102. Trial some VBA CD burn code (0 replies)
  103. Copyingmultiple worksheets (2 replies)
  104. Graphs: Return null value. (4 replies)
  105. Copy Pasting from one workbook to another (8 replies)
  106. Solved: msg box then deleting field when cell changed (6 replies)
  107. Solved: Excel 2003 - Is there a way I can speed up my AutoFill Formula for 15,000 rows? (6 replies)
  108. Solved: Event Macro to trigger if a query should refresh or not (4 replies)
  109. Error running Word from Excel (3 replies)
  110. Solved: Preventing undesired jumping of mark (7 replies)
  111. Remove Contents of a cell based another cell's change... (8 replies)
  112. Solved: Excel 2003- Can a formula in a cell detect how many rows are above it? (2 replies)
  113. Solved: Excel 2003/2007 - Need to trigger the change event if new row is inserted, or deleted (6 replies)
  114. [SOLVED:] Less specific search (9 replies)
  115. search replace Diogonally (12 replies)
  116. Finding and Moving Cells (5 replies)
  117. [SOLVED:] ADO Connections (6 replies)
  118. CONCATENATE (8 replies)
  119. loop, if and empty (3 replies)
  120. Solved: Counting weekdays (9 replies)
  121. A continuation... Question of method... (1 replies)
  122. Help with Error 91 (4 replies)
  123. pagebreaks (4 replies)
  124. Solved: Output Data from a Userform to a txt file (4 replies)
  125. Hi. Need help creating/saving workbooks. (6 replies)
  126. Using VBA to insert or delete row and column automatic (1 replies)
  127. Solved: Extract and find (6 replies)
  128. Solved: 4 letters (7 replies)
  129. List of Folder,Subfolder & filename (3 replies)
  130. Solved: Excel 2003 - Highlighted row using top & bottom borders. Would like to speed up code (22 replies)
  131. Solved: Excel 2003/2007 - Need to delete top and botom row borders after selection change (2 replies)
  132. Solved: paste to non contiguous named range (12 replies)
  133. Solved: Excel 2003 - how do I Auto Fill a Formula down to the Last Row in a Column? (2 replies)
  134. Solved: Excel Caption (2 replies)
  135. Kindly help me write these excel macros (6 replies)
  136. [SOLVED:] Quick table lookup (2 replies)
  137. Condiitonal formatting dependent on a Comment (4 replies)
  138. Solved: sorting by cell icon (2 replies)
  139. Solved: Countifs Help (4 replies)
  140. COUNT AND FILTER (9 replies)
  141. Getting/Searching Cell value from another Excel Worksheet (4 replies)
  142. Solved: Autofill, last row in column (4 replies)
  143. Solved: Excel 2003 - What is the Cell Character limit? And why do I see #### in the cell? (7 replies)
  144. Solved: Excel 2003 - Need to sum numbers that are in cells formated as text (3 replies)
  145. Fix excel error "Too Many different cell formats" (2 replies)
  146. Solved: Excel Form (6 replies)
  147. Solved: Excel 2003 - Need to change the value in cell that contains a specific autoshape (1 replies)
  148. Solved: Copy current data to a new sheet.... (2 replies)
  149. [SOLVED:] Code for pushbutton click (8 replies)
  150. Solved: Hide worksheets (2 replies)
  151. Solved: Drop Down List (7 replies)
  152. Sum multiple lines based on multiple criteria (7 replies)
  153. Solved: Using Variable Col_Index with VLOOKUP (2 replies)
  154. Goal Seek for multiple rows with blanks between them (4 replies)
  155. Solved: Change Default Font for New Workbook (1 replies)
  156. Solved: Data Validation - Formula Question (3 replies)
  157. How do you merge workbooks into one complete spreadsheet. (6 replies)
  158. rMOVE ZERO (3 replies)
  159. Read out - VBA (1 replies)
  160. Solved: print code (2 replies)
  161. Solved: cell contents were missing once i reopen a file (4 replies)
  162. Solved: Excel 2003 How can I delete a specific shape type within the ActiveSheet (2 replies)
  163. Solved: Excel 2003 Change Event to concatenate Column 8 value to Column 12 Value (2 replies)
  164. Solved: vlookup:Search from bottom row instead of top row (3 replies)
  165. [SOLVED:] Compare/Copy new location. Isn't working! (4 replies)
  166. Check FirstName&LastName duplicates (1 replies)
  167. Solved: Combine cells values from two sheets into 1 cell (2 replies)
  168. Solved: Compare/replace based on equivalence list (10 replies)
  169. Solved: Upload file into website (2 replies)
  170. Cmd button for Redo Function (1 replies)
  171. Code for formatting Email from Excel (0 replies)
  172. Identifying pdf charts by VBA (0 replies)
  173. Combining OFFSET and VLOOKUP (1 replies)
  174. Solved: Activating Java table with Vba (3 replies)
  175. Grouping cells so that they can be sorted together in excel (0 replies)
  176. Solved: Value Function (2 replies)
  177. Solved: Excel’s Speak Cells feature (3 replies)
  178. Unwanted change of font while pasting into Word (3 replies)
  179. How do i Copy numbers only. (4 replies)
  180. Opening UTF-16 text file with VBA (3 replies)
  181. Solved: just values insted formula (3 replies)
  182. Data Input Restrictions (7 replies)
  183. Simple Sheet copy problem: Workbook to Workbook (2 replies)
  184. Solved: Data Validation (2 replies)
  185. [SLEEPER:] Check if userform is visible (5 replies)
  186. Solved: Make a chart from 1 column (2 replies)
  187. Update Sales Territory Shifts/Changes through VBA (8 replies)
  188. I need a simple code. (1 replies)
  189. Solved: Close Worksheet Macro (4 replies)
  190. SUMPRODUCT (10 replies)
  191. Deleting a Record from a Worksheet (4 replies)
  192. [SOLVED:] Deactivate Commandbutton and Hide (10 replies)
  193. Sleeper: Internet Explorer Form Automation (0 replies)
  194. Undead Data, or: what's a "block of data", anyway? (5 replies)
  195. Moving Data to Another Worksheet (2 replies)
  196. Upload using VBA to a Google Sites Filing cabinet (0 replies)
  197. Create a block diagram from text (8 replies)
  198. Master Workbook linked to Two Workbooks (0 replies)
  199. Solved: Number fill - randomly (5 replies)
  200. Solved: using macro to edit macro (4 replies)
  201. Force save another open workbook (7 replies)
  202. How to Hide Specified Cells? (3 replies)
  203. Solved: Paste from Excel to Word (9 replies)
  204. Solved: How to return a worksheet name based on found data (2 replies)
  205. Find and replace tab names (4 replies)
  206. Nest do loops (13 replies)
  207. Solved: deleting specific words from a cell (10 replies)
  208. copy sheet based on list of names once only (11 replies)
  209. Solved: New to VBA (4 replies)
  210. set y = “the row number” at which the button I click locates (3 replies)
  211. What is the MaxLocksperfile property? (2 replies)
  212. how to reset the value of .FileSearch to null or nothing? (7 replies)
  213. Solved: Statusbar black on black (0 replies)
  214. Inserting pictures and the path. (4 replies)
  215. User Defined Function and calculate (5 replies)
  216. Keeping Cells that are Conditional Formated when Sorting Data (9 replies)
  217. [SOLVED:] Read Only Prompt When Saving (4 replies)
  218. Send Mail range to each person (13 replies)
  219. Consolidation of various files based on cell value/Filter (1 replies)
  220. ComboBox crashes in 2002, SP3 but works fine in 2010 (2 replies)
  221. Find all function returns the cell or the value? (11 replies)
  222. Solved: Creating folder (2 replies)
  223. Help plotting a graph in VBA (3 replies)
  224. ExcelDiet (5 replies)
  225. Need Help with controlling internet using Excel Macro !!! (1 replies)
  226. double vlookup (1 replies)
  227. Solved: Vlookup/Match (1 replies)
  228. deny changes after entering data (2 replies)
  229. Problem installing Format Functions add-in (5 replies)
  230. click a button to open a picture (8 replies)
  231. Solved: Hiding 120 tabs (6 replies)
  232. Solved: Modifying Data in a Worksheet from a Userform (7 replies)
  233. Solved: extracr specific data from a file (14 replies)
  234. Solved: How to find subtotals from formula currency converted cells (4 replies)
  235. [SOLVED:] Compare a cell with another cell (1 replies)
  236. Cannot Insert Object (3 replies)
  237. Solved: Find the words "*-*Shares" from ColF and move to ColG (3 replies)
  238. Formula or Macro? Help (5 replies)
  239. Delimiting a cell to the rows below (8 replies)
  240. Solved: index, match (13 replies)
  241. Selecting a range for a barchart in vba (1 replies)
  242. Tab Error on CSV File (2 replies)
  243. simple chart with 2 yaxes and 1 x axes (0 replies)
  244. Modifying Data on Another Worksheet (0 replies)
  245. Solved: find values separated by a slash (4 replies)
  246. Syntaxes for Worksheets and RC formula (2 replies)
  247. Force fullscreen mode (5 replies)
  248. Hooking LIstBox in Class Module (2 replies)
  249. How to get information from a ListBox to an Excel Worksheet (3 replies)
  250. Autofilter in VBA for selected string in a cell (3 replies)