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. Macro to link more than one spreadsheet and automate (0 replies)
  2. Macro To Not Allow Saving As When Specific Fields Are Left Blank (5 replies)
  3. Solved: how can a textbox with date returns to the same textbox after error handler. (2 replies)
  4. Solved: VBA to post data to a servelet? (8 replies)
  5. match backwards (2 replies)
  6. Help with Sort macro based on Data Valiation value (5 replies)
  7. Solved: Disable the move or copy sheet (6 replies)
  8. How to create Login & Log out Spread sheet in Excel with automated Attendance sheet (2 replies)
  9. Pull info from Outlook to Excel (1 replies)
  10. Position ListBox scrollbar (1 replies)
  11. Solved: What are good effective ways to error handle and bug fix a macro in ms excel? (5 replies)
  12. Solved: move between cells on a filtered list (2 replies)
  13. Solved: Help with a formula please (6 replies)
  14. Solved: comboboxes on a worksheet (6 replies)
  15. Solved: Write out class data (11 replies)
  16. Solved: Type mismatch "rumtime error 13" (5 replies)
  17. VBA: Blank Cells Based on Value (3 replies)
  18. I need to use a list rather than hard coding criteria and duplicating the code (17 replies)
  19. Lock the column in sheet irrespective of sheet either in protection or unprotection (0 replies)
  20. Solved: 3 mulitilink comboboxes (2 replies)
  21. Solved: I'm new and need some help with some cell editing in vba (Excel) (2 replies)
  22. Solved: Refering Sheet without using Sheet name in VBA Code (2 replies)
  23. Use VBA for totals for Pivot Chart (0 replies)
  24. VBA Macro For Column Header & Deleting Column (1 replies)
  25. Combobox (1 replies)
  26. run time error 1004 (1 replies)
  27. Solved: Use text from a cell reference in vba code. (20 replies)
  28. Solved: Canceling a BeforeSave Event (6 replies)
  29. Select Row Based off remote cell value (2 replies)
  30. Wait for a cell to be selected... (6 replies)
  31. Solved: Compiler error: Object required. (2 replies)
  32. Setcurrentdirectory not using API? (5 replies)
  33. Solved: Password protection for Macro enabled sheet (6 replies)
  34. Please help a fellow out! Feeding workbook, macro not working cuz some obscure reason (1 replies)
  35. [SOLVED:] Dynamic Variable within formula? (3 replies)
  36. macro for selecting all rows with a specifice font colour in the cell and copy/paste (2 replies)
  37. Please help with VBA project (3 replies)
  38. Solved: VBA Code for Protection of file (2 replies)
  39. Solved: How to e-mail 2 worksheets? (3 replies)
  40. Solved: Make a Sound When a Cell is Changed to a Certain Value (6 replies)
  41. Solved: Insert one blank row after sort 3 columns (17 replies)
  42. pivot table (1 replies)
  43. Events planner (5 replies)
  44. Solved: Copy button to second sheet causes error (3 replies)
  45. Insert picture in cell comments (2 replies)
  46. Excel 2007 - Can not set link update to Manual (0 replies)
  47. VBA for Formatting Worksheet (9 replies)
  48. Solved: VBA for # of Rows Limit (15 replies)
  49. Loop textbox to cell (5 replies)
  50. Help with variable cell range (3 replies)
  51. Loop Through Subfolders And Copy Sheet (4 replies)
  52. how to replace part of r1c1 formula with cell value? (5 replies)
  53. Solved: Unable to update data in db using ADODB connection (2 replies)
  54. concatenate text with .offset (0 replies)
  55. Creating a loop within a loop? (8 replies)
  56. Macro To Not Allow Printing When Specific Fields Are Left Blank (5 replies)
  57. Solved: logic help (2 replies)
  58. Text overlay (1 replies)
  59. Sleeper: Conditional Formatting (1 replies)
  60. [SOLVED:] How to change the color of the columns in the chart? (1 replies)
  61. Streaming via xmlHTTP to DOMDocument (0 replies)
  62. Solved: Duplicating a worksheet (3 replies)
  63. Solved: Populate Drop Down Box with SQL Query (3 replies)
  64. Solved: Clearing Option Buttons (1 replies)
  65. COUNTING (6 replies)
  66. write (3 replies)
  67. Solved: Limit to 4 decimals in textbox using VBA (13 replies)
  68. search text (0 replies)
  69. Ignore blank cells in a named range when using dependent data validation (3 replies)
  70. Dynamic Ranges for Charts (2 replies)
  71. delete entire rows (1 replies)
  72. Solved: Dynamic Capacity Analaysis (3 replies)
  73. Dynamic Ribbon Button (1 replies)
  74. Solved: Syntax question (8 replies)
  75. Excel crashes when saving - emailing (1 replies)
  76. convert text numbers to real numbers, partial Cell deleting, deleting rows between se (12 replies)
  77. ExcelDiet() For Excel 2007 (1 replies)
  78. Solved: Subtotal header row (1 replies)
  79. Solved: help w/ ONTIME (3 replies)
  80. Solved: Duplicate Combobox Entries on Reset (2 replies)
  81. Batch processing SQL query strings in VBA (1 replies)
  82. Sleeper: Login internet and import image (0 replies)
  83. Tired Of To Many Cut & Paste (2 replies)
  84. Import from text file and format data in excel (3 replies)
  85. insert (5 replies)
  86. [SOLVED:] Delete value for some column (1 replies)
  87. How can you read with a VBA Excel Sub a vector from the worksheet? (1 replies)
  88. Solved: Custom diagram dots in excel 2003 (4 replies)
  89. Solved: Merger and Unmerge cells (9 replies)
  90. Solved: repeating a vba code in excel (7 replies)
  91. How to wrap comment.text in vba (1 replies)
  92. Using VBA to download a file from a website (6 replies)
  93. Solved: Select Case (9 replies)
  94. how to set import defaults? (2 replies)
  95. combine (1 replies)
  96. COPY (4 replies)
  97. Excel 2007 Saving issues (3 replies)
  98. Solved: return which Option Button was clicked (2 replies)
  99. Solved: Extracting words in Uppercase (5 replies)
  100. Solved: How do you count this? (19 replies)
  101. Solved: Excel Macro for trade reconciliation (10 replies)
  102. ListBox1 populates Listbox2 upon selection from a sheet? (4 replies)
  103. Pivot Table keeps showing wrong results (1 replies)
  104. open file from outlook (2 replies)
  105. Multiplying an arbitrary number of polynomials (4 replies)
  106. Show Formula Value (2 replies)
  107. 2 colors in one cells. (3 replies)
  108. Consolidate data to one master workbook (30 replies)
  109. Dynamic hyperlink formula won't link to file path when saved to new location (0 replies)
  110. remove text from an unmerged cell (3 replies)
  111. Solved: VBA Highlight row (10 replies)
  112. Replace dots with commas (3 replies)
  113. called sub not working (15 replies)
  114. Need to make DTPicker invisible based on another cell's value. (7 replies)
  115. Solved: check if anything in userform changed (3 replies)
  116. Issue with the macro which downloads the files from internet. (0 replies)
  117. Copy files, from a given list! (1 replies)
  118. Merge workbooks sheets (1 replies)
  119. Solved: how can i use the userfrom to replace the value in sh (13 replies)
  120. Find dupe row, move one of them (4 replies)
  121. [SOLVED:] Open new message and populate To: Box in outlook from excel (1 replies)
  122. Solved: Worksheet_Change not running right (2 replies)
  123. Solved: Control Workbook from another Application Window (6 replies)
  124. Solved: How to run macro for 2 event changes (3 replies)
  125. Userform/Checkboxes Formatting (4 replies)
  126. Merging Cells Using Excel-VBA (10 replies)
  127. Personal.xls??? (2 replies)
  128. Controlling the display of a text box (8 replies)
  129. Solved: Range = index() + textBox.value (4 replies)
  130. Solved: How to obtain two cell data from each worksheet in an Excel file? (2 replies)
  131. Reg : Merging of cells (3 replies)
  132. Solved: Excel Concatentate formula... (4 replies)
  133. Module question (4 replies)
  134. Solved: Averages of column and formatting (9 replies)
  135. Border war (3 replies)
  136. Fill a combobox from a spreadsheet? (1 replies)
  137. Solved: Target.Offset(0,2) & Run-time error (2 replies)
  138. [SLEEPER:] Permuations (5 replies)
  139. Solved: test filter and delete row in OLD and NEW office (2 replies)
  140. Merge two data inputs (3 replies)
  141. Solved: Delete range based on 3 cell values? (1 replies)
  142. Solved: Loops that write specific data to file (18 replies)
  143. Solved: Command Buttons fire 'Runtime 438' (5 replies)
  144. How to save an SQL file using Save Dialog in excel (4 replies)
  145. FORM - goto first text box if not found (2 replies)
  146. [SOLVED:] Turning Checkboxes into Numeric Values (4 replies)
  147. Calling Function with 2 args results in "Expected: =" compile error (12 replies)
  148. Solved: loop varaible (9 replies)
  149. Solved: How to write imported file's name in a cell? (9 replies)
  150. How to record delete event in excel (1 replies)
  151. converging data (1 replies)
  152. Macros that can translate from English to Spanish. (4 replies)
  153. How to record a deleted row value in excel (8 replies)
  154. How to select a range of cells which are filled in not an active sheet. (6 replies)
  155. Check cell range contains data if adjacent cell is not blank (6 replies)
  156. Crashes When Saving (1 replies)
  157. How to select Random Rows after Autofilter?? (11 replies)
  158. Duplex printer needs help (1 replies)
  159. Formating table (3 replies)
  160. [SOLVED:] Excel crashes (5 replies)
  161. Populate a combobox & textbox in a userform with data from a dynamic table (7 replies)
  162. pivot labels (2 replies)
  163. web browser control focus trouble! (1 replies)
  164. Solved: VBA to to unhide sheet (7 replies)
  165. read write access using VBA (1 replies)
  166. Solved: Print Page Numbering by Tab index in Footer (3 replies)
  167. 3 cells to another sheet next row (6 replies)
  168. [SLEEPER:] Workbook locking up (4 replies)
  169. Complex data output into html (1 replies)
  170. Excel/VBA date compare not working (3 replies)
  171. Looping through a batch of workbooks (5 replies)
  172. change font color for disable textbox (6 replies)
  173. Solved: Help with VBA subtotal and remove subtotal (2 replies)
  174. Solved: Creating a Dynamic Nested ForLoop (ie.variable number of nests) Recursive functions? (8 replies)
  175. Change arrow key behavior (3 replies)
  176. Solved: Problem with setting Range, and calculating SUM (2 replies)
  177. Unique items and renaming of sheet issues (2 replies)
  178. Counting the filled cells (2 replies)
  179. Solved: Sending an Outlook message from Excel (4 replies)
  180. Solved: Code to unprotect only one worksheet (11 replies)
  181. Solved: What is this EXTRA bit of code - date format) (5 replies)
  182. Solved: Bulk Insert of Names for Ranges/Cells? (12 replies)
  183. Solved: Dial and Gauge Charts for Excel 2007 and 2010 (1 replies)
  184. Solved: Find and Replace in Range - Compare Codes (2 replies)
  185. saving code in VBE window (4 replies)
  186. Help debug an R1C1 formula (4 replies)
  187. decimal points (3 replies)
  188. XML Node attributes (2 replies)
  189. Excel crashes when calling Doc Readystate (4 replies)
  190. Solved: only numbers (6 replies)
  191. Callng a sub from another sub (2 replies)
  192. Solved: combine all workbook (1 replies)
  193. Sleeper: Excel Macro - Word doc as message body images (0 replies)
  194. Solved: Update UNLOCKED cells on a different sheet? (4 replies)
  195. Load list of ftp files from directory into a userform? (0 replies)
  196. Compare two worksheets (1 replies)
  197. Conditional formatting for entire row for text based values using VBA code (2 replies)
  198. Solved: Create chart based on current month (4 replies)
  199. Find value and copy value from another column (0 replies)
  200. Hide Horizontal Scrollbar (5 replies)
  201. Solved: conditional formatting VBA (6 replies)
  202. Solved: Combining two bits of vba (29 replies)
  203. Solved: finding if two controls overlap (3 replies)
  204. Best Match (3 replies)
  205. Selecting typical Data and copying in a new sheet in other format (4 replies)
  206. how to force paste-special values in excel (0 replies)
  207. Tidy up of code required (6 replies)
  208. Array Help (6 replies)
  209. Solved: remove vba (5 replies)
  210. opening new instance of Excel when opening file (3 replies)
  211. Accessing a Database through VBA (7 replies)
  212. Solved: Setting a range to the result of a formula (2 replies)
  213. return specific values (2 replies)
  214. APIs in VBA Help (3 replies)
  215. [SOLVED:] Locked cells - values from macro (3 replies)
  216. Disable userform.show (5 replies)
  217. open a file based on a modified date (1 replies)
  218. encrypted macros (7 replies)
  219. Solved: Hiding Columns if all cells = zero (3 replies)
  220. Linking Password Protected Workbooks (2 replies)
  221. Solved: Changing color of item in listbox based on value of specific cell (5 replies)
  222. calculation col and rows min and max values (0 replies)
  223. setfocus on a form (2 replies)
  224. autofilter problem (1 replies)
  225. date problem on a form (2 replies)
  226. Form Picture help (4 replies)
  227. Controlling IE sub documents from Excel VBA (2 replies)
  228. Solved: Issue with applying a name to a range in autofiltered table (6 replies)
  229. IFS, ORS, ANDS??? (5 replies)
  230. Solved: Save as 'todays date' (3 replies)
  231. Solved: Copy files given location to a new location (3 replies)
  232. Solved: Run Time Error '76' (3 replies)
  233. Pivot Table VBA (1 replies)
  234. Disable cut/copy/paste - but still be able to copy between workbooks?? (4 replies)
  235. How to do Multiple If Statements Shortcut! (13 replies)
  236. Linking Excel Cell with Text Box (5 replies)
  237. Solved: encounter error (2 replies)
  238. Automatic Select Based on Cell Value (5 replies)
  239. Solved: Counting Substring Presence in Range (4 replies)
  240. Excel 2007 Clear Cache at run time? (10 replies)
  241. Application.InpuBox restriction - input 1 cell (1 replies)
  242. Solved: KB Article (21 replies)
  243. Solved: How to Exlcude some charts from Macro (6 replies)
  244. Remove Conditional Formatting (8 replies)
  245. Hiding, Copying and pasting in a specific order (7 replies)
  246. Solved: Formula take 2 (6 replies)
  247. Refreshing External Database Query In Excel using VBA (2 replies)
  248. Can I use IF function and run a macro? (6 replies)
  249. Solved: Sort Defined Range (3 replies)
  250. Solved: How to do repeated File-Open commands in alternate locations (6 replies)