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. Connect to Oracle with Excel VBA and store results of query? (2 replies)
  2. conect 3 tabales in Table4 in diferent worckbook (0 replies)
  3. [SOLVED:] Run-time Error 5 "Invalid Procedure Call or Argument" (4 replies)
  4. [SOLVED:] Edit Listbox Items (2 replies)
  5. [SOLVED:] Create copy of WB (2 replies)
  6. [SOLVED:] Show and Hide a UserForm using a String as the UserForm Name (16 replies)
  7. vba script to convert datetime string to date format (18 replies)
  8. Load Formula from another sheet (2 replies)
  9. [SOLVED:] pass two workbooks into sub module (2 replies)
  10. VBA Autofill Method of Range Class Failed (3 replies)
  11. [SOLVED:] Combining multiple range as target cell (3 replies)
  12. VBA Dynamic Ranges & Sheet Formatting (2 replies)
  13. Loop through columns and vlookup (1 replies)
  14. Macro that generates new work sheet with people and tasks they perform (6 replies)
  15. [SOLVED:] Populate Hyperlinks in ListBox (4 replies)
  16. [SOLVED:] VBA Paste Cells With Specific Text String to Specific Sheet (11 replies)
  17. Rolling Calculation (8 replies)
  18. VBA Dynamic Named Ranges & Page Formatting (4 replies)
  19. MAX date problem (5 replies)
  20. Close active workbook if multiple workbooks are open/ close excel if only one open (4 replies)
  21. Help making my search look in 2 sheets? (1 replies)
  22. VBA code to open IE in non-protected mode (0 replies)
  23. VBA Variant Array issues with Excel (2 replies)
  24. [SOLVED:] Maximum and minimum tide levels for every day (8 replies)
  25. Macro to paste on a hidden sheet (3 replies)
  26. [SOLVED:] Query doesn't work in Excel 2010 (13 replies)
  27. VBA Compile Error: Ambiguous name detected (2 replies)
  28. Need Help with a Looping Issue (4 replies)
  29. Setcell to blank if results of a formula are null, based on checkbox conditition (3 replies)
  30. worksheet function match syntax issue (3 replies)
  31. vba to run a macro on multiple excel files in a folder (5 replies)
  32. VBA Copy and Paste data to another sheet(with a date and day)? (3 replies)
  33. Best Way to Create Options Menu for an add-in? (5 replies)
  34. time calculation formula (8 replies)
  35. Sleeper: Save sheet as csv to specific network folder (1 replies)
  36. Highlighting, freezing and scrolling (1 replies)
  37. Is there a before_insert_row event? (6 replies)
  38. Confirm Message Before Deleting Rows (1 replies)
  39. [SLEEPER:] Need help with Inputbox function and If Statement (7 replies)
  40. Copy cell contents to another sheet at a particular cell address (0 replies)
  41. VBA Code to move files to another folder (13 replies)
  42. [SOLVED:] List cells containing references to files, i.e. containing formulas with broken links (29 replies)
  43. Insert Rows based on 2 Criteria (1 replies)
  44. Column headers throws errors (10 replies)
  45. VBA - MouseMove Event Code to Display Text after Hovering (5 replies)
  46. VBA: How to search new sheet for a defined variable, then copy values back to sheet (1 replies)
  47. Help with a VBA macro - merge multiple workbooks in one workbook with source names (2 replies)
  48. Copy Rows based on 1 criteria showing in Multiple columns (1 replies)
  49. Move cursor to image named material and then go to sub menu Material AVaialbility (3 replies)
  50. Highlighting Repeating Number Pairs (20 replies)
  51. [SOLVED:] Copy Excel range & paste in PPT as [Pastespecial - M.O. Excel Worksheet(Code) Object] (14 replies)
  52. Deleting Rows using VBA macro (2 replies)
  53. .xla Add-In Mechanics and Custom Ribbon Creation (3 replies)
  54. Enter text base on cell value/text referencing a dynamic list (3 replies)
  55. Pairing Co-ordinates (1 replies)
  56. Copy cell content and and paste to specific cell as a comment. (2 replies)
  57. #Value Error Using UDF Within Worksheet (8 replies)
  58. help to Copy symbols indicators as per range parameter set. (12 replies)
  59. Custom function help (Probably just me being stupid!) (5 replies)
  60. VBA Sum If Calculation (19 replies)
  61. Excel 2010 Print Blank Page (1 replies)
  62. Open word document (5 replies)
  63. Alternative to Application.Ontime (3 replies)
  64. Format from last Row Up (3 replies)
  65. Printing Embedded PDFs from Excel Workbook (2 replies)
  66. Asking for a different sheet name if current input already exists (1 replies)
  67. fill range based on Month (9 replies)
  68. Active Cell Address move to left when enter key is Enter (0 replies)
  69. [SOLVED:] Understanding the Syntax of Hyperlinks.Add (6 replies)
  70. Login into a website through Excel (2 replies)
  71. clearing ranges from COPIED sheet (2 replies)
  72. Lotus Notes Mailbox Size/Quota from Excel VBA (1 replies)
  73. Trouble with calculations in Excel table (3 replies)
  74. VBA Comparison between 2 sheets that return a 3rd sheet with differences (1 replies)
  75. xlRepairFile (3 replies)
  76. Code to unprotect wbaproject (4 replies)
  77. [SOLVED:] multi-VLOOKUP From an Array in VBA (3 replies)
  78. Highlight a specfic column when spread sheet opens (5 replies)
  79. Need Help with calculating an array of numbers... (6 replies)
  80. Excel Property Window While Saving (6 replies)
  81. help with complicated formula (60 replies)
  82. Deselecting a single pivot table item which is referenced in a specific cell (0 replies)
  83. [SOLVED:] Export worksheet to new workbook and restore original sheet (3 replies)
  84. Create Unique Values List From Named Range (4 replies)
  85. [SOLVED:] GoalSeek by VBA (4 replies)
  86. Duplicate data sets multiple times in VBA (7 replies)
  87. VBA Set cell value under last row (2 replies)
  88. looking help (4 replies)
  89. Date -> numeric translation issue (5 replies)
  90. Auto Name a workbook (13 replies)
  91. New to VBA, trouble with an If Else Then statement (4 replies)
  92. Need Some Change In Count Macro Running Code (3 replies)
  93. Create sheet if it doesn't exist problem (7 replies)
  94. Formulate average count of DISTINCT records (4 replies)
  95. Export array values to Excel (10 replies)
  96. Refresh data in closed excel workbook (3 replies)
  97. VBA to auto-add rows to 3 Tables (or one and auto-resize 2) (1 replies)
  98. Excel VBA macros - webquery (12 replies)
  99. How to extract filename from a folder which is on a netwrok drive (6 replies)
  100. VBA code to open folders and pdf file inside the folders (32 replies)
  101. VBA export of specific rows (4 replies)
  102. Uncheck Chckbox in Protected Sheet (2 replies)
  103. Find Duplicates and Highlight Row in Red (4 replies)
  104. How to best count? (8 replies)
  105. Operation with dates (6 replies)
  106. Consolidate Data Using VBA (7 replies)
  107. Save text file as unicode from Excel VBA (2 replies)
  108. Check for a condition in a Do Unil Loop (9 replies)
  109. Cells(x,x) = 1 ? (6 replies)
  110. VBA Code - Autofill with a Dynamic Range (7 replies)
  111. SUMPRODUCT double counting (1 replies)
  112. non vba save as dialogue box (2 replies)
  113. footer (3 replies)
  114. Query SQL through VBA (2 replies)
  115. Initializing a userform from another userform? (8 replies)
  116. VBA CODE - SEARCH AND COPY (8 replies)
  117. Add Dynamic Option and loop to my code (1 replies)
  118. Save Breakpoints (1 replies)
  119. Solved: Range("FilterArea") (1 replies)
  120. Any suggestions on making this code faster (1 replies)
  121. Scrape data from website to excel - VBA (0 replies)
  122. Solved: Call CMD.EXE and send instructions (5 replies)
  123. Compare & Fill Data Help Needed ! (27 replies)
  124. Solved: Help transfer from Multi Column ComboBox to worksheet non ajacent columns (7 replies)
  125. Excel, VBA, Send Email (1 replies)
  126. VBA on a MAC (4 replies)
  127. Macro Speed Up - Help (9 replies)
  128. Counting Unique Values across multiple rows (2 replies)
  129. Solved: Save As Web Page plz plz help (2 replies)
  130. on each page, highlight the first cell on column A (8 replies)
  131. Application Defined or Object Defined Error (3 replies)
  132. VBA OF EMAIL FROM EXCEL (2 replies)
  133. Compare, Match And Copy Data Row (23 replies)
  134. Solved: Learning! (2 replies)
  135. Solved: Automatically Open Files On Folder Select (8 replies)
  136. Autimatize worksheet names (3 replies)
  137. vba code import table excel to mysql (51 replies)
  138. Hostname to IP (1 replies)
  139. Sorting an array from small to large with an error twist! (5 replies)
  140. Conditionally Format cells in a row based on the sum of the previous nth cells. (15 replies)
  141. Automated Macros (5 replies)
  142. [SOLVED:] Need Help About Check Boxes (8 replies)
  143. Check SharePoint if file exists (2 replies)
  144. Lost on VBA HELP! (1 replies)
  145. Compile Error Variable Not Defined (2 replies)
  146. Import several text files into an excel file with macro (6 replies)
  147. Need to create VBA to transfer data in between workbooks (1 replies)
  148. Using Excel Solver (0 replies)
  149. Histogram help (1 replies)
  150. Split worksheet into multiple tabs (10 replies)
  151. [SLEEPER:] Pasting data from Excel into multiple Notepad Sessions (6 replies)
  152. Working with three workbooks (4 replies)
  153. Solved: Overflow Error in Code (3 replies)
  154. Solved: Finding a variable cell on another sheet for a formula (12 replies)
  155. Help transfer from ListBox to worksheet non ajacent columns (5 replies)
  156. Help Building A Fully Functioning Excel Add-In (1 replies)
  157. Solved: Code for Protecting a Specific Sheet in a Workbook with a Password on Exit (4 replies)
  158. Solved: Cut data before first space (13 replies)
  159. [SOLVED:] Export to PP (3 replies)
  160. Trying to copy paste and delete a row (20 replies)
  161. VBA to extract data from file in use (5 replies)
  162. Problem in replacing macro (5 replies)
  163. Importing data from a website into Excel (1 replies)
  164. pulling data from multiple sheet on to one sheet with specific value (3 replies)
  165. Solved: can I change some options when using PrintForm !!!! (6 replies)
  166. Solved: Rainflow Three-Point Algorithm (10 replies)
  167. Solved: Using Statemant CASE to delete rows in multiple sheets (15 replies)
  168. Problems with merge fields (8 replies)
  169. Solved: Skip cells (4 replies)
  170. Solved: VBA, checkbox, reporting and sum (5 replies)
  171. Extract Data From Alibaba Website (4 replies)
  172. by click on cell of column a the color of row change (3 replies)
  173. Solved: Change/Update Defined Names 'Ranges' (multiple) in Name Manager (9 replies)
  174. graph /objects protection/unprotect (3 replies)
  175. Worksheet entry help (3 replies)
  176. time and date in the excel cell (5 replies)
  177. Using Index Match, adding to the bottom of the row those that are missing (1 replies)
  178. Solved: Option to extend trend line on graph (1 replies)
  179. Solved: Inserting cell value in formula (6 replies)
  180. Solved: VBA issue (2 replies)
  181. Solved: Date Format (4 replies)
  182. Retrieve data from Access (1 replies)
  183. Manipilating an ASCII string in VBA (1 replies)
  184. Solved: Using VBA to Log In Members with a Username and Password stored within the Workbook. (10 replies)
  185. Download Data From Internet using Excel macro (5 replies)
  186. Value field appearing above row labels pivot table (2 replies)
  187. book (4 replies)
  188. Histograms in excel 2013 (1 replies)
  189. Code to automatically add new email address to a table (1 replies)
  190. Save Excel to PDF one page wide (4 replies)
  191. VBA export of cells with variable range (1 replies)
  192. Solved: Sum unique values in a range (9 replies)
  193. Code for not add the data in Sheet2 if all cells in range in Sheet1 are not filled (1 replies)
  194. Working with text for a report (5 replies)
  195. animated chart (1 replies)
  196. Who has a file open on SharePoint (0 replies)
  197. [SOLVED:] Check for presence of VBA Procedure in all modules (4 replies)
  198. VBA - PIVOT RELATIONSHIPS (1 replies)
  199. Cashflow Present Value Calculation (2 replies)
  200. Two doubts on some (i think) simple codes (10 replies)
  201. Solved: Delete a six-row block which occurs every n rows (5 replies)
  202. Solved: Continue Macro after Error Handler (4 replies)
  203. Help - Automate Pivot Filter Changes (2 replies)
  204. [SLEEPER:] Pulling custom footer from another sheet, to only appear on *final* page (8 replies)
  205. Solved: Lock Cells (Excel 2010) (5 replies)
  206. Solved: Pull data from other sheets (6 replies)
  207. Solved: Storing Values/Data beyond a subroutine (13 replies)
  208. Solved: Removing a item from a listbox (5 replies)
  209. Solved: Send Data to different workbook (2 replies)
  210. Finding data in a range (6 replies)
  211. Problem with IE automation - getElementsByTagName (0 replies)
  212. Function to Return an Array (8 replies)
  213. Loop to combine data in 2 columns and insert string every 145 combinations (1 replies)
  214. SUM variable range LOOP (9 replies)
  215. Load text files to ONE sheet (1 replies)
  216. How to write a vba code (9 replies)
  217. Conditional Paste (2 replies)
  218. Solved: Help Importing multiple XML files - VBA (9 replies)
  219. How to find exact substring within a cell (2 replies)
  220. Loop through files in a directory and delete if not currently in use (19 replies)
  221. Solved: Use Index, Match, and Max VBA (1 replies)
  222. How to count number of red color in a row (32 replies)
  223. Axis Rounding (decimals, tens, hundreds, etc.) (0 replies)
  224. Solved: match 2 columns and display 3rd column value (2 replies)
  225. Solved: Dir function skipping the first file (4 replies)
  226. HELP! (11 replies)
  227. WHATS IT TAKE TO GET A ANSWER (5 replies)
  228. Solved: Sum a column B where column A is the same in two different sheets (8 replies)
  229. Detecting Multiple Active Sheets (1 replies)
  230. Multiple goal sheek code error (1 replies)
  231. Linking Combo boxes (3 replies)
  232. Solved: Make a Summary Sheet (17 replies)
  233. Refresh Data Connections in VBA then Message Box (3 replies)
  234. Close IE using Caption Name (1 replies)
  235. Pictures - Grouping and Flip (0 replies)
  236. Find all black cells in a range (3 replies)
  237. Solved: VBA help (5 replies)
  238. VBA script to move files from one folder to 3 and populate list of files (2 replies)
  239. Solved: Problem with Proper Case (2 replies)
  240. Combining "Force users to enable macros in a workbook" and "Disable Cut, Copy, Paste" (8 replies)
  241. Solved: Another Dynamic Range Question (4 replies)
  242. [SOLVED:] Object Required For Parameter (3 replies)
  243. Naming Array (5 replies)
  244. Pop-up Error Message (4 replies)
  245. First Factor Formula (6 replies)
  246. Auto-insert comment, auto insert date and time (6 replies)
  247. Solved: vba auto row insert and revert back (20 replies)
  248. Merge “Paste Values only” VBA code with “force macros” VBA code and place the code in (4 replies)
  249. VBA to autofilter on current date (8 replies)
  250. Solved: Need VBA code to split quantities based on availability in another table (2 replies)