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 174
  1. Setting Default SaveAs Name Before Saving Workbook (5 replies)
  2. ComboBox_Click event is firing for any change on any worksheet (10 replies)
  3. [SOLVED:] MACRO - Create worksheet adding an apostrophe (9 replies)
  4. [SOLVED:] What is wrong with delete worksheet? (14 replies)
  5. How do I paste an array of predefined ranges from excel into powerpoint as embed/link (4 replies)
  6. Copying sheets using vba (8 replies)
  7. [SOLVED:] Importing large text file, extracting lat-long, and converting to decimal (5 replies)
  8. Data validation formula rules (15 replies)
  9. [SOLVED:] pivot table question (4 replies)
  10. Help with FileFormat issue (5 replies)
  11. Excel 2013 Print Preview Code (1 replies)
  12. Date / Business Date (2 replies)
  13. [SOLVED:] Reformat Times (12 replies)
  14. Column Charts - Dashboards (2 replies)
  15. excel as a search engine (1 replies)
  16. [SOLVED:] Finding for duplicates in Column A (10 replies)
  17. evaluate comma separated month in abbreviation with number in a cell (1 replies)
  18. [SOLVED:] Yahoo finance option quote - unable to parse data (8 replies)
  19. Need help about this question! (7 replies)
  20. If, And, Or (9 replies)
  21. [SOLVED:] Help Please :) (13 replies)
  22. VBA code for saving xls. (2 replies)
  23. VBA Macro - Extract Price and Flight Info from Skyscanner (0 replies)
  24. Speed up VBA filtering (2 replies)
  25. [SOLVED:] VBA Concatenate Counter With Text Constant (2 replies)
  26. VBA code to import .mdb file into excel 2013 (3 replies)
  27. Creating a new "All Day Event" In Outlook Using Excel 2010 (8 replies)
  28. elements of array (4 replies)
  29. Archiving Rows on Excel using VBA (6 replies)
  30. [SOLVED:] Excel - Increment to the Next Column Loop Counter (5 replies)
  31. Listview control (2 replies)
  32. [SOLVED:] Cell displays an error unless the column is double clicked (6 replies)
  33. VBA Macro code to get an alert message when a condition is met (1 replies)
  34. [SOLVED:] Macro to replace text with incremental number (6 replies)
  35. [SOLVED:] Inserting Image on several worksheets in same workbook (7 replies)
  36. VBA codes to extract pdf files to excel (2 replies)
  37. [SOLVED:] Change date Format (4 replies)
  38. Macro to search column, copy row and insert (2 replies)
  39. How to Create Function for Matrix Multiplication (2 replies)
  40. Search Webpage for word (11 replies)
  41. [SOLVED:] Concatanation in a new column (4 replies)
  42. copying unstriked data (1 replies)
  43. [SOLVED:] How to use an array to copy filter range into new worksheet? (13 replies)
  44. Randomly Sort Teams Button (3 replies)
  45. [SOLVED:] Sort each group in descending order (4 replies)
  46. [SOLVED:] Copy Paste Cell Values - If InString to Different Worksheets (3 replies)
  47. [SOLVED:] Deal with areas by specific string (7 replies)
  48. Delete duplicate cells on rows (7 replies)
  49. [SOLVED:] Coil spring VB image (13 replies)
  50. [SOLVED:] VBA Request (5 replies)
  51. [SOLVED:] VBA to stack top row into columns (6 replies)
  52. [SOLVED:] Macro for copying flexible ranges as pictures to PPT (4 replies)
  53. [SOLVED:] ImageControl Retrieve Values on Memory (9 replies)
  54. If Function to: Reject based on birthday (8 replies)
  55. [SOLVED:] Calculating number of days between 2 dates (6 replies)
  56. [SOLVED:] Macros to insert, 'draw' 52 degree lines in excel (1 replies)
  57. Functions in cells prevent finding last cell value in table columns (3 replies)
  58. [SOLVED:] Analyzing Customer Comments (1 replies)
  59. Having trouble looping macro through active worksheets (8 replies)
  60. Graphics.FromImage VBNet to VBA Excel (0 replies)
  61. Review for Best Method (4 replies)
  62. How to edit the color of the cell? (4 replies)
  63. [SOLVED:] Filling two listboxes (5 replies)
  64. Add-ins don't work (4 replies)
  65. Change a variable without effecting other data rows (2 replies)
  66. Simple Copy/Paste - columns from one sheet/workbook - to a different sheet/workbook (2 replies)
  67. Compare two workbooks and highlight the differences in the third workbook (6 replies)
  68. [SOLVED:] Replace text in cell with picture (or insert picture into same cell) (22 replies)
  69. [SOLVED:] Save embedded PDF file as a separate PDf file (5 replies)
  70. [SOLVED:] Need to check if a picture exist or not then delete (2 replies)
  71. Userform Personal Workbook - Runtime Dynamic Population - Run Code Module Macro (5 replies)
  72. Filter Dates to previous month (4 replies)
  73. [SOLVED:] All Mondays in a date range (18 replies)
  74. [SOLVED:] Filter Pivot Results In Crash (9 replies)
  75. [SOLVED:] VBA Help - analyzing rows to create a single column (2 replies)
  76. How to switch to the newly created Internet Explore document (2 replies)
  77. [SOLVED:] Associating Unique Variables To HyperLinks In Cell Range (5 replies)
  78. [SOLVED:] Macro help - Autofill multiple cells to dynamic range (12 replies)
  79. VBA - select a drop-down in a web (2 replies)
  80. Select specific tab in already open instance of Internet Explorer (0 replies)
  81. [SOLVED:] Excel VBA Project References (7 replies)
  82. Advanced Auto Filter Long Text Strings From List Table (3 replies)
  83. Toggle Shape Text & Colour On Click - Application.Caller (1 replies)
  84. [SOLVED:] Storing unique values in array (4 replies)
  85. Create Pivot Table from multiple sheets (1 replies)
  86. Filtered visible cells to Userform as row source. (5 replies)
  87. Polygone färben (2 replies)
  88. [SOLVED:] Summarize Data to New Sheet (20 replies)
  89. [SOLVED:] Automate Lookup Function to create participant schedules (7 replies)
  90. [SOLVED:] Add to Dynamic List if it doesn't exist (2 replies)
  91. [SLEEPER:] Copy Rows - If Column B has the Word Found in a Worksheet List (2 replies)
  92. List all possible order combinations (3 replies)
  93. excel spreadsheet with macro to run without openning excel in specific time everyday (3 replies)
  94. VBA - Copy/Paste in new sheet + delete blank cells (6 replies)
  95. VBA - search and display the results from the websites (5 replies)
  96. copying data from worksheet to another (19 replies)
  97. Combo box data to select sheet (16 replies)
  98. ReadLine command for UNIX txt file (4 replies)
  99. Picturebox in Worksheet SetPixel (0 replies)
  100. If Statement Excel Macro (9 replies)
  101. help to fetch data from a closed file in excel (3 replies)
  102. [SOLVED:] UserForm Update/TextBox DblClick (11 replies)
  103. [SOLVED:] For loop very bad performance (8 replies)
  104. Import Data from txt file in specific cells (8 replies)
  105. Macro encrypt-decrypt function in one (1 replies)
  106. VBA Macro to combine workbooks in a folder into a "Master sheet" (2 replies)
  107. [SLEEPER:] copying all columns including hidden (2 replies)
  108. [SOLVED:] Send data from multiple worksheet to a summary worksheet (3 replies)
  109. saving selected worksheets into new file (1 replies)
  110. VBA for Input Date (11 replies)
  111. [SOLVED:] Macro to Change all Date formats in workbook to 01/2017 to 01.2017 (and vice versa) (8 replies)
  112. [SLEEPER:] Macro to UnGroup and Group Based on Current Month (1 replies)
  113. Receipt Format (3 replies)
  114. [SOLVED:] Look for duplicates across 2 identical tabs, remove then merge remaining data (4 replies)
  115. Navigate web pages until search complete (1 replies)
  116. [SOLVED:] Reference Another Workbook Using Relative and Fixed Cell References (3 replies)
  117. [SOLVED:] Concatenate Rows Of Data (4 replies)
  118. Target.value (2 replies)
  119. Find Multiple String Variables in a different sheet (5 replies)
  120. Automating Internet Explorer / Interacting with HTML class question (0 replies)
  121. [SOLVED:] Clear Data Module - Clearing Header when No Data (3 replies)
  122. [SOLVED:] ndate returning time in Holland not London (10 replies)
  123. [SLEEPER:] Pivotal Filter Selection Macro (25 replies)
  124. Compare two images (1 replies)
  125. VBA for make resume by date (Unique & No Duplicate) (3 replies)
  126. Download File from Website From Excel (2 replies)
  127. Excel - how to hide columns but allow users to insert rows (1 replies)
  128. InStr - Not operating (6 replies)
  129. Convert Excel to Web Application (1 replies)
  130. userform textbox test for format (2 replies)
  131. Outlook 2013 Global Address List Alias to Excel Document (0 replies)
  132. Improving a Concatenate & Vlookup Process (1 replies)
  133. Excel Macro Find and Replace Functions within Cell Formulae (21 replies)
  134. [SOLVED:] Write from excel to text file format (3 replies)
  135. excel vba macros help needed (9 replies)
  136. evaluate a date with vba (4 replies)
  137. Accessing a network file that might already be open by another user (0 replies)
  138. [SOLVED:] Select next cell after dynamic range (4 replies)
  139. [SOLVED:] OLE - Embedded Custom Icon won't stick (2 replies)
  140. [SOLVED:] Excel Select the Rows - Input Box - Save to Text Files (3 replies)
  141. The paste method of the _chart object failed (10 replies)
  142. [SOLVED:] Reading in a text file and only printing certain lines (3 replies)
  143. Implementing Save As function in VBA code (1 replies)
  144. Iterating through Groupings using VBA (4 replies)
  145. [SOLVED:] VBA macro to order and delete information (8 replies)
  146. Writing registry keys with API Calls (7 replies)
  147. VBA Newbie (Trying to write a code to copy and paste info from one sheet to another) (2 replies)
  148. Array Values filling specific cells (6 replies)
  149. passing string from userform to public module variable (1 replies)
  150. Auto populating text fields on websites and scraping the web (1 replies)
  151. Issue creating SQL query from string in VBA (3 replies)
  152. Need to split sheets based on number of family members (5 replies)
  153. [SOLVED:] How can I put the results of the Array back to the corresponding cells? (29 replies)
  154. Invoke an .exe file using macro in excel (1 replies)
  155. PivotSelect Question (4 replies)
  156. [SOLVED:] Applying Proper Case to Strings (10 replies)
  157. Reducing the need for Multiple hardline codes (40 replies)
  158. Changing a font style and color in VBA (9 replies)
  159. Reading a Text File into an Intermediate Window (12 replies)
  160. [SOLVED:] Stack bar chart configuration in Excel (2 replies)
  161. List select and copy sheet from another location (1 replies)
  162. Ask for Explanation (14 replies)
  163. How to refer on a picture on a different worksheet (6 replies)
  164. Userform Standalone/Hide Excel Application (0 replies)
  165. [SOLVED:] Check value based on cell text and turn another cell Green if there is a match (2 replies)
  166. [SOLVED:] autohide userform with active sheet modification (3 replies)
  167. Find DUP, remove both same entries (4 replies)
  168. calling inputbox if cell value is true (5 replies)
  169. [SOLVED:] No response to change event (4 replies)
  170. Automatically Converting Numbers stored as text to numers (1 replies)
  171. [SLEEPER:] VBA Autofilter 3 Criteria (14 replies)
  172. Adding prefix to cell in column as it is added (9 replies)
  173. Add row to table refering to a Cell Value (1 replies)
  174. [SOLVED:] .pattern help please (2 replies)
  175. Help with populating a table with values on other sheets (1 replies)
  176. drop down lists vba (0 replies)
  177. [SOLVED:] Image frame resolution (2 replies)
  178. [SOLVED:] thisworkbook.path and dir function (1 replies)
  179. [SLEEPER:] How to make Total Row always at the Last Row / bottom of the Printed Page (0 replies)
  180. Copy Transpose and Paste Macro (11 replies)
  181. [SOLVED:] Extract Numeric Substring From longer String (12 replies)
  182. [SOLVED:] Macro to Autofill (3 replies)
  183. VBA code to create Indented BOM (2 replies)
  184. Data Entry from Excel or CSV to AS400 Emulator is possible or not? (3 replies)
  185. [SOLVED:] Looping through checkboxes in user form (2 replies)
  186. Get rid of extra row height with Word Wrap (3 replies)
  187. [SOLVED:] Pull data from specific worksheet from multiple workbooks (2 replies)
  188. Get a Cell into a Standard Format depending on its Contents - UDF/Formula Only (8 replies)
  189. Autofill formula help (3 replies)
  190. Using .Value fails when initialising a user form (3 replies)
  191. explore the land owner (3 replies)
  192. Adding Worksheets to an Array (18 replies)
  193. Calculate months onwards from set date (2 replies)
  194. VBA for sending Bulk Email with Unique Attachments in XLS to Unique Receipient (10 replies)
  195. i could not paste the copied data (VBA) (1 replies)
  196. wildcard character is not working while opening excel file (5 replies)
  197. Issues with VBA's vbModeless for programmatically-created userforms: they close (5 replies)
  198. [SOLVED:] Array Relative Erase Variables but Next (4 replies)
  199. [SOLVED:] VBA for Auto Filter and Copy/Past the Visible Cells at Destination Workbook (14 replies)
  200. [SOLVED:] Help with Filtering...(autofilter) (6 replies)
  201. [SOLVED:] excel 2010 dashbord to show totals (2 replies)
  202. [SOLVED:] Please Modify this VBA for New Requirement Or Provide a New One (9 replies)
  203. [SOLVED:] To Pull out Certain Set of Data from a Cell [ Urgent ] (6 replies)
  204. VBA to write PDF froms from Excel, Radio Buttons (4 replies)
  205. [SOLVED:] Need a UDF to Identify and remove parts of Cell Data from a Range (2 replies)
  206. inputBox default input in code, user not input (5 replies)
  207. Find a name from a list of names (14 replies)
  208. VBA freeze / timeout when processing large data sets (6 replies)
  209. Smartview connection issue (0 replies)
  210. [SOLVED:] working with record sets (0 replies)
  211. [SOLVED:] 3 Contact Numbers along with , (coma) Too many arguments (2 replies)
  212. Ending a Sub on a Timer Loop (3 replies)
  213. sum if textbox <>"" (3 replies)
  214. [SLEEPER:] Can i create a Licence to an excel vba solution !? (1 replies)
  215. How to add cells with Conditional Formatting (1 replies)
  216. VBA code to delete row is value in column is less than a specific defined value (4 replies)
  217. [SOLVED:] Selecting pages to print within worksheet (4 replies)
  218. VBA - Verification of the sheet > MsgBox (5 replies)
  219. VBA (Noob): Automatically select the next row (8 replies)
  220. [SOLVED:] Is there a way to add Arrow Keys to Excel's Quick Access Toolbar? (2 replies)
  221. Check if library exists (8 replies)
  222. [SOLVED:] Copy/Paste unique rows based on multiple criteria (8 replies)
  223. Different custom ribbon for each sheet (0 replies)
  224. Defining Name Ranges Using VBA (3 replies)
  225. [SOLVED:] Need to remove a certain part of cell Data (8 replies)
  226. Lookup Text Value (0 replies)
  227. Copy / Display row from another sheet (18 replies)
  228. Didn't work my macro to copy&paste only as formulas by default... can you give it a q (4 replies)
  229. [SOLVED:] Adding A Reference (8 replies)
  230. [SOLVED:] Show Column Headings in PDF's to Be Emailed (2 replies)
  231. VB Excel, increase factor in table (5 replies)
  232. about Array (13 replies)
  233. [SOLVED:] Delete row if it contains a certain criteria Please Help (2 replies)
  234. [SOLVED:] Macro to delete rows (5 replies)
  235. Excel VBA: limit file opening times, AND prevent copying. plus authorization code (9 replies)
  236. [SOLVED:] Non-Printing Characters: Box with a Question Mark Unable to remove (15 replies)
  237. count the number of changes in several cells (1 replies)
  238. Choose date and calculate onwards (11 replies)
  239. Extracting and refreshing data set (5 replies)
  240. Date generating (8 replies)
  241. [SOLVED:] Using If function to separate data into multiple sheet (21 replies)
  242. Excel eMail sending failure in Windows 10 (3 replies)
  243. Need to consolidate comments across spreadsheets (4 replies)
  244. [SOLVED:] In a userform, applying results to a different workbook (3 replies)
  245. [SOLVED:] Automatically readjusting a Pivot Table's data source range (3 replies)
  246. [SOLVED:] Remove numbers of a 1st column founded in a 2nd one (1 replies)
  247. [SOLVED:] Need help with Multiple Pivot Table PivotField filters (1 replies)
  248. [SOLVED:] Printing multiple ranges/charts from different sheets at the same time? (5 replies)
  249. Need help with MSXML2.serverXMLHTTP request (0 replies)
  250. [SOLVED:] VBA search (18 replies)