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. Formula for a table which does not exist (7 replies)
  2. OPEN: Excel Macro Save As with a new file name (5 replies)
  3. [SOLVED:] Supply one password to unlock all code in workbook (9 replies)
  4. [SOLVED:] Excel Save Error (12 replies)
  5. [SOLVED:] Selecting and deleting rows based on criteria (62 replies)
  6. [SOLVED:] #REF! (2 replies)
  7. Print sheet after update shapes/images (1 replies)
  8. Arranging data datewise (3 replies)
  9. Screen capture (print screen) to new Excel workbook or Word (11 replies)
  10. [SOLVED:] Trying to check if a checkbox is checked (3 replies)
  11. [SOLVED:] Objects and invalid use of property (2 replies)
  12. Importing Images Into Excel 2013 (8 replies)
  13. [SOLVED:] VBA: Mixing Relative & Absolute References (6 replies)
  14. SAS add in Advanced VBA question (6 replies)
  15. [SOLVED:] create a new checkbox and assign its ID? (2 replies)
  16. Copying part of a Text String of different lengths (16 replies)
  17. add individual rows to outlook calender with button (5 replies)
  18. [SOLVED:] Method Intersect Error (3 replies)
  19. Macro has working very slowly; How to speed up this macro. (2 replies)
  20. [SOLVED:] Macro to Consolidate multiple workbooks into new workbook based on criteria (3 replies)
  21. [SOLVED:] Deleting positive values in 45,000 row database (9 replies)
  22. Finding First Value that Falls in a Range Across Multiple Columns (4 replies)
  23. Changing the value of a pivot item (3 replies)
  24. [SOLVED:] Change 'Entire Row delete' to 'cells in columns A-G' (3 replies)
  25. Based on Condition Merge and CountIF & Apply (0 replies)
  26. [SOLVED:] Loop through a dynamic range and apply code in a seperate sheet (5 replies)
  27. Macro to copy data from different cells and paste in new sheet (5 replies)
  28. Text populate containing more records based on date (6 replies)
  29. [SOLVED:] One sub Button Two Macros (6 replies)
  30. how do I work with objects (pass objects to objects?) (5 replies)
  31. Creating New File Off Template and then some EXCEL MACROS (3 replies)
  32. [SOLVED:] Need help to calculate average of those cells between two blank cells (4 replies)
  33. 400 Error (1 replies)
  34. [SOLVED:] I am Having a challenge with ThisWorkbook.Close (29 replies)
  35. xml download "argument not optional" (2 replies)
  36. [SOLVED:] Cannot get xlSaveDialogAs or GetSaveAsFilename to work as required (15 replies)
  37. compare 2 sheet and all column if find duplicate will delete on sheet 2 (2 replies)
  38. [SOLVED:] When running a macro, Excel suddenly stops responding (5 replies)
  39. [SOLVED:] if find the matched data in another work workbook copy the complete row (1 replies)
  40. [SOLVED:] clean a row if it doesn't start with a number except _ (3 replies)
  41. [SOLVED:] When does a Workbook become a member of the WorkBooks Collection? (11 replies)
  42. [SOLVED:] Convert Cell Value in a range of cells (12 replies)
  43. Sleeper: Look up & return (7 replies)
  44. [SOLVED:] Linking/merging two worksheet_change functions (4 replies)
  45. [SOLVED:] Create a Loop - Help! (9 replies)
  46. [SOLVED:] Referencing a Userform in a module (4 replies)
  47. Excel CalCulation Issue (7 replies)
  48. Ribbon Change which works as an ADD-IN (1 replies)
  49. [SOLVED:] Conditional Compilation Quick Question (Well, at least hopefully) (17 replies)
  50. Find a unique value with a condition across 2 lists, add it to the less complete list (1 replies)
  51. Function isn't working on button click (10 replies)
  52. [SOLVED:] help needed to adjust a macro (4 replies)
  53. Who has ever met this? (5 replies)
  54. [SOLVED:] Find Method w/ VALUE error (19 replies)
  55. Input Box is popping too much. (2 replies)
  56. [SOLVED:] Get an automatic sequence in a formula (2 replies)
  57. VBA Conditional formatting if one cell equals another cell in value (3 replies)
  58. Requesting a macro for printing an Excel sheet automatically as PDF on daily basis. (1 replies)
  59. New to VBA. Getting a Compile Error. Please help. (4 replies)
  60. [SOLVED:] Problem Word Wrapping VBE Code (3 replies)
  61. Unlocking all Excel (2007) cells by default (2 replies)
  62. Automatically generating custom timeline on separate tab (Excel 2010) (6 replies)
  63. [SOLVED:] Moving automatically generated page breaks (2 replies)
  64. [SOLVED:] List all Open Window titles in column A (4 replies)
  65. How to use vlookup and countif together in one formula? (9 replies)
  66. extract data from txt file (9 replies)
  67. HELP - Copy Variable Sheet Range from multiple sheets to Summary Sheet (2 replies)
  68. [SOLVED:] Strange behaviour ListBox.Selected(index). (31 replies)
  69. If no error, write the word "ok" to a cell? (3 replies)
  70. [SOLVED:] Use Contents of ComboBox in Vlookup and Save to Data Table (4 replies)
  71. VBA Code to change Color in range of Cells. (3 replies)
  72. Best Tutorials / Courses / Reading to Master Excel (3 replies)
  73. Web Query refresh issue (0 replies)
  74. Compare 2 sheet and paste the resault on sheet3 (6 replies)
  75. [SOLVED:] hrefs from an ordered list <ol> on a webpage in Internet Explorer (3 replies)
  76. [SOLVED:] Lookup value in table with two criteria in rows (10 replies)
  77. Paste data from word table into excel sheet while skipping hidden columns (8 replies)
  78. [SOLVED:] Macro works in Excel 2003 but not in Excel 2007/2010 (2 replies)
  79. Excel VBA with Pivot Table (15 replies)
  80. Why a variable of type Range does not accept Nothing when cutting range of cells? (24 replies)
  81. macro to lookup record on current row and mark completion date to corresponding recor (8 replies)
  82. Import External Data (0 replies)
  83. Free Standing Alternatives to Excel Database (13 replies)
  84. Help with "Array fuctioons" (5 replies)
  85. VBA userform - decimal separator (5 replies)
  86. Unique Rank Question (2 replies)
  87. [SOLVED:] CDATA with values from the active worksheet (2 replies)
  88. [SOLVED:] VBA code works in office 2007 not in office 2010(embeds an attachment in excel) (25 replies)
  89. [SOLVED:] Problem with move more thab 65536 (8 replies)
  90. [SOLVED:] Weird Cell formatting (10 replies)
  91. [SOLVED:] Special Characters (6 replies)
  92. [SOLVED:] Copy to the latest blank row (2 replies)
  93. How to create a formula for a drop down list?? (2 replies)
  94. VBA chess game, userform (19 replies)
  95. [SOLVED:] Intersect - very basic problem (2 replies)
  96. [SOLVED:] VBA IF functions (Help) (10 replies)
  97. [SOLVED:] Change Row Color based on Cell String Match (7 replies)
  98. [SOLVED:] Where To Put Code (12 replies)
  99. Need help creating a loop macro that spits out a master data file (12 replies)
  100. [SOLVED:] Merging Duplicate in Column A (4 replies)
  101. [SOLVED:] Similarly named textboxes - loop (5 replies)
  102. Monitor Folder code goes into a loop (24 replies)
  103. Open an email Lotus notes and copy the content to excel (7 replies)
  104. Need Help on : Application.Filesearch (2 replies)
  105. [SOLVED:] Comparing lists of values, & adding unique values to the 1st blank cells of a range (5 replies)
  106. [SOLVED:] add header/footer to new word document from excel (3 replies)
  107. Sleeper: Tricky For Loop Code (4 replies)
  108. Comunicate between 2 userforms (3 replies)
  109. VBA LOOP Macro (13 replies)
  110. [SOLVED:] Delete duplicates (based on the same line multiple columns) (13 replies)
  111. I Need Vba Code Copy Of Cell And Paste To Other Cell (11 replies)
  112. COPY AND PASTE VALUE - CELLS WITH SPECIFIC VALUES USING A MACRO (8 replies)
  113. Get list<T> from c# dll and access to its items (1 replies)
  114. Resize userform VBA (8 replies)
  115. [SOLVED:] need help with counting sheets with specific names plus adding sheets after them (6 replies)
  116. [SOLVED:] Inaccurate results from formula (3 replies)
  117. [SOLVED:] StopWatch or Timer Class Module (2 replies)
  118. Excel - Use Dropdown menu populate a column (3 replies)
  119. Automate calculation using First in First Out way (13 replies)
  120. [SOLVED:] Using VBA With OOo (2 replies)
  121. [SOLVED:] Have I got the wrong documentation? (3 replies)
  122. Replacing text with a image (4 replies)
  123. [SOLVED:] Count textbox values greater than 0 (2 replies)
  124. [SOLVED:] How make defined range move upon sort? (15 replies)
  125. Randomly Select 4 Column Ranges and Copy and Paste to Another Worksheet (17 replies)
  126. compare columns of two workbooks and add to master workbook (23 replies)
  127. [SOLVED:] Multiselect Listbox Help (15 replies)
  128. [SOLVED:] Saving Files As Read-Only (0 replies)
  129. [SOLVED:] Macro exits sub after calling macro from another workbook (Application.Run) (9 replies)
  130. [SOLVED:] Applying icon to commad BAR not button (user defined add in) (5 replies)
  131. Macro for drop down menu based message box (4 replies)
  132. Macro for drop down menu based message box (1 replies)
  133. [SOLVED:] InStr exact match (5 replies)
  134. Sorting GPS marks (42 replies)
  135. [SOLVED:] Find VBA Multiple criterias (17 replies)
  136. if Dependent is not on the same sheet, then the cell will be given red colour (9 replies)
  137. Advanced Formula (2 replies)
  138. Slow (1 replies)
  139. Userform in VBA and DATEDIFF function (8 replies)
  140. [SOLVED:] Using excel to connect to ERP SOAP webservice (10 replies)
  141. dynamic range lookup (1 replies)
  142. [SOLVED:] Separating Names From this dynamic list and summing them into Preset Cells VBA Excel (4 replies)
  143. [SOLVED:] Inserting a new Column (2 replies)
  144. Copying data from another Workbook row wise (1 replies)
  145. [SOLVED:] Looping through shapes by Name VBA Excel (12 replies)
  146. lookup word then apply formula (1 replies)
  147. [SOLVED:] Issue recording Pivot tables (3 replies)
  148. Importing Data From Web Page (4 replies)
  149. Force Macros Enabled And Close When Idle (6 replies)
  150. [SOLVED:] Naming A Shape and Connector Line After Its Creation"runtime" Excel VBA (2 replies)
  151. Using Excel to Connect to Oracle (5 replies)
  152. Changing font on certain letters (7 replies)
  153. .xml to excel conversion using vba (1 replies)
  154. On change event issues (1 replies)
  155. Choose Sheet AddIn (1 replies)
  156. Excel 2013: First Sheet and Last Sheet (3 replies)
  157. [SOLVED:] Show a message only once, using Application.OnTime (2 replies)
  158. [SOLVED:] Subtotal multiple blocks of data (2 replies)
  159. Hyperlinking (1 replies)
  160. INFINITE LOOP PROBLEM!!! (6 replies)
  161. Import Word document file name into Excel (9 replies)
  162. Randomize/shuffle a list of names (8 replies)
  163. Macros with buttons, spin buttons, scroll buttons, etc. (4 replies)
  164. Guidance on VBA Rota/Scheduler procedure/algorithm (1 replies)
  165. How to grab data from the site? (0 replies)
  166. [SOLVED:] Macro deletes text only in No Fill cells (8 replies)
  167. Excel 2013 erro 13 message (5 replies)
  168. [SOLVED:] To enter one space after single digit (6 replies)
  169. Dynamic Dependent ActiveX Dropdown from Column Data (1 replies)
  170. Cube Values Timing Out When Batch Printing PDFs (6 replies)
  171. [SOLVED:] Variable reference cell value (7 replies)
  172. Referencing multiple userforms (6 replies)
  173. Find Missing VBA Project References Code (10 replies)
  174. Absolutely no help the way this system works (4 replies)
  175. Using Macros to change data in a spreadsheet. (7 replies)
  176. [SOLVED:] How to use user defined function (bucket) (4 replies)
  177. Dowload outlook email attachment to my pc folder (0 replies)
  178. Compare 2 columns and remove matching duplicates in both columns when found (3 replies)
  179. [SOLVED:] Create a List of Pivot Table Report Filter Selections on Worksheet (3 replies)
  180. [SOLVED:] Quality check of data in InputBox (5 replies)
  181. activate an already open workbook or open if not open (5 replies)
  182. Specify Columns for HTML export (5 replies)
  183. Need code to run across an Array of sheets (1 replies)
  184. [SOLVED:] Copy Worksheet with Embedded Chart Object to New Workbook - values and formats only (2 replies)
  185. [SOLVED:] Combobox decides the picture to show (4 replies)
  186. [SOLVED:] Repeat 12 time the data on column A to column B (2 replies)
  187. [SOLVED:] Non-VBA question : Using OR criteria in an IF statement (7 replies)
  188. Array Param Problem with AutoFilter (2 replies)
  189. Auto Copy a website table into excel (2 replies)
  190. [SOLVED:] docking code pane (4 replies)
  191. [SOLVED:] Importing CVS files in to a worksheet (3 replies)
  192. Extract Hyperlinks from Word into Excel (8 replies)
  193. Getting a compile Error, Please help! (1 replies)
  194. [SOLVED:] quick help on using a variable to define a range (5 replies)
  195. RowNext starting from a certain Row (1 replies)
  196. How to make a list of Files and folders of a directory in excel (1 replies)
  197. Add on additional range in Loop (1 replies)
  198. help! i need a good soultion to a project i just got in school (5 replies)
  199. Worksheet Function In VBA (4 replies)
  200. Drop down list plus text box (1 replies)
  201. [SOLVED:] I get a boolean value instead of formula with my code =/ (4 replies)
  202. Copy website content in to excel (10 replies)
  203. VBA project help (2 replies)
  204. [SOLVED:] Determine # of workdays (2 replies)
  205. [SOLVED:] Select only Unlocked cell (4 replies)
  206. Need formula converting RGB to vba backcolor (2 replies)
  207. How can I copy and paste an entire sheet with pivot table and formats? (2 replies)
  208. [SOLVED:] Loop for worbook and worksheet changes (6 replies)
  209. Importing data from script-based web pages (1 replies)
  210. Add multiple series to graph using VBA (1 replies)
  211. [SOLVED:] Circular Reference Error (3 replies)
  212. [SOLVED:] Text code (2 replies)
  213. Tracking changes of a cell value with a line chart (7 replies)
  214. [SOLVED:] How to re-display Excel after opening and closing a Word document (10 replies)
  215. Need help pulling info from a list (1 replies)
  216. Change cell value within a row depending on other cell values within same row (1 replies)
  217. [SOLVED:] UF Lookup Image Help (6 replies)
  218. Import Data from Webpage (0 replies)
  219. ple.help .how to get multipule values from single lookupup value using vlookup in xl (0 replies)
  220. [SOLVED:] Timing of UserForm Display (2 replies)
  221. [SOLVED:] Copy two ranges in one row to the one below, same format if possible... Little help?! (3 replies)
  222. VBA loop and printing help (1 replies)
  223. Import from Web - Code Interruption (12 replies)
  224. Very weird problem - Excel 2007 Worksheet manipulation (5 replies)
  225. [SOLVED:] Deactivate Add-in and save .xlsm as Add-in then activate the ADD-IN again (5 replies)
  226. Selecting range relative to found values - Multiple Instances (2 replies)
  227. Odd behaviour of a worksheet. (5 replies)
  228. Simple Database Build (1 replies)
  229. [SOLVED:] UF To Spreadsheet Help (4 replies)
  230. Save Workbook Macro Issue (1 replies)
  231. Protect VBA Project one workbook through Another Workbook in VBA (3 replies)
  232. [SOLVED:] Adapt sub to execute from primary workbook (1 replies)
  233. The Replace method - A newbie needs help! (4 replies)
  234. 5 Years Annual Turnover calculated from a start date (6 replies)
  235. [SOLVED:] Changing the properties of an embedded chart without select or activate (3 replies)
  236. VBA to compare string and replace a sub string with other value (3 replies)
  237. Insert Record from Excel to MySql using VBA (0 replies)
  238. Macro to loop in through Word files(.doc), find and delete a section, save and close. (2 replies)
  239. Combine Multiple Workbooks onto Master Workbook - Separate Worksheets (0 replies)
  240. [SOLVED:] worksheet hiding depending on content of worksheet cell (2 replies)
  241. [SOLVED:] UF Image Event (5 replies)
  242. [SOLVED:] Selected Listbox item select in sheet cell (2 replies)
  243. [SOLVED:] Placing an arrow and change its position (10 replies)
  244. 2007 date formatting (13 replies)
  245. cannot find MenuSheet in Excel Add-in (5 replies)
  246. How to pull airport flight time from web to excel? (0 replies)
  247. Help Consolidating Data Please (2 replies)
  248. pdf print from multiple sheet (issue) (0 replies)
  249. [SOLVED:] Search repated word in excel using VBA (2 replies)
  250. Simple Data List Help (2 replies)