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: Shortcut to run macro (3 replies)
  2. Solved: Delete Row Based On Value (13 replies)
  3. Writing a .CSV file (.txt) from a Sheet (2 replies)
  4. Creating an OnClick event for an autopopulated userform (7 replies)
  5. Solved: How to import multiple sheets from different files in same folder to main workbook (16 replies)
  6. Loop web query (7 replies)
  7. Select sheets based on name (14 replies)
  8. Lock Cell after value updates to specific value (3 replies)
  9. [SOLVED:] Copy and rename sheet in sequential order (4 replies)
  10. Solved: An error with setting a wb. Why? (17 replies)
  11. Macro: Move Cells where QTY is in upper percentile (2 replies)
  12. Loop through folder of Excel files and copy sheet from one set into another (1 replies)
  13. Getting a 0 When Dividing (2 replies)
  14. Solved: Loop with Go to steps? (5 replies)
  15. Messagebox to remind user of 12 day limit (15 replies)
  16. Solved: General questions on excel objects... (11 replies)
  17. Convert String To Date (9 replies)
  18. Macro's for printing (3 replies)
  19. Solved: copy worksheet with referencing old worksheet (12 replies)
  20. ref range to replace sheet name (5 replies)
  21. Solved: display worksheets in combo box except... (1 replies)
  22. Solved: Unable to change the name of this cell (3 replies)
  23. Solved: Open workbook to last Friday of current week (10 replies)
  24. Lock Cell Format? (1 replies)
  25. Excel VBA Access (3 replies)
  26. how to use VLOOKUP only for blank cells in column A (3 replies)
  27. Solved: slow macro (11 replies)
  28. Assign Value to Variable Type Range (4 replies)
  29. Solved: Delete row if default value (4 replies)
  30. Macro: Need to find all unmatched Data (22 replies)
  31. Solved: Fill by number of rows (2 replies)
  32. Data Validation - "A" and 2 number and 2 letters (3 replies)
  33. Which FileFormat code (enumeration) for XL 97-2003 ? (2 replies)
  34. Can anyone improvise this data and chart? (5 replies)
  35. Userform Validation - Unique Names & Numbers (15 replies)
  36. Error: Object Variable or With block variable not set (1 replies)
  37. Forgot the password I gave to protect a part of sheet (2 replies)
  38. Solved: Not sure how to fix this loop? Help Please (6 replies)
  39. set calendar to open at a specified date. (1 replies)
  40. Reordering rows where sort is not effective (0 replies)
  41. Solved: Click on protected sheet (20 replies)
  42. Need some newbie help with Cell validation (7 replies)
  43. Application.Volatile Method (8 replies)
  44. Override the built in SAVE (6 replies)
  45. Solved: Macro's slowing down my spreadsheet (0 replies)
  46. Check Cell for Blank (3 replies)
  47. Copying the entire workbook to a new workbook (5 replies)
  48. Control Inputbox as number only? (3 replies)
  49. Solved: Activate certain sheet based on cell content (2 replies)
  50. Generating one .TXT archive from the Sheet. (0 replies)
  51. Change all pivot table data sources (0 replies)
  52. Modifying Code for Whole to Flash (1 replies)
  53. Data Validation C2*D2 = E2 (3 replies)
  54. Compare dtmDate with a value in column A (6 replies)
  55. Solved: Add a WebService reference to an Excel 2010 sheet (21 replies)
  56. [SOLVED:] Set Msgbox with Default number? (2 replies)
  57. Solved: conditional formatting (1 replies)
  58. Solved: Label display (4 replies)
  59. excel - checkbox (2 replies)
  60. Does VBA Lose Variable Definitions and/or Values between Subs? (14 replies)
  61. on change event according to pivot table (1 replies)
  62. Solved: caption SaveAs location (4 replies)
  63. looking for value position in table (3 replies)
  64. Solved: Total sum of Time in a column (5 replies)
  65. Solved: CNTL + N (2 replies)
  66. Solved: How many substrings returned by Split() ? (3 replies)
  67. Form position (5 replies)
  68. Solved: Data Validation List shortcoming(s) (3 replies)
  69. Solved: Code for vba to replace below formula (13 replies)
  70. problem with excel 2010 slicers (0 replies)
  71. How to delete a Empty column? (2 replies)
  72. Solved: How to Throttle SMTP Traffic (17 replies)
  73. Solved: InputBox Help (4 replies)
  74. Created a Drop Down Box based on certain criteria! (1 replies)
  75. Macro: look up another field and pull the data not matched (4 replies)
  76. Solved: Embedded Spread Sheet (4 replies)
  77. Solved: VBA Code, who can help? (14 replies)
  78. Solved: Match Name find Row No then copy values to sheet2 (4 replies)
  79. Solved: Address (4 replies)
  80. Solved: variable ProperCase (19 replies)
  81. iterate till equilibrium reached (7 replies)
  82. A Short Formula Please - Excel (3 replies)
  83. Solved: What's wrong??? (5 replies)
  84. Sharing a macro that is created by me (4 replies)
  85. Split Cell Content Into Two Columns (6 replies)
  86. [SOLVED:] How do I Insert 2 or more rows with a copy from one other row? (31 replies)
  87. Help With VBA in Excel ? Writing a function using probabilities ? (0 replies)
  88. Multiple If statements in 1 column (1 replies)
  89. Need quick help with some VBA issues (image sizing) (6 replies)
  90. Solved: cutting date into variables (2 replies)
  91. Looping through workseets issue (6 replies)
  92. Solved: Print Settings (2 replies)
  93. Macro to trim and convert in excel (4 replies)
  94. UDF randomize an array (0 replies)
  95. Solved: get all the names in the column (6 replies)
  96. Help from Guru needed (4 replies)
  97. Solved: Emailing From Excel Using an Outlook Template (7 replies)
  98. Carriage Return Quote Delete Macro (12 replies)
  99. Solved: download complete (3 replies)
  100. HyperLinks to specific Location in another App. (1 replies)
  101. Solved: Delimiter saving each tab to its own .txt file (6 replies)
  102. Solving a problem within VBA without using solver (1 replies)
  103. LOOKUP?? how to find data (stuck on project..please help) (5 replies)
  104. Solved: Floating command bar position (2 replies)
  105. Open Gmail (5 replies)
  106. Solved: Message box for offset column (19 replies)
  107. Solved: Adding conditional formatting VBA (9 replies)
  108. Get Cells to flash based on a condition (9 replies)
  109. Problem with Changing formula (5 replies)
  110. Copy Array of Values (1 replies)
  111. Sum columns in table excel 2007 (1 replies)
  112. Simple question... (3 replies)
  113. excel connection (10 replies)
  114. Solved: Cell Reference (3 replies)
  115. Copy to last row with unspecified column (3 replies)
  116. list all running programs (13 replies)
  117. Solved: Change Path -- ActiveWorkbook.path (8 replies)
  118. Very complicated, copy and paste sheets in a loop (5 replies)
  119. Solved: Restrict Special Charachters (4 replies)
  120. Append data in master file from 4 different files (17 replies)
  121. Solved: Cell Value As String (2 replies)
  122. Solved: What is wrong with this code??? (8 replies)
  123. Autofill issue (3 replies)
  124. Modify code to run on multiple files (3 replies)
  125. VBA Module (6 replies)
  126. Compare one number with list of numbers (3 replies)
  127. Why doesn't this work in a loop? (5 replies)
  128. Solved: Need Zip code ` (9 replies)
  129. Array help (4 replies)
  130. Solved: how do I save an xls as an xlsx after changes are made in VBA? (4 replies)
  131. Formula Update (4 replies)
  132. Collating data into a consolidated view (3 replies)
  133. Solved: Is it possible to enter a UDF into a cell and replace it w a native Excel formula? (4 replies)
  134. Replacing columns and rows default names (1 replies)
  135. Reading Data from Excel 2007 (?????) (0 replies)
  136. Detecting the class in a span (3 replies)
  137. Get javascripts from a URL with VBA (2 replies)
  138. count instances if within 30 days (4 replies)
  139. Solved: Userform value problem (2 replies)
  140. SOLVED: Send email using vbs without attachment (2 replies)
  141. Solved: Autofill formula VBA needed (5 replies)
  142. Blank Columns (7 replies)
  143. Filter several pivot tables for same value (2 replies)
  144. Solved: Programmatically naming an offset cell.... (2 replies)
  145. "Out of Memory" error thrown when Formula contents length exceeded (1 replies)
  146. Can I block an .xlsm from being converted when it's open in Excel 2003 (5 replies)
  147. Print Visible data rows (6 replies)
  148. Solved: When a row inserted, add one to highest Value in Col N, & add -1 to Col B value (8 replies)
  149. Add lines in excel comments through VBA (5 replies)
  150. populate combobox using array (1 replies)
  151. Solved: Delete Row based on Column Criteria (with looping) (6 replies)
  152. Refresh Sheet1 or workbook periodically (1 replies)
  153. Solved: excel 2003 conditional formatting (8 replies)
  154. request for complex examples for combination of function (2 replies)
  155. Excel VBA for creating Folders (14 replies)
  156. If blank column, paste to the next column VBA (5 replies)
  157. VBA Code to check if shared document is locked for editing (0 replies)
  158. Solved: SUMIF attempting to interrogate cell properties in "criteria" portion of the syntax (5 replies)
  159. Print active sheet from printpreview-excel 2007 (0 replies)
  160. Lookup Macro Help (1 replies)
  161. OWC11 Spreadsheet component Undo Error (6 replies)
  162. Scrollbar controlling several Textboxes? (1 replies)
  163. Conditional formating of rows (2 replies)
  164. Basic question on cell comparison (4 replies)
  165. Solved: CheckBox Help (5 replies)
  166. [SOLVED:] List data (3 replies)
  167. Using wildcard in folder name (4 replies)
  168. Rich Text Box (1 replies)
  169. Solved: Cells vs Range (2 replies)
  170. CTRL + Break (4 replies)
  171. COMPARE 2 XL WORKBOOKS & PASTE DATA (2 replies)
  172. Solved: Mysterious macro running on Excel file close? (10 replies)
  173. Solved: Challenging Question* Need excel macro to send email based on a choosen number (6 replies)
  174. Make a cicle (4 replies)
  175. Excel 2007 find last column in table (4 replies)
  176. What's wrong with this code? (3 replies)
  177. Solved: Calculation of an UDF (4 replies)
  178. Solved: VBA alternative to a look up table (4 replies)
  179. Code to print folders, subfolders and files (2 replies)
  180. Solved: Copy based on multiple condition (9 replies)
  181. trim & dates (12 replies)
  182. Solved: Detecting a Running Application (3 replies)
  183. Solved: worksheet change event (8 replies)
  184. Copy, Paste Special and Insert (4 replies)
  185. Set to default browser (3 replies)
  186. Solved: Non-VBA Solution: Identify Text String from Table and Return Text String (8 replies)
  187. copy data from excel to word without mail merge (2 replies)
  188. VBA to find a directory (12 replies)
  189. Solved: String Question (4 replies)
  190. Macro for gantt chart update (2 replies)
  191. Is it possible to auto-calculate as well as autopopulate a graph (1 replies)
  192. Formula Trouble (3 replies)
  193. Help With the VLOOKUP (5 replies)
  194. Extract data from pdf to excel (1 replies)
  195. dynamically created array (3 replies)
  196. Out of memory / resource - XML import (1 replies)
  197. Solved: macro to update chart axis (1 replies)
  198. Picture blinking (flashing) (2 replies)
  199. Export Excel data to Word table (1 replies)
  200. replace macro from list to another sheet (2 replies)
  201. Sleeper: Listbox value from excel filter (1 replies)
  202. Year To Date Sales Compared to Last Year To Date (4 replies)
  203. vba macro code (32 replies)
  204. Infinite loop for a simple high frequency trading algorithm (1 replies)
  205. import data from password protected website into Excel worksheet (4 replies)
  206. how can i paste only value with this code? (2 replies)
  207. Filling a Two Dimension Array (5 replies)
  208. Extend the code up to row 21 (5 replies)
  209. Solved: Saving Sent Mail to an Alternate Folder (9 replies)
  210. File with a lot of links (9 replies)
  211. Solved: Reset a cell value on a certain day of the month (13 replies)
  212. Loop not working (1 replies)
  213. Class Module unhooked after Userform shown (1 replies)
  214. Help With "Email Activesheet in Body of Mail Using Default Mailer" (1 replies)
  215. Solved: Bold Text From a Defined Word to End of Line (5 replies)
  216. Solved: Rename Folder - Error 75 (3 replies)
  217. Solved: Display text & background color in sheet textbox (variable) (12 replies)
  218. Problems in Outlook.Application object in VBA (2 replies)
  219. Solved: Macro addition (2 replies)
  220. Sub only works when stepping in to (1 replies)
  221. Solved: sumproduct freezing the file (9 replies)
  222. Solved: BAT file (4 replies)
  223. FSObject Create Folder not creating entire folder list (4 replies)
  224. Help...Excel Macro... (2 replies)
  225. Solved: VBA Importing a sheet from a closed excel workbook (16 replies)
  226. Help Creating A Calculator (6 replies)
  227. VBA IE Javascript Radio Select (1 replies)
  228. target.address help. (1 replies)
  229. Solved: If formula to match numbers +1 -3 (6 replies)
  230. Remove char(13) in a range (3 replies)
  231. Application.Ontime is LATE! (2 replies)
  232. Copy and Paste Problem (4 replies)
  233. Handling really big nos. (8 replies)
  234. Solved: Sum an unordered group of rows by a common String (7 replies)
  235. Can this macro be simplified? (1 replies)
  236. Is there a home command? (23 replies)
  237. VBA to remove a comma if it's the cells first characters (5 replies)
  238. Solved: set excel 2007 as default (2 replies)
  239. order cells under corresponding column (4 replies)
  240. Help with Network based Excel VBA ADO connection string (1 replies)
  241. Define Column/Listbox (5 replies)
  242. Get MSFLEXGRID tooltiptext property for VBA (0 replies)
  243. Excel & MS Query (2 replies)
  244. Formula to assign resources (4 replies)
  245. Retrieving specifc cell value for loop (2 replies)
  246. VBA Excel Margin Problem (0 replies)
  247. excel database (2 replies)
  248. [SOLVED:] Solved: List Files in Directory that Match a File Extension (2 replies)
  249. Solved: message above vba code (4 replies)
  250. copy data from one worksheet to another (3 replies)