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. Relate 2 Tables in Excel Database (3 replies)
  2. Pivot Table with ADO (2 replies)
  3. Pivot Table Calculated Field (2 replies)
  4. Formatting issues (15 replies)
  5. Solved: auto copy and sort on change 2 columns (6 replies)
  6. Solved: How to maintain control as nested subs exit? (10 replies)
  7. Sending Info from Excel to Word (1 replies)
  8. Solved: Write a Small Procedure for me please? (7 replies)
  9. Copy and paste based on two criteria (3 replies)
  10. Solved: Generating numbers in excel (4 replies)
  11. finding merged cells (8 replies)
  12. Solved: Macros wont run even with security set to low (1 replies)
  13. formatting macro in VBA (7 replies)
  14. Solved: Run-Time Error 5 Invalid proc. call or argument (3 replies)
  15. Solved: Check Outlook version (1 replies)
  16. Solved: Subscript out of range on .Find (2 replies)
  17. [SOLVED:] Macro Record: What Module does it store it in (5 replies)
  18. Mkdir (9 replies)
  19. Solved: Apportioning Query (4 replies)
  20. Finding correct blank cell (10 replies)
  21. import data to update charts (5 replies)
  22. Solved: Sheet names (2 replies)
  23. Solved: List Box Selection To Text Box (12 replies)
  24. Any help to tweak the following code much appreciated (3 replies)
  25. Solved: Run macro in other sheets. (1 replies)
  26. Solved: Run Time Error 91 (9 replies)
  27. Performing an operation on several cells at once (8 replies)
  28. Nested Loops? (8 replies)
  29. Solved: Copy Certain Rows into Master Workbook (8 replies)
  30. how to parse through pivot filtered items (0 replies)
  31. Cutting up a table (3 replies)
  32. How to Prevent Insertion / Deletion of Worksheet (4 replies)
  33. Coordinates for my shape and placing the cursor (12 replies)
  34. Finding the sum value of permutations... (21 replies)
  35. Solved: Does sumproduct work with OR (25 replies)
  36. cleaning a cell (6 replies)
  37. Getting the value that WAS in the cell just deleted (6 replies)
  38. Solved: Update Userform after changes have been made on another useform (14 replies)
  39. Userform Validation Issues (25 replies)
  40. Help with CreateObject function (0 replies)
  41. Solved: Row count of non-Active worksheet (6 replies)
  42. Excel behave like a multi-user database? (11 replies)
  43. Solved: Relative range for advanced filter (5 replies)
  44. Solved: Read 'live' LOG file (23 replies)
  45. List Controls on Worksheet (6 replies)
  46. Solved: WINAPI problem:project:control any sw from vba(with sendkey+mouseclicks) (5 replies)
  47. Solved: Deactivate workbook close button (15 replies)
  48. Reversing the process (11 replies)
  49. Solved: Filling a simple array (4 replies)
  50. loop that copy sheets in the same workbook (13 replies)
  51. Autonumbering (6 replies)
  52. importing data from other spreadheet (3 replies)
  53. VB How far backwards compatible? (1 replies)
  54. Format Specific Rows (2 replies)
  55. New VBA Code needed (1 replies)
  56. code for all possible cases (3 replies)
  57. Deleting row when a condition is met (7 replies)
  58. Excel Sheets Opens Itself Again After ADO Query ! (8 replies)
  59. Conditional autofilter based on form (27 replies)
  60. Amending VBA Script (3 replies)
  61. Solved: Extremely Slow Performance (5 replies)
  62. Solved: Row copy (6 replies)
  63. Solved: Delete specific word from rows, add specific words to others (9 replies)
  64. Solved: auto sort 2 columns after second column input (3 replies)
  65. Generating data using a loop (4 replies)
  66. Solved: save user selected sheets into new workbook (10 replies)
  67. how to run when print is cancelled (3 replies)
  68. [SOLVED:] Remove last two characters from string (2 replies)
  69. Solved: ayto formatting (3 replies)
  70. Replace #DIV/0! ERROR as blank cell (3 replies)
  71. Solved: Method of 'Range' failed error (3 replies)
  72. Convert Formula from R1C1 to A1 (5 replies)
  73. Delete Data if Less then Yesterday (6 replies)
  74. Auto Sort Entries (5 replies)
  75. Locking a module rather than the whole project (3 replies)
  76. Find Last Used Cell of Visible Cells (9 replies)
  77. Cell comparison (3 replies)
  78. Solved: help for selective highlight of rows (8 replies)
  79. [SOLVED:] Left loop (3 replies)
  80. master detail filtering (2 replies)
  81. Solved: macro to format cells (4 replies)
  82. List of all open workbooks (17 replies)
  83. chart with vba (17 replies)
  84. How: to check whether an element in chart is exist or not (8 replies)
  85. Solved: countif query & more... (5 replies)
  86. Solved: Percentage in VBA (7 replies)
  87. Solved: Copy Filtered list from Sheet 1 to Sheet 2 (7 replies)
  88. Unlocking the Pasword Protected File (4 replies)
  89. Solved: www.youtube.com (2 replies)
  90. VBA code for Vlookup in 2 wkbooks and import to master (1 replies)
  91. Help: Set Chart Source (2 replies)
  92. Automation Error - Object has diconnected from Clients (5 replies)
  93. Userforms (6 replies)
  94. Solved: What's wrong with this picture (5 replies)
  95. Copy/Paste macro (7 replies)
  96. [SOLVED:] List of Worksheet Tab Names (11 replies)
  97. Solved: Split large data into various column (7 replies)
  98. Solved: Loop Problem (4 replies)
  99. Solved: Working Code not finding server folders (4 replies)
  100. Solved: Macro auto change name in VBE (6 replies)
  101. Help: How to keep indirect() function unupdate value... (1 replies)
  102. Disable Ctrl key actions (15 replies)
  103. Solved: multipage userform adding pages (3 replies)
  104. Solved: Loop problem: Trying to write data to 5 cols (13 replies)
  105. Need help with finding duplicates per column (4 replies)
  106. Solved: charting help needed (2 replies)
  107. Solved: Automatic change in Title Bar (9 replies)
  108. Multiple Range Loop (3 replies)
  109. Importing Text Files (4 replies)
  110. Calculation problem (7 replies)
  111. Solved: Extract data from different worksheets & multiple workbooks using certain folder (18 replies)
  112. Solved: Loop To Populate Formula (5 replies)
  113. change the vlookup via a macro (1 replies)
  114. Cut and paste question (10 replies)
  115. OLE to RGB conversion (4 replies)
  116. [SOLVED:] Back to it original location (5 replies)
  117. Assistance with code (2 replies)
  118. Solved: Execute macro every n minute (7 replies)
  119. How to prevent copying of cell data (4 replies)
  120. query error (3 replies)
  121. Solved: Application.Wait question (3 replies)
  122. Splash Screen (12 replies)
  123. Newbie question (9 replies)
  124. use excel to import another excel file (3 replies)
  125. Solved: Run time error 91 (12 replies)
  126. Solved: Control Chart Window (3 replies)
  127. Chart problems with MS Excel. (11 replies)
  128. Need Assistance on VBA Code (2 replies)
  129. turn a chart (3 replies)
  130. [SOLVED:] Zooming in and out of a graph (3 replies)
  131. group column and sum column (13 replies)
  132. Check the order (12 replies)
  133. Excel Workbook & Tabs List (2 replies)
  134. Send ectivesheet in body of email(OUTLOOK EXPRESS) (1 replies)
  135. Opening the Save As Dialog in a Specific Directory (2 replies)
  136. get data macro (2 replies)
  137. Copy losing data (1 replies)
  138. Joining text in selected cells (2 replies)
  139. Solved: csv file problem (14 replies)
  140. Reducing workbook size. (10 replies)
  141. Creating one list by comparing two list of different formats (13 replies)
  142. Solved: how to detect white/blank space in a row? (7 replies)
  143. Solved: Put quotes around text in cells (3 replies)
  144. Set TempCell : Object variable not set (2 replies)
  145. Solved: Formula help please! (5 replies)
  146. Solved: MySQL Excel file uploading (0 replies)
  147. Help: Defined Array Formula In chart (6 replies)
  148. Is it possible to..... (15 replies)
  149. Select Case Construct Help (6 replies)
  150. Solved: Formula needed to match dates with MIN & MAX values (6 replies)
  151. Solved: Move rows to second worksheet based on value (2 replies)
  152. Create report code help (5 replies)
  153. macros buttons & toolbars (2 replies)
  154. linking two set of data (2 replies)
  155. VBA to return ID of person logged on (2 replies)
  156. Solved: Clearing Color Formats (6 replies)
  157. Solved: Referencing a Sheet w/ Sheet Index Question (17 replies)
  158. Solved: Force to go to page based on condition (3 replies)
  159. Pasting issues (6 replies)
  160. Solved: TextBox and Label Calculation (31 replies)
  161. Formating Macro (1 replies)
  162. Solved: Useforms Active Cell Selection (5 replies)
  163. Solved: Insert Header problem... (3 replies)
  164. problems using the Shell() function (4 replies)
  165. Listbox Display (5 replies)
  166. Macro Cell Borders (5 replies)
  167. Help converting Addin to library... (3 replies)
  168. Changing Short-cut key (2 replies)
  169. Solved: Possible error- VBE does not Change to Uppercase Syntax. (4 replies)
  170. Perform SaveAs and Delete Original Copy (7 replies)
  171. Solved: New calculator Basic Formulas (5 replies)
  172. Help:How to creat matrix bar chart (9 replies)
  173. Blinking Title Bar in a User Form (3 replies)
  174. [SLEEPER:] Creating a floating button? (7 replies)
  175. data extract (0 replies)
  176. Solved: Error handler in sheet add event (3 replies)
  177. Solved: Button to save selected sheets to new workbook (26 replies)
  178. Solved: Substitute Sheet Name in SUM if Function (2 replies)
  179. Listbox questions (1 replies)
  180. How to change contents of a cell depending on adjacent cell (9 replies)
  181. Macro Match Destination formatting (1 replies)
  182. Same code produces two different sets of results (9 replies)
  183. Make a logfile with all Variables in the Application (2 replies)
  184. Solved: Add column to a report (4 replies)
  185. Search Internet (2 replies)
  186. Rows in selection (4 replies)
  187. Save Conct to Variable (4 replies)
  188. incrimental save (2 replies)
  189. save workbook without macro's ? (2 replies)
  190. Solved: Conditional Formatting problem (3 replies)
  191. Solved: help with test Calculator in a useform (9 replies)
  192. Solved: Passing objects into procedure (16 replies)
  193. Solved: macro to edit links (2 replies)
  194. Automatic Row insertion (0 replies)
  195. Solved: Disable an option in a menu (7 replies)
  196. Replace Name of Source Workbook in Target Code (18 replies)
  197. Formula explanation (6 replies)
  198. Solved: Print text box contents in a userform (9 replies)
  199. select active printer (2 replies)
  200. add comments to documents summary (1 replies)
  201. Disabling save/as in a specific workbook (5 replies)
  202. Restoring a worksheet using a Macro (15 replies)
  203. Number Comparison (8 replies)
  204. Solved: Converting all files in a directory using VBA (18 replies)
  205. How do I check for data (1 replies)
  206. Userform Question (2 replies)
  207. FSO Properties (0 replies)
  208. Hyperlinked List of Directory Contents (4 replies)
  209. Determine if a file has been updated (4 replies)
  210. Solved: How Can I Disable A Macro from Another WB? (4 replies)
  211. New to VBA - Importing data based on a cell value (5 replies)
  212. Read cell contents from a closed file? (3 replies)
  213. Solved: The Macro "macroname" Cannot Be Found (13 replies)
  214. Solved: Test if a Column Field Exists in Pivot Table (4 replies)
  215. Checking for Optional Argument (10 replies)
  216. Open text file and delete lines. (4 replies)
  217. Amend code - Important - Please (3 replies)
  218. Solved: Create pivot table help (6 replies)
  219. Stumped with XL 2007 Add-Ins Tab (9 replies)
  220. Copy and Paste data from multiple cells (9 replies)
  221. My first userform (4 replies)
  222. Help with sorting data (2 replies)
  223. Solved: How do I get the formulas to work on my userform (16 replies)
  224. Relative scales (4 replies)
  225. Solved: How to initialize scroll bar w/o active object (4 replies)
  226. Copying Excel charts To Powerpoint via VBA (3 replies)
  227. Solved: Selecting the one row above with the relative range (3 replies)
  228. Formatting table in Word using Excel VBA (1 replies)
  229. Solved: Quarter Hours? (9 replies)
  230. Short cut keys won't run entire macro (4 replies)
  231. Solved: Install Add in and set reference (21 replies)
  232. Run a Private Sub from a Keyboard Shortcut (8 replies)
  233. Solved: application/object defined error when .IsAddin is true, but not false (3 replies)
  234. Solved: Basic Question: EntireColumn Property statement (10 replies)
  235. changing sheet tab colour (4 replies)
  236. [SOLVED:] Help with Autoformat pls (9 replies)
  237. Solved: Moving data from sheet1 to sheet 2 (3 replies)
  238. Paste excel table into Word and then format? (1 replies)
  239. Solved: Clear cells in column A if column B has a zero (2 replies)
  240. sumif across multiple sheets (10 replies)
  241. copying data extact match vba code (6 replies)
  242. Solved: How To Find "Max Value Of A Collection" ? (7 replies)
  243. Solved: Bypass "Enable macros" warning (4 replies)
  244. Solved: detect which version of excel is running (4 replies)
  245. Solved: Dealing with numbers with leading 0's (4 replies)
  246. Using Access Queries in Excel (3 replies)
  247. Time Tracking (7 replies)
  248. Solved: loop not working (4 replies)
  249. Excel Sheet "Save As" Text File without altering active document. (8 replies)
  250. UDF to Calculate the Month (3 replies)