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. Separate Parts of a Name String into Different Cells (9 replies)
  2. How to Use a Class Module from an Excel Addin in VBA (3 replies)
  3. Solved: Worksheet formula to convert text date YYYYMMDD (2 replies)
  4. Solved: Colour format cells in each row with highest values (6 replies)
  5. How to make userform/wizard remember value even after it is closed (2 replies)
  6. Format Function with Numbers (5 replies)
  7. Mailfunction - Send mail when document is updated. (1 replies)
  8. Max length of textbox with multiline property. (3 replies)
  9. Solved: Compare rows from two sheets and highlight non matched rows (2 replies)
  10. Datestamp + Calculation (0 replies)
  11. Sharing An Excel Workbook (3 replies)
  12. Referencing Worksheets from Macros (3 replies)
  13. Solved: Things That Happen When A Workbook Is Closed (5 replies)
  14. Get Sepcified Detail From Worksheets (24 replies)
  15. Does anyone use VSTO2008? (1 replies)
  16. Dynamic protection of data (3 replies)
  17. Sleeper: Inserting flash animation (20 replies)
  18. Extract various data from Worksheet into one column using certain criteria (3 replies)
  19. Solved: Open new application in maximized position (2 replies)
  20. Delete a Name Range that references a spreadsheet that does not exist (24 replies)
  21. Solved: Macro to create a "Draft" Watermark stamp for workbooks (24 replies)
  22. Solved: Dynamic Pivot Table (4 replies)
  23. Solved: Show MsgBox if autofilter results in zero (36 replies)
  24. Turn off custom functions (8 replies)
  25. How can I Run Macros In Other Excel File? (6 replies)
  26. Searching for cell value in another spreadsheet (3 replies)
  27. Extracting value from 1 of three columns where value exists (8 replies)
  28. Solved: finding Strikethrough font (6 replies)
  29. Solved: keeps crashing on this code (2 replies)
  30. Solved: Zip / Rar thru VBA (2 replies)
  31. Solved: Paste to next empty row (8 replies)
  32. Solved: Better Code for Textbox (5 replies)
  33. Save as .txt (4 replies)
  34. VBA or In-Cell functions for Duplicate handling? (8 replies)
  35. Solved: Copy/Paste from HTML Spreadsheet to Excel (9 replies)
  36. Pivottable macro - ManualUpdate problem (1 replies)
  37. Value find help (9 replies)
  38. Editing Chart Data Labels in Excel 2007 using VBA (3 replies)
  39. Solved: Prevent "This workbook contains links" window from popping up (2 replies)
  40. Disable msg SaveAs (2 replies)
  41. Permutations in a class modules (8 replies)
  42. SOLVED: Disable Custom Buttons when no Worksheet is Loaded (9 replies)
  43. Solved: VBA Calendar problem (2 replies)
  44. Solved: Date from textbox to cell (2 replies)
  45. Pull Data from range (1 replies)
  46. Solved: Another sorting problem (3 replies)
  47. Ribbon control mouse click detection (4 replies)
  48. Solved: Calculating Week Ending date based on Sunday week end? (2 replies)
  49. [SOLVED:] Vlookup - Im completley confused (9 replies)
  50. Formula to distribute a number in forward years with the cond. it is equals an amount (1 replies)
  51. Looping timer (4 replies)
  52. Loop through hundreds of files in a folder using select CASE (3 replies)
  53. Combine Certain Data From All Worksheets in All Workbooks in a Specified Directory (6 replies)
  54. Solved: macro to add FileName and currentdate to an existing worksheet (9 replies)
  55. Solved: Moving all files from one folder to another (6 replies)
  56. clipboard (6 replies)
  57. Solved: strings add a zero (4 replies)
  58. Byte Comparison for Strings (3 replies)
  59. VBA Formulas (7 replies)
  60. Solved: INCLUDE SIGNATURE IN AUTOMATED MAIL SENDING (4 replies)
  61. Solved: Combobox popup window without scroll bars (3 replies)
  62. formname.PrintForm disables msgbox (3 replies)
  63. Protect Sheet (3 replies)
  64. How do i save as *.xla in VBA? (7 replies)
  65. Solved: Open pdf or image file from predefined folder (4 replies)
  66. Scaling Values in a Chart. (3 replies)
  67. Solved: comments object, placement property (2 replies)
  68. [SLEEPER:] Check which cmd buttons is clicked (5 replies)
  69. Solved: Remembering entries (5 replies)
  70. Short code to set caption on labels based on cell values (3 replies)
  71. Solved: Calling a Macro from an OPC linked cell (2 replies)
  72. Multiple log in & update a file that contain Macro (2 replies)
  73. Wrapped (R) (2 replies)
  74. Solved: Vlookup or not? (1 replies)
  75. Solved: Update Value from one column to another column under 1 row (4 replies)
  76. Solved: Automation Error 440 (7 replies)
  77. Solved: Alternate shading via conditional format with a twist (6 replies)
  78. Audit trail macro on excel? (6 replies)
  79. custom function error. (4 replies)
  80. Solved: Filter data and count unique (13 replies)
  81. How to use the Connections.Add method (1 replies)
  82. How to create a .xls file on a remote server (0 replies)
  83. How to copy files into a current user profile folder using Excel VBA macro? (1 replies)
  84. Solved: How to discover repeat text names in Range array? (3 replies)
  85. Combining Macros (3 replies)
  86. Solved: issue with using DATEValue in VBA, with VLookup (2 replies)
  87. CAll a macro on entering data to a cell under a column (3 replies)
  88. Solved: If Without Block If (2 replies)
  89. Contingent row copy (make duplicates) (18 replies)
  90. Solved: Zipping files in a folder using VBA (10 replies)
  91. Solved: How to create listing in Combo box of User Form (10 replies)
  92. SUM VISIBLE COLUMNS ONLY (16 replies)
  93. Solved: Disable Web site auto linkage to Excel (3 replies)
  94. Solved: Hiding & Unhiding Columns base on a Data Validation or Cell value (1 replies)
  95. placing a floating combobox on top of a cell in OWC11 spreadsheet using VBA (0 replies)
  96. Solved: Using Start and End Date via a form? (1 replies)
  97. Solved: Using two commands in Excel 2007 (4 replies)
  98. Solved: Problems Distribute Excel Add-Ins in a high demand environment (3 replies)
  99. Copying multiple column data in multiple sheets to one column in Master sheet (13 replies)
  100. Solved: Copy sheet to new workbook without copying the code? (4 replies)
  101. [SOLVED:] 2007 compatibility (41 replies)
  102. Solved: Moving to London: Is anyone interested in hosting my duplicate master webpage? (21 replies)
  103. Solved: Compile error in hidden module (3 replies)
  104. Solved: Adding days when checkbox checked (2 replies)
  105. delete row if column f is blank (2 replies)
  106. Exporting to c:\test.txt problems (3 replies)
  107. Login Secure site (6 replies)
  108. Solved: Search row for text and delete column if equal to a value (5 replies)
  109. Solved: Copy bookmarks to Excel (1 replies)
  110. Solved: Data Validation -- Combo box VBA (29 replies)
  111. Changing cells' format (8 replies)
  112. Solved: creating Chart using Dynamic ranges.. (2 replies)
  113. Vlookup for user form (16 replies)
  114. Solved: reformatting spreadsheet (3 replies)
  115. Solved: Auto update data fm one Worksheet to another Worksheet (7 replies)
  116. How 2 ntermittently pause recalculation process & read the dispalyed statusbar text? (4 replies)
  117. Why is my alignment vba code not working. (10 replies)
  118. Chart axes setting problem (6 replies)
  119. Funny: Excel 12 Help file! (1 replies)
  120. Countdown timer (9 replies)
  121. Get Last Accessed Date/time (8 replies)
  122. Unexplained Error with code (2 replies)
  123. 'CurrentRow' Expression & Skipping through records (12 replies)
  124. Solved: Conditional Deleting of Rows (1 replies)
  125. Solved: Named Range Across Sheets (7 replies)
  126. Solved: excels analysis tools (1 replies)
  127. Solved: find max in multi dimensional array (6 replies)
  128. Solved: Worksheet Copy creates new Workbook (5 replies)
  129. Problem with my vba code (3 replies)
  130. Workbook_Open executes after a pop-up box (2 replies)
  131. Trying to Split a long string in same cell (6 replies)
  132. Help me creating files index (2 replies)
  133. print and name PDF file (2 replies)
  134. Solved: PasteSpecial and Selection Areas (4 replies)
  135. Importing data from another workbook causes error 9 message (15 replies)
  136. Solved: Splash Screen (2 replies)
  137. Excel sheet focus problem (12 replies)
  138. Assigning cell values (2 replies)
  139. Match headers when importing text files (3 replies)
  140. Loop through cells values on each button click (2 replies)
  141. Solved: Writing a formula in another sheet. Should work but I get #NAME? (5 replies)
  142. Problem with codes on different machines (16 replies)
  143. Copy preferred row to same named Sheet (16 replies)
  144. Solved: Displaying cell data in inputbox text (2 replies)
  145. Solved: CREATE 2X1 MATRIX IN EXCEL AND PULL FROM THIS (13 replies)
  146. [SOLVED:] Changing chart titles using VBA (2 replies)
  147. changing ctart titles using VBA (2 replies)
  148. dynamic formula help (6 replies)
  149. Solved: Simple Encryption (7 replies)
  150. Password protect the macro coding (3 replies)
  151. Copy data from Pivot Table (2 replies)
  152. Find a word and extract data to another sheet (14 replies)
  153. Solved: Treeview & Imagelist relationship (11 replies)
  154. [SOLVED:] Trig help (9 replies)
  155. Solved: Incrementing a cell that has a forumla in it (1 replies)
  156. Solved: If Cell Value is Worksheet Name Copy Row (17 replies)
  157. How to find row from address (7 replies)
  158. VBA Excel Helper Subprocedures;Homework (4 replies)
  159. get Column Letter (6 replies)
  160. file size (3 replies)
  161. "Create a unique list and count of items from an unsorted list" Help (6 replies)
  162. Solved: Any tutorials about adding items by typing into a Combobox? (12 replies)
  163. Solved: Autofilter problem (10 replies)
  164. Solved: Inserting columns late - hours of regression testing (3 replies)
  165. Trying to import data from one excel sheet to another (7 replies)
  166. Poor efficiency: Code runs too long (3 replies)
  167. Solved: links (13 replies)
  168. Dynamically look between Paranenthesis (1 replies)
  169. next iteration in loop (5 replies)
  170. Copy data from Excel to Word with gif image (1 replies)
  171. Copy and Offset?? (1 replies)
  172. Adding radio buttons and counter on excel test sheet? (3 replies)
  173. Solved: Adding form data to two sheets (3 replies)
  174. Solved: cell is not emtpy even if no visible value (2 replies)
  175. Deleting rows based on criteria (3 replies)
  176. Solved: Log on to a password protected website to view info (2 replies)
  177. Creating Arrays within Pivottables (0 replies)
  178. [SLEEPER:] Which function uses Minimum Resource, Minimum Calculation Time? (6 replies)
  179. Input mask (3 replies)
  180. Solved: Export/Import data to multiple workbooks? (4 replies)
  181. Solved: using countif in code (1 replies)
  182. Clearing extra characters from imported data? (2 replies)
  183. Solved: Clear cells where using a certain font (19 replies)
  184. User Input (1 replies)
  185. Solved: Workbook Directory path (8 replies)
  186. Solved: compare value of two cells to value of two columns in dynamic array (2 replies)
  187. Solved: delete sheet based on cell value (6 replies)
  188. VBA as One User Defined Function: Homework (4 replies)
  189. Manipulating Chart objects (1 replies)
  190. Solved: Using office assistant to display custom messages (1 replies)
  191. Solved: Leading Zeros Truncated (2 replies)
  192. macro to save a Worksheet (2 replies)
  193. Solved: Copy Specific Cell in Rows and Columns to Another Worksheet (34 replies)
  194. Variable column in code (10 replies)
  195. Macro to hide blank rows in Workbook (12 replies)
  196. VBA Case Statement verification; Homework (2 replies)
  197. Solved: Help transfer excel table to access db (18 replies)
  198. Select Case Statements; Homework (1 replies)
  199. Concatenated Message Box: Homework (9 replies)
  200. VBA Help: Homework (3 replies)
  201. Solved: Help with For....Next, and some useful code for everyone (23 replies)
  202. Dir function returns fileNames not as expected (6 replies)
  203. Advice and Tips for instr & for Findnext (5 replies)
  204. VBA Sub Procedures; Homework (12 replies)
  205. Modify Macro to go from Ascending to Descending Order (7 replies)
  206. Help with code cleanup. (5 replies)
  207. Dynamically change number formatting within a column (3 replies)
  208. Append to master list? (2 replies)
  209. runtime error 1004 (8 replies)
  210. GoTo versus Resume within an error-handling routine (2 replies)
  211. Using VB with variables to access data from web sites (5 replies)
  212. find duplicates entries (4 replies)
  213. Still need help with this vba code (2 replies)
  214. Solved: Concatenate into a Single Cell (5 replies)
  215. Solved: Do ... loop (4 replies)
  216. UserForm Initialize or Activate Conundrum (2 replies)
  217. Solved: Newbie once again, importing a module (7 replies)
  218. Vlookup for all the row? (13 replies)
  219. Solved: Last Row Array help (2 replies)
  220. Frequency filter by date and sorted elements (5 replies)
  221. Solved: formula simplificiation (2 replies)
  222. Solved: Column search returning wrong results (35 replies)
  223. Exporting Spreadsheets (5 replies)
  224. Make file read/write (1 replies)
  225. Solved: Create quarterly summary report from details (8 replies)
  226. % movement tracker macro (2 replies)
  227. [SOLVED:] Reverse Lookup Last Record Ignoring Location 300 (6 replies)
  228. VBA Code Error (23 replies)
  229. Solved: Message box ( Open Event) (2 replies)
  230. Set bottom of variable range (11 replies)
  231. dynamic Validation criteria (4 replies)
  232. Solved: Compare the values between two columns (12 replies)
  233. Solved: vlookup from another worksheet (5 replies)
  234. Multipe Goal Seek across workbooks (1 replies)
  235. Fastest method to read data from sheet (2 replies)
  236. Solved: copying cell value only when calculated from formula (2 replies)
  237. Solved: Names I define in a macro ignored by workbook? (24 replies)
  238. Disable cut & paste in active workbook (1 replies)
  239. Solved: Vlookuping a separate sheet (4 replies)
  240. Incremental number for saved files (32 replies)
  241. Solved: VBA Message Box (11 replies)
  242. Check no selection in a listbox.. (3 replies)
  243. Copy Data (2 replies)
  244. Solved: Double Click a cell to show form with data (2 replies)
  245. Code to Export as xml file (0 replies)
  246. Solved: Specify 63 Days From a Date (2 replies)
  247. problem with date format when I use userform (4 replies)
  248. Linking Excel to Access Forms (0 replies)
  249. Validating column Heads (2 replies)
  250. Value change with date (3 replies)