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. tough one, vba open,save,close a third party app (2 replies)
  2. Inserting a Row (1 replies)
  3. Your thoughts on shared workbooks (20 replies)
  4. Solved: CountIF with VBA (13 replies)
  5. Solved: Reduce size of Pivot Table Workbook (1 replies)
  6. Solved: Changing String to Integer (3 replies)
  7. Exporting info from a VBA custom Dialog Box (1 replies)
  8. Solved: Sorting a column (1 replies)
  9. inserting pictures thru VBA (1 replies)
  10. Solved: Use Excel to force Access to compact & repair database (2 replies)
  11. Solved: Displaying Cells with HTML-code properly (10 replies)
  12. select ranges on different worksheets (1 replies)
  13. [SOLVED:] Accounting format alignment change (4 replies)
  14. Resolve Conflicts (Shared Workbook) (1 replies)
  15. Excel Report on VB Form (1 replies)
  16. Solved: Error Handler Routine Problem (2 replies)
  17. Solved: searching for a largest value (15 replies)
  18. Export Excel data to Word template (14 replies)
  19. Sleeper: Dates in Pivot Table (2 replies)
  20. Solved: how do I close other app with vba (2 replies)
  21. VBA Excel Userform Multiple Condition Stump (16 replies)
  22. Lookup Help (3 replies)
  23. Update two cells by changing another (6 replies)
  24. DLL Advice? (0 replies)
  25. Lookup Help (2 replies)
  26. Solved: If Range empty (15 replies)
  27. Can you tell if a open book has this workbook as a reference (4 replies)
  28. Solved: Copy/Paste cells? (3 replies)
  29. "On Change" event usage (3 replies)
  30. Run macro only for specific worksheets (7 replies)
  31. Solved: how do I execute a macro on a cell click (12 replies)
  32. Sleeper: Comment location & Open Office (4 replies)
  33. Solved: sort string and match the data (7 replies)
  34. add save macro (4 replies)
  35. getting image from userform image control (3 replies)
  36. Adapt KB by mdmackillop (0 replies)
  37. Solved: Match 2 worksheet and reconcile (3 replies)
  38. Grouping Unique Records inside of Groups (4 replies)
  39. arrays (20 replies)
  40. SSH via VBA and querying return stream (4 replies)
  41. Connecting & Downloading via FTP (2 replies)
  42. Solved: simple question regarding OptionButton Controls (2 replies)
  43. [SOLVED:] Look for the duplicate Records Before entering in database sheet (5 replies)
  44. Solved: Two Listboxes (1 replies)
  45. Column and row label fonts (1 replies)
  46. Cannot Print Excel File In Color (13 replies)
  47. Copy inputbox-selection of multiple files in a new spreadsheet on new rows (26 replies)
  48. [SOLVED:] Insert Image in user form via vba (6 replies)
  49. Solved: Convert sale amounts .. (16 replies)
  50. Adding Text boxes to a Lable (3 replies)
  51. [SLEEPER:] Error Handler Routine (excel 97) (8 replies)
  52. Time format, that exceed 10000h ([h.mm]) (1 replies)
  53. Excel Drop Down (2 replies)
  54. Solved: Include Date In Code (2 replies)
  55. Solved: Date Picker Control (34 replies)
  56. Need help with looping (1 replies)
  57. Solved: Find if then statement help please! (8 replies)
  58. Lock populated cells (5 replies)
  59. Cell reference consisting of column and row (1 replies)
  60. Solved: Job Time Problem (5 replies)
  61. Global failure (1 replies)
  62. Help!!! About the statistics of data Help!!! (8 replies)
  63. Help!!! About the statistics of data Help!!! (0 replies)
  64. Solved: Help Removing Duplicates (6 replies)
  65. multiple Cell formatting based on cell value (6 replies)
  66. Solved: Combobox - Linked List (5 replies)
  67. Need help shortening run time (17 replies)
  68. Solved: book in use by "another user" (0 replies)
  69. Solved: pipelineworksheet (1 replies)
  70. Solved: UDF to select a particulr range automatically (4 replies)
  71. Solved: open as read only (6 replies)
  72. Solved: formula updating call stack (5 replies)
  73. Solved: Hide Sheet When Closing the File (6 replies)
  74. Solved: Formula Repeats itself?? (9 replies)
  75. Solved: Text/Number Format on Listbox (2 replies)
  76. Paste into next available column (3 replies)
  77. Solved: circular references and entering code back into cells (4 replies)
  78. Provider Could Not Be Found - ADODB - YIKES!! (6 replies)
  79. Vlookup in macros (7 replies)
  80. Auto Install Office Assistance (0 replies)
  81. Solved: Protect Sheet & Workbook (4 replies)
  82. Solved: i am puzzled with it, please give some tips (5 replies)
  83. What Is WorkSheet ?REG?? (2 replies)
  84. Extract information from close workbooks (1 replies)
  85. Combobox on a form (3 replies)
  86. Importing an excel worksheet into another workbook(which has a prexisting table) (2 replies)
  87. Menu Keyboard Shortcuts (3 replies)
  88. Automatic updation (3 replies)
  89. copy values with criteria (0 replies)
  90. Solved: password protected file (24 replies)
  91. Return Max Value (3 replies)
  92. Copy cell sheet2 in sheet 1 (6 replies)
  93. Solved: referencing a record in a recordset (2 replies)
  94. Select Case using date ranges (5 replies)
  95. select path of file (6 replies)
  96. Click End on code break closes excel application (2 replies)
  97. Solved: Define Name question (3 replies)
  98. Solved: Advanced filter techinques? (4 replies)
  99. Copy worksheet based on condition to other workbook (6 replies)
  100. cells.find ....need help! (4 replies)
  101. Solved: Dynamic array for Worksheets (5 replies)
  102. Complex multi-spreadsheet quandry (1 replies)
  103. Solved: VBA Newbie (6 replies)
  104. Returning focus to previous workbook after opening another workbook (3 replies)
  105. Solved: FormulaR1C1 giving error 1004 (3 replies)
  106. How do you disable cut, copy & paste for multiple cells? (3 replies)
  107. Saving to a particular tab (11 replies)
  108. [SOLVED:] Userform - Countdown Timer (10 replies)
  109. Need Help In VBA Script for sending Mail though OutLook with Excel (1 replies)
  110. Solved: help looping through columns (1 replies)
  111. Transpose Function (0 replies)
  112. Importing into excel (5 replies)
  113. Personal Stock Portfolio Tracker - Help Needed (0 replies)
  114. How to improve my code!? (7 replies)
  115. vba conditional formatting and multiple ifs (9 replies)
  116. [SLEEPER:] VLookup with GETPIVOTTable (2 replies)
  117. Hiding or unhiding columns based on result of calculated field (3 replies)
  118. Solved: what does -- do (2 replies)
  119. [SOLVED:] Cancel parameter in macros (2 replies)
  120. Solved: Is DoEvents really that slow (1 replies)
  121. Solved: page breaks (2 replies)
  122. Solved: Magazines (1 replies)
  123. Filter records basis inputs in form (2 replies)
  124. Providing access to certain macros to all users (1 replies)
  125. Solved: Finding .zip files in directory (7 replies)
  126. Copy from a single cell to a merged cell (3 replies)
  127. Show date and time (1 replies)
  128. [SOLVED:] Cell Colour Format from front sheet (14 replies)
  129. Different ways to call a sub or a function (2 replies)
  130. Solved: Indirect not working with sme Yahoo tickers (2 replies)
  131. VBA Get InternetExplorer Object (2 replies)
  132. Solved: Filtering Out Rule Names & Choosing Records (2 replies)
  133. how to auto-fill (13 replies)
  134. Sum Unique items from Advanced Filter (2 replies)
  135. delete entire rows with criteria (4 replies)
  136. Solved: Create Invoice from datalist (6 replies)
  137. Solved: VBA Transfering data from excel into a word document. (6 replies)
  138. need vba help in excel (1 replies)
  139. How to creata a History file without sharing (7 replies)
  140. Dynamic List of Unique Records (5 replies)
  141. Filter rows on multiple criteria within a single column (3 replies)
  142. .formula hyperlink problem (8 replies)
  143. Timer (1 replies)
  144. Locking cells for editing. (2 replies)
  145. Delete Hyperlink from Each cell (7 replies)
  146. Rows to Columns (8 replies)
  147. Access functions from Excel (2 replies)
  148. Solved: Code Errors out on Pivot Tables (1 replies)
  149. Solved: Shell Help (5 replies)
  150. Solved: auto changing cells (4 replies)
  151. Solved: Folder path (11 replies)
  152. Solved: Excel 2003 converted to Excel 2007 help. (11 replies)
  153. Charting data from a changing linked cell over time (9 replies)
  154. can anyone help me convert in this formate 8' -5/8" into 100.625 inchs (19 replies)
  155. Solved: Pivot Table(s) - Refresh (9 replies)
  156. Excel to Word using Bookmarks (8 replies)
  157. Solved: Shell Winzip Error (1 replies)
  158. Using SheetChange Events with validation (4 replies)
  159. Userform - Shared Wookbook - Error (1 replies)
  160. Filldown is not working as desired (6 replies)
  161. Solved: Toolbar Menu Icon- Caption problem (5 replies)
  162. Solved: macro to remove data from list (5 replies)
  163. Drag and Drop between ListViews (10 replies)
  164. Solved: VBA Internet Explorer References (21 replies)
  165. VBA Help Moving XL Cell Contents based on data type (6 replies)
  166. Warning message after Update links (8 replies)
  167. Solved: Delete blank rows. (7 replies)
  168. [SOLVED:] MS Query / Pivottable / NamedRanges question (4 replies)
  169. Building a Calendar in Excel? (6 replies)
  170. Time Sheet Creation (2 replies)
  171. commandbar combobox (2 replies)
  172. Alternative to ActiveSheet???? (5 replies)
  173. Can't find the personal macro workbook (4 replies)
  174. [SOLVED:] About referring to cells (3 replies)
  175. UserForm - Search/Update Form (9 replies)
  176. Maintaining a ADO connection (1 replies)
  177. Conversion to PDF (3 replies)
  178. Solved: How To Copy Sheet1's CodeModule To An Another Sheet1's CodeModule? (4 replies)
  179. new document creation based on the criteria (2 replies)
  180. Solved: Moving Data from one sheet to another based on a value in one cell. (6 replies)
  181. Userform - Transition effect (0 replies)
  182. Solved: Copying text from 7 textboxes via cmdButton (5 replies)
  183. Solved: Count Function (2 replies)
  184. Solved: Test for correct display. (6 replies)
  185. Dynamic MultiDimensional Arrays - setting and accessing the various layers (3 replies)
  186. copy and paste with if (8 replies)
  187. Protecting the worksheet disables the links in the locked cells (3 replies)
  188. Solved: Use a Formula in code (4 replies)
  189. Text in Footer overlaps data in spreadsheet (9 replies)
  190. Extrange Protection Behavior (1 replies)
  191. Solved: Userform - Populate textbox with result from popup (3 replies)
  192. Self-Populating cells with unique iidentifiers... (1 replies)
  193. Create comment with previous cell contents (2 replies)
  194. extract data from a closed workbook (18 replies)
  195. [SOLVED:] Get Full File Path (8 replies)
  196. Solved: Copying Columns and retaining Hyperlinks (5 replies)
  197. Solved: Data Validation List - Refresh (2 replies)
  198. Solved: VBA Hide Rows if Cell Value is #N/A (9 replies)
  199. Date calc (1 replies)
  200. Solved: Find multiple values in range (5 replies)
  201. VIEW CODE (6 replies)
  202. Forms in Frames Work-around (3 replies)
  203. Force Macro Help. (6 replies)
  204. Cannot find #REF (3 replies)
  205. Need code to attach a file to outlook (2 replies)
  206. Help with Vba script (3 replies)
  207. Need Help: reorganizing exported info (6 replies)
  208. Solved: Toggle line of code (2 replies)
  209. How to access a campus ldap server (anonymous-bind)) (1 replies)
  210. Solved: Looping through Workbook Worksheet objects won't work (4 replies)
  211. [SOLVED:] FormulaR1C1 Not Working (16 replies)
  212. Solved: VBA Loop Using FormulaR1C1 (4 replies)
  213. Solved: Format error? (9 replies)
  214. How to avoid print dialog box? (4 replies)
  215. Solved: Search form (11 replies)
  216. cmdButton for Next & Previous records (4 replies)
  217. [SLEEPER:] Customize right click menu on chart (15 replies)
  218. help edit vba code - 2003 column limit (0 replies)
  219. Solved: updating many functions in a sheet together (1 replies)
  220. Copy Range To Array (5 replies)
  221. Request Assistance With VLookup, Index & Match (1 replies)
  222. Database Userform VBA Code Help Please (10 replies)
  223. Message Box before opening Workbook asking for Telephone number (3 replies)
  224. [SOLVED:] Vertical pagebreak and dragging off (7 replies)
  225. OPEN DATA FORM (1 replies)
  226. Solved: VBE Help (2 replies)
  227. VBA Array Syntax (4 replies)
  228. sort by font color (2 replies)
  229. [SLEEPER:] Writing aa VBA code (3 replies)
  230. Solved: is it possible to return a formula into a cell? (17 replies)
  231. Genrate simple calculations and check them (6 replies)
  232. Read-Write Message Text files (5 replies)
  233. Solved: Ucase (11 replies)
  234. Export only one Sheet without deleting the others? (2 replies)
  235. copy rows to new sheet (4 replies)
  236. [SOLVED:] Excel - Colourfunction (2 replies)
  237. VBA Macros Help (1 replies)
  238. Sleeper: VBA % Calculation (4 replies)
  239. problem with subtract (3 replies)
  240. general question (6 replies)
  241. Search for Record in Userform (10 replies)
  242. get the Name displays in Start Menu (5 replies)
  243. Solved: Macro in Excel to update/overwrite tabs of the same name (7 replies)
  244. Solved: Data Validation - Avoid Duplicate Entries (5 replies)
  245. Extracting data from various excel reports using VBA (21 replies)
  246. Disable Save As option (9 replies)
  247. Solved: Non-VBA help - VLookup type thing (11 replies)
  248. Open a specific word doc (3 replies)
  249. Help with Creating directories & subdirectories (2 replies)
  250. copy and paste macro (2 replies)