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: R1C1 AND Letters - is there a way to see both (2 replies)
  2. word to Excel or Access (1 replies)
  3. Copy filtered data in new sheet and name it after criteria (2 replies)
  4. Solved: Colour cell based on range value (2 replies)
  5. Solved: uCase, cut and paste (2 replies)
  6. Solved: Formatting of a cell (6 replies)
  7. Solved: How to add textbox to a chart on a worksheet? (2 replies)
  8. Solved: Why does this code increase the height of chart when copied as picture? (2 replies)
  9. Automatically updating into next cell below (4 replies)
  10. calculating std deviation with blank cells (5 replies)
  11. [SOLVED:] Running specific line of macro (8 replies)
  12. Solved: = <> vba case sensitive (6 replies)
  13. Importing External Data with new DB query (1 replies)
  14. help with listbox columns... (5 replies)
  15. Where's the Bug (6 replies)
  16. average letter grades forumula (6 replies)
  17. Solved: UserForm Checkboxes (4 replies)
  18. Solved: wkb.close (5 replies)
  19. Date Format Issue from Input Box (4 replies)
  20. OLAP cubes and Pivot Tables (0 replies)
  21. Merging 2 identical tables - Access 03 (2 replies)
  22. Solved: Date not updated from the calendar popup (2 replies)
  23. Solved: with named range conditional format (2 replies)
  24. Solved: Ungrouping Columns if the exsist (2 replies)
  25. Run macro on cell text change (4 replies)
  26. Solved: How to find/calculate height & width of chart title in Excel VBA? (5 replies)
  27. Solved: Unique Defined Named Range and Validation List (12 replies)
  28. Exploring Userform Capabilities (4 replies)
  29. Solved: Run a program from VBA, and capture output (5 replies)
  30. SOLVED: Run macro all all open workbooks with one exception (4 replies)
  31. Copy String up to the 3rd Space (8 replies)
  32. Solved: help with excel vba... (8 replies)
  33. [SOLVED:] Solved: vlookup error 2042 (12 replies)
  34. Data Types in Cells (3 replies)
  35. Solved: MOD formula (14 replies)
  36. Solved: lookup for part of a cell (13 replies)
  37. Solved: Problem using PDFcreator 0.9.7 with Excel 2007 (10 replies)
  38. Macro with sum formula (1 replies)
  39. Subtotal or pivot table using date fields (3 replies)
  40. copy imported data into other sheet (2 replies)
  41. deactivate macro after "save as" (2 replies)
  42. How to clear repeating attachments (8 replies)
  43. Sorting in a Protected Worksheet (0 replies)
  44. Losing datagrid and flexgrid (1 replies)
  45. Copy and Paste from worksheets within Workbook (4 replies)
  46. Solved: The Dreaded #REF! (4 replies)
  47. Solved: creating pie chart with data from Access (12 replies)
  48. Solved: Some Sort of Lookup? (5 replies)
  49. Help with a matching code (8 replies)
  50. Pass User defined Type between two open Excel workbooks (4 replies)
  51. hyperlinks in excel (1 replies)
  52. Report Generation (8 replies)
  53. Quick CountA question (2 replies)
  54. Solved: Transfer separate ranges to one range (1 replies)
  55. Solved: VBA to search then copy found data (3 replies)
  56. [SOLVED:] LOAD/UNLOAD Pictures from/to Excel <> Access database (4 replies)
  57. How to sign digital certification by script or code? (1 replies)
  58. Automate Data Entry with Excel (1 replies)
  59. open form according to active workbook (1 replies)
  60. Solved: Compare Column Data (4 replies)
  61. Excel VBA/Email help (5 replies)
  62. Dynamically adding Calendar dates to table (4 replies)
  63. VBA to open excel file one sharepoint, copy the info and move to another work book (1 replies)
  64. republish sheets to html (0 replies)
  65. Solved: Referencing a Name Range with VBA (3 replies)
  66. Passing data from VBE to a range of cells (3 replies)
  67. Solved: Will there be VBA in Excel 2009 (3 replies)
  68. Solved: A basic script going wrong (23 replies)
  69. Error: The subject is not trusted for the... (0 replies)
  70. Solved: Populating a Listbox (ADO method Access '97 into Excel '97) (12 replies)
  71. [SOLVED:] Copy and Paste from other Workbooks with conditions (16 replies)
  72. Is it posible to use range("CR:CR").Find(value) to find a value between two numbers (4 replies)
  73. userform problem (2 replies)
  74. use code on a new workbook (1 replies)
  75. Solved: VBA Excel Question (22 replies)
  76. Solved: AutoPrint a worksheet (3 replies)
  77. Migrating Excel Table to SQL Server 2005 (5 replies)
  78. Solved: Find a cell with date<actual and delete row. (9 replies)
  79. Find and replace (3 replies)
  80. ControlProperty (2 replies)
  81. Solved: Copy & Paste data between 2 workbooks (14 replies)
  82. Get value of FillColour button (4 replies)
  83. code not working (5 replies)
  84. Solved: Tree Nodes as links (4 replies)
  85. Solved: Find a cell, copy, paste and delete (5 replies)
  86. sendkeys question (1 replies)
  87. Sleeper: Working with more than 65000 rows and Pivot Tables (1 replies)
  88. Values as per the combination (1 replies)
  89. Solved: Request simple test in Excel 2000 (3 replies)
  90. Solved: Preventing Workbook & Sheet Protect (3 replies)
  91. Solved: Opening form (2 replies)
  92. Solved: Forms in VBA (2 replies)
  93. make list by using countif (4 replies)
  94. Solved: Countblank Named Ranges (4 replies)
  95. Solved: Trigger a Validation based upon a cell value (5 replies)
  96. Solved: Cell Color change Vlookup (1 replies)
  97. Macro to copy value in another sheet in certain manner. (1 replies)
  98. macro triggered by row insertion (5 replies)
  99. Hide rows based on particular cell value (2 replies)
  100. Solved: time1 < time2 + 30? (6 replies)
  101. Solved: How to selct sheets starting with certain word (3 replies)
  102. Solved: Sumproduct Text Value (5 replies)
  103. Read Only file - Stop from asking for Save (3 replies)
  104. Solved: Error in sequence of data in treeview (6 replies)
  105. Loop to create number thru all sheet (5 replies)
  106. sum with several matches (2 replies)
  107. Solved: how to search cells in a column for a text string (3 replies)
  108. Vlookup formula entry (5 replies)
  109. Find Record (25 replies)
  110. Help with Finance calculation please (3 replies)
  111. Solved: Copying a cells "formating" into text (2 replies)
  112. Solved: Changing rows to columns???? (21 replies)
  113. Solved: Date picker userform - the size is changed (10 replies)
  114. vba copy (4 replies)
  115. Solved: I need somebody to fill in the missing part in this code (6 replies)
  116. Solved: Rearrange elements within 2D array randomly (3 replies)
  117. Macro to show shape based on adjacent cell outcome (3 replies)
  118. Solved: Setting Variable Equal to Cell Value (3 replies)
  119. Solved: Cross-Reference Two Cells Using Userform with RefEdit and Hyperlink (2 replies)
  120. Solved: Count non-identical codenumbers in big file (8 replies)
  121. CONSOLIDATION Formula Challenge (9 replies)
  122. Copying using a loop (4 replies)
  123. Loop Help for Newbie (6 replies)
  124. Solved: Force shape to be inserted in middle of cell (2 replies)
  125. unhiding all rows in all worksheets (3 replies)
  126. Solved: How can I copy a UserForm (and Module)? (6 replies)
  127. Agents sheets (2 replies)
  128. Code Tweak - PivotTable, Find (0 replies)
  129. How To Program Excel VBA code using VB.Net??? (7 replies)
  130. List tabs (2 replies)
  131. Solved: VLOOKUP in VBA not working (12 replies)
  132. Correct workbook name (3 replies)
  133. Solved: Clear content of a merged cell (9 replies)
  134. [SOLVED:] Probably So Easy It's Embarassing! (7 replies)
  135. file created date (1 replies)
  136. Collection (13 replies)
  137. A toggle button to highlight/unhighlight cells with formulas (2 replies)
  138. Solved: simple Instr doesn't work properly (7 replies)
  139. In need of a test vba to insert a value based on a date (2 replies)
  140. Solved: Fonts to shapes? Possible? (4 replies)
  141. very simple but stumping me big time (44 replies)
  142. Solved: Count rows which are identical with a cell (2 replies)
  143. Workbook Path - minus one folder (2 replies)
  144. Solved: Need to insert formula using macro (5 replies)
  145. Solved: Check Box (7 replies)
  146. Solved: Need some help with coding (2 replies)
  147. Solved: New to VBA - Help me in making this code shorter and better (18 replies)
  148. Userform Opacity (2 replies)
  149. A question on User defined function (1 replies)
  150. Solved: Delete specific cells not entire row (1 replies)
  151. Solved: Copy data into next empty cell (8 replies)
  152. Solved: how to display a cell value in a userform (3 replies)
  153. Solved: Simple loop not working properly (4 replies)
  154. Select a range by using a input box as a number (14 replies)
  155. Use cells for network paremeters in formulas (1 replies)
  156. Delete if duplicate (4 replies)
  157. Solved: counting unique in vba (16 replies)
  158. Shrink VB Code (12 replies)
  159. Solved: Disabling Messages In Excel During Macro Runtime (3 replies)
  160. Solved: Vlookup , not working, returning wrong values (2 replies)
  161. For Next Loop problems (5 replies)
  162. Solved: Summing same row twice. (4 replies)
  163. Group by string value and perform operation (7 replies)
  164. Lost - asFormula2 = asFormula2 (9 replies)
  165. Stop Excel Showing (3 replies)
  166. Copy/transfer data from one sheet to another (5 replies)
  167. Solved: On Error Goto Failing (2 replies)
  168. Solved: Cell Reference (6 replies)
  169. Schedule Event on First Business Day of Month (1 replies)
  170. Solved: Copy Rows w/in a Range Only if Condition Met (7 replies)
  171. Cheap Code Writing Digi ID besides Verisign (4 replies)
  172. Making command buttons visible (1 replies)
  173. Solved: CommandButton on a worksheet (11 replies)
  174. Macro causing Excel 2003 to crash (code included) (1 replies)
  175. Solved: Listbox - Double Click to add data into userform field (10 replies)
  176. [SOLVED:] Copy Method of Worksheet Class Failed (5 replies)
  177. detect changed cell in a column (7 replies)
  178. Solved: Match across 2 columns (6 replies)
  179. Protected Worksheet - Excel bug? (11 replies)
  180. Code Error's (1 replies)
  181. erase #value! (1 replies)
  182. Solved: ListBox ,select wbkb, open in Sub (6 replies)
  183. Form Opens Multiple Times (2 replies)
  184. Solved: Changing Number Format of Variable Values (6 replies)
  185. Solved: Excel Division (4 replies)
  186. PDFCreator Problems with Excel (2 replies)
  187. Solved: Manage similar events with textboxes (27 replies)
  188. Find and Replace Loop (5 replies)
  189. Code crashes when closing workbook (6 replies)
  190. select/use active pivot, vba (0 replies)
  191. Solved: Looping through workbooks instead of worksheet (8 replies)
  192. Solved: Help using the RefEdit Control (2 replies)
  193. Exporting data to Outlook Calendar (0 replies)
  194. dictionary userform (1 replies)
  195. Tab Order (1 replies)
  196. Run code on workbook open (1 replies)
  197. Custom Pivot Table Drilldowns in Excel 2007 (0 replies)
  198. IE Automation form Javascript (3 replies)
  199. Help button to open pdf or chm (4 replies)
  200. Solved: Solved....Locking Cells? (5 replies)
  201. Pasting Special Cell into different sheet (3 replies)
  202. Solved: Macro to find code in many columns and copy findings (not easy) (7 replies)
  203. Solved: Data Validation: Drop-Down Text Size (3 replies)
  204. Solved: Cut a Long list in half and paste into a new Column (2 replies)
  205. Solved: How can I test a Form Label to see if it is contained in a given Form Frame? (4 replies)
  206. Solved: Macro won't loop to second worksheet (3 replies)
  207. Solved: end if without block if? (2 replies)
  208. Solved: Do loop problem is last row (65536) reached (4 replies)
  209. Solved: Update Recordset from VBA Not Working (3 replies)
  210. Highlighting filtered columns - automatically (1 replies)
  211. Summing all rows in a column in a specified worksheet (7 replies)
  212. Solved: Moving Copying and Deleting A Sheet (3 replies)
  213. Solved: password to modify (1 replies)
  214. Solved: Do I need SUMIF for this problem? (6 replies)
  215. how to get the language installation (3 replies)
  216. Building a hierarchy (3 replies)
  217. Solved: VBE to change Line Chart Height based on number of Rows (5 replies)
  218. generate matrix from table? (5 replies)
  219. Getting Unique elements of Array (13 replies)
  220. Solved: Fastest way to divide all rows in column C by a fixed number, put results in column D (5 replies)
  221. Context specific help (WhatsThisHelp) (0 replies)
  222. Soooo Sloooow! (3 replies)
  223. Deleting rows, adding columns and Excel formulas (5 replies)
  224. Solved: Assistance With a ComboBox (6 replies)
  225. Install addin for everyone (2 replies)
  226. Creating a macro to copy formulas (2 replies)
  227. get particular data from outlook mail into excel using VBA (0 replies)
  228. Understanding Multi Column Listbox (2 replies)
  229. Solved: Pop up errors/boxes when running macro (2 replies)
  230. How to make this VBA better (18 replies)
  231. Solved: Code to check that a worksheet name from an inputbox is valid? (7 replies)
  232. Paste Named Range (4 replies)
  233. Solved: How the Code Works? (4 replies)
  234. Runtime error while using Advanced filter (2 replies)
  235. Wont let me select range (13 replies)
  236. Inserting default character(s) when submit button is pressed (1 replies)
  237. Data Range Issue (1 replies)
  238. Error handler not working (4 replies)
  239. Solved: Help please...input box issue... (8 replies)
  240. Solved: Excel data to Word bookmarks (2 replies)
  241. Solved: Date Format in UserForm (4 replies)
  242. Solved: Problem initializing Class after adding an ActiveX control (6 replies)
  243. Solved: chart sheet and work sheet (2 replies)
  244. Create an access database by a VBA in Excel (4 replies)
  245. Double Click (3 replies)
  246. Solved: Saving worksheets as separate workbooks (3 replies)
  247. Named Ranges (4 replies)
  248. Solved: Import HTML Query Named range issue (8 replies)
  249. Return text in cell based on match of multiple criteria (0 replies)
  250. Building a data base from Real-Time Data (5 replies)