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. VB disable conditional formatting code (1 replies)
  2. How to create a sequence of dates? (1 replies)
  3. Copying sheets into new workbook (4 replies)
  4. simple auto macro :) (4 replies)
  5. getting the row numbers of visible rows in an filtered selection (3 replies)
  6. Using conditional formatting (5 replies)
  7. How to copy an active Excel worksheet to another excel file? (1 replies)
  8. Solved: Command Button (Save as PDF) (5 replies)
  9. Can somebody help to achieve following tasks? (1 replies)
  10. Worksheet on change code a bit slow (3 replies)
  11. Reference across sheets (1 replies)
  12. Insert and Delete Rows in Entire Workbook (8 replies)
  13. Solved: Stop watch in excel which just displays minutes (5 replies)
  14. FileSystemObject create file containing text copied from IE (2 replies)
  15. Getting Application defined error 1004 for vba (1 replies)
  16. Save as xlsm function (2 replies)
  17. Solved: Calculate Distribution (8 replies)
  18. find closest date (4 replies)
  19. Solved: Opening and writing to multiple ASCII text files (6 replies)
  20. Solved: Detecting Last Time File Was Opened (6 replies)
  21. Sleeper: Macro loop issues (2 replies)
  22. Macro Triggers Unreadable Content Error on Restart (2 replies)
  23. Macro is getting Runtime error 91 - why? (3 replies)
  24. Excel 2 XML using Macro (1 replies)
  25. Project locked for viewing - SendKeys? (32 replies)
  26. Solved: Loop through multiple sheets and delete rows based on a cell reference (4 replies)
  27. Accessing files in order of Date Last modified (1 replies)
  28. Solved: Dynamically populate combobox in userform (10 replies)
  29. Solved: function to find the number of iterations/loops Do...Loop (7 replies)
  30. Synchronizing Multiple Worksheets (1 replies)
  31. Solved: CAGR formula using only range as input (7 replies)
  32. VBA from Excel to Outlook 2010 help (2 replies)
  33. Master Directory Search (Needs A Tweak) (6 replies)
  34. Find all hard coded references (14 replies)
  35. Change Dropdown Macro (1 replies)
  36. Solved: code running too fast? (9 replies)
  37. Solved: run macro from one workbok to affect other workbook (3 replies)
  38. How to post sample excel data (1 replies)
  39. VBA Help - Desk sharing solution - thanks in advance (1 replies)
  40. Drop Down List to Copy Contents of Another Column into a Certain Column (4 replies)
  41. VBA pivot with no range (3 replies)
  42. VBA HELP! - Need slight change to my code (9 replies)
  43. Total values associated with unique value in adjacent column (5 replies)
  44. Solved: Converting the VB code to VBA. (6 replies)
  45. [SOLVED:] 3 cells USERFORM to enroll in one cell in excel (2 replies)
  46. Something odd has happened with an "Always on Top" window. (8 replies)
  47. Solved: VBA Copy a template sheet and paste it into multiple sheets (2 replies)
  48. Combine multiple rows into one and then seprate specific columns (1 replies)
  49. Adding MMM-YY to filename (1 replies)
  50. To paste in Word the selected text in webpage by an Excel macro (1 replies)
  51. Macro doesn’t work after a table is created. (5 replies)
  52. VBA with PI Datalink (2 replies)
  53. Solved: Dynamically setting a dropdown dependant upon cell value (4 replies)
  54. Help getting script to exit if cell is blank (1 replies)
  55. Sort duplicates on top (1 replies)
  56. Copying and pasting cells from Excel to a fillable PDF file (7 replies)
  57. [SOLVED:] Split Data in one cell into below rows (4 replies)
  58. Array raising each element to a power - please help! (3 replies)
  59. To get in Excel the URL of the opened Webpage ? (1 replies)
  60. Input box to select sheet then rename sheet (2 replies)
  61. Compare two worksheets and give the difference as result (3 replies)
  62. [SOLVED:] Many urgent excel at vertical instead of horizontal word (5 replies)
  63. Open Workbook transfer info then close workbook (2007) (2 replies)
  64. Solved: help getting listindex from listbox (1 replies)
  65. Multiple LIKE operators? (10 replies)
  66. Solved: Loop Help (3 replies)
  67. fill Combo box data acroding to text box data entry. (4 replies)
  68. Retreiving the properties out of a class. (4 replies)
  69. Conditional formatting according to range (3 replies)
  70. Solved: msgbox displaying new workbook object path (7 replies)
  71. Closed workbook and extract sheet by cell value (4 replies)
  72. Find the Double ID (11 replies)
  73. Solved: populate with range from another sheet (4 replies)
  74. [SOLVED:] Application or Object defined error (2 replies)
  75. Pop Up Message Keeps popping up (5 replies)
  76. Solved: how to copy range and paste in same range in another workbook (3 replies)
  77. Macro for hidding and unhidding sheets (14 replies)
  78. [SOLVED:] Setting Pivot Chart height at pivot table refresh (4 replies)
  79. [SLEEPER:] Retrieve Values through an RS232 Connection (3 replies)
  80. Find Times Greater than Time Entered (1 replies)
  81. Auto-filter turning off in protected worksheet (2 replies)
  82. Worksheet Security based on Windows ID (1 replies)
  83. Excel Page Format-help pls. (6 replies)
  84. Macro showing various errors in my code for charts. (1 replies)
  85. VBA excel 2011 save as PDF (9 replies)
  86. VBA to view QT Connection String (13 replies)
  87. SQL Statement Help (9 replies)
  88. Search and highlight project help (3 replies)
  89. Solved: Lock a row after a value is chosen from a drop down menu (6 replies)
  90. Need some code tweaking. To scan text files to find certain figures (5 replies)
  91. Combine over 100 workbooks into a single workbook (3 replies)
  92. Sub based on form control checkbox (13 replies)
  93. Copying Column A to Column E and removing the 4th cell of each value (7 replies)
  94. [SOLVED:] Transpose ADO import (16 replies)
  95. TurnOff AutoCalc on one sheet only (10 replies)
  96. Variable Sheet name issue (7 replies)
  97. Linking Cells From Two Worksheets - Advanced (0 replies)
  98. Check first 10 characters of every file in list (17 replies)
  99. range determined by cell value (13 replies)
  100. help needed to update and edit data from Userform to worksheet. (5 replies)
  101. Populate ComboBox with text/value (0 replies)
  102. Solved: Append function formula to range (3 replies)
  103. Solved: Remove line break in cell (4 replies)
  104. Adding progress bar to existing code (4 replies)
  105. Solved: if column B is empy delete the data on column A (2 replies)
  106. Filling table i e-mail (2 replies)
  107. Solved: Remove the comma of the first cell (7 replies)
  108. Set noteApp = CreateObject("notepad.Application") , failed (12 replies)
  109. Solved: Hyperlinks to sheet with single quote in name (7 replies)
  110. Find Function excel VBA Help (1 replies)
  111. Cant get the macro to click a button (1 replies)
  112. Show sum of textboxes in a textbox. (3 replies)
  113. Solved: Combine data from row to one cell (2 replies)
  114. Converting Word to PDF using VBA (5 replies)
  115. Single Cell to ListBox (2 replies)
  116. Solved: Deinstall Add-in? (2 replies)
  117. Application Defined or Object Defined error (3 replies)
  118. Solved: select correct sheet if complied to 2 values on a selected worksheet (2 replies)
  119. Deleting Worksheets Containing Dates Older than X (2 replies)
  120. Solved: mergeing all date in each row (5 replies)
  121. Solved: Copy Paste from Dropdown (2 replies)
  122. Solved: Populate listbox based on sheet selected from a ComboBox (2 replies)
  123. delete all the entries based on the user input (2 replies)
  124. Excel sheet cell referencing. (6 replies)
  125. How to protect VBA if read-only? (2 replies)
  126. Basic problem needs help: undesired looping in alternate rows (3 replies)
  127. Importing Tables From Word Into Excel Spreadsheet Cells (7 replies)
  128. Solved: faster way to delete cells not containing certain word (5 replies)
  129. Active Cell formula to change automatically (11 replies)
  130. Solved: Divide column based upon character count (4 replies)
  131. Solved: Find specific word from text string and poulate in seperate cell (continuation) (5 replies)
  132. VBA code comboboxes (skip blanks & avoid repeats) (16 replies)
  133. Macro works part does not change the picture (3 replies)
  134. combine workbooks with same column count (0 replies)
  135. Mental Math workbook - vba to copy down (23 replies)
  136. Finding file name by numerical order (9 replies)
  137. Solved: Branch to specific line in another macro (5 replies)
  138. Solved: VBA Code Help please :) (14 replies)
  139. Pivot Chart Macro Problem In Excel (2 replies)
  140. Solved: Find specific word from text string and poulate in seperate cell (7 replies)
  141. Solved: VLOOKUP or INDEX/MATCH ? (2 replies)
  142. ADOX :Object or provider is not capable of performing requested operation (1 replies)
  143. Solved: VBA: Unusual LastRow Range (6 replies)
  144. Start HTML parsing at an already open webpage (2 replies)
  145. Solved: Evaluate("INDEX vs Application.Index (4 replies)
  146. Problems with variables and properties (3 replies)
  147. unlock the vba project (6 replies)
  148. Sleeper: Changing the current macro using if Statement or offset (6 replies)
  149. Solved: Change code to Private Sub Worksheet_Change (ByVal Target As Range) (12 replies)
  150. Highlight current row & column revisited (7 replies)
  151. Run Time Error 7 Out of memory Issues (3 replies)
  152. [SOLVED:] Populate a two column search result (4 replies)
  153. Solved: Incremental counter that resets every year (7 replies)
  154. Help Troubleshooting a VBA Application (1 replies)
  155. Solved: COUNTIFS Formula not working in Excel 2007 (2 replies)
  156. Simple one - one cell - another cell, both datetime cells (1 replies)
  157. Solved: Using an Access form as a Dialog sheet? (3 replies)
  158. Solved: Event Macro to add text to cell (8 replies)
  159. Performing Find loop on all Word documents in a folder, writing results to a Spreadsh (5 replies)
  160. Flagging Rows based on Several Variables within the Row (8 replies)
  161. Managing and copying data obtained from UserForm (0 replies)
  162. Arrange (Cut and Insert Cut Cells) Rows using VBA Code (5 replies)
  163. Solved: Code Selection Change is fired by Enter key (14 replies)
  164. Open Files that include todays date (2 replies)
  165. [SOLVED:] Stopping a macro using a macro! (30 replies)
  166. Solved: Copy from sheet1 & paste to sheet2 in corresponding column (9 replies)
  167. Case in Case in If then .. else ... end if: compilation error (6 replies)
  168. Vba code for parent-child (9 replies)
  169. Incredibly Urgent Help - VBA Excel (12 replies)
  170. Solved: Add "<br />" before number. (7 replies)
  171. Criteria for Sumif (3 replies)
  172. Comparison of a set range of columns in Sheet2 to insert correct image to userform... (3 replies)
  173. pulling excel variable into webform and submit (1 replies)
  174. [SOLVED:] Changing several button properties only for the buttons in a list (1 replies)
  175. Solved: Unique record ID generator: please help! (17 replies)
  176. OWC10 issues (17 replies)
  177. Solved: VBA (7 replies)
  178. Using a filter to identify, copy and paste using VBA (0 replies)
  179. Sum cell values if highligted Red (1 replies)
  180. Need Outlook mails information by Excel VBA (6 replies)
  181. Format Ranged Cells Based on Value - VBA help (7 replies)
  182. Creating several buttons from a list in runtime (7 replies)
  183. Saving textbox data from a userform to Sheet2 cells... (2 replies)
  184. Update the current Macro (3 replies)
  185. VBA module / sub / function tree (9 replies)
  186. Solved: Compare 2 spreadsheets (3 replies)
  187. Can you use match within a countifs function? (2 replies)
  188. sort range (2 replies)
  189. changing color of cells with vba (1 replies)
  190. VBA winHTTP in async mode (5 replies)
  191. Help required, identify, copy and paste using VBA (0 replies)
  192. Newbie - Simple code needed (6 replies)
  193. Solved: Data_from_another_Spreadsheet (27 replies)
  194. Solved: Ammending a Copy/Paste between two workbooks macro (5 replies)
  195. SpellNumber as per Currency Selection (8 replies)
  196. calculate a checksum (10 replies)
  197. =IF function with 2 true results and 3 false results (26 replies)
  198. removing the double names by changing the current macro (25 replies)
  199. [SOLVED:] Sorting Different Ranges on Different Columns (3 replies)
  200. Is it even possible? (12 replies)
  201. Solved: Deleting Rows (7 replies)
  202. VBA Conditional Formatting - code efficiency (4 replies)
  203. Switching worksheets in another workbook (4 replies)
  204. Solved: Can "Lock project for viewing" cause issues? (7 replies)
  205. [SOLVED:] Macro to extract url from hyperlink and populate the url in the cell below? (2 replies)
  206. Ultimate VBA protection (2 replies)
  207. Solved: Hidden Userform (7 replies)
  208. Data missing in file downloaded using URLDownloadToFile (6 replies)
  209. Capturing data from a userform to specifice column rows in a worksheet (2 replies)
  210. problem with array formula (3 replies)
  211. Creating a Timestamp (9 replies)
  212. Sum less than 999 (4 replies)
  213. Excel 2010 to OutLook 2010 Meeting Request Problems (0 replies)
  214. Help me find example files? Imaging (1 replies)
  215. Solved: Data type mismatch on Regex replace (20 replies)
  216. VBA Macro: sorting in Column A (7 replies)
  217. Copying Excel data to Word, Only executes once. (Error 462) (1 replies)
  218. Solved: Match Transpose data to a column Using VBA (6 replies)
  219. Duplicate values (1 replies)
  220. Trying to reduce execution time (4 replies)
  221. Create Break, Reset and Continue buttons in the Excel Sheet (0 replies)
  222. Solved: Macros and cell references (4 replies)
  223. Siebel (1 replies)
  224. VBA not catching error (2 replies)
  225. Sorting two Arrays Together (0 replies)
  226. VBA Help - Newbie (4 replies)
  227. error (8 replies)
  228. [SOLVED:] Copy row and insert between existing rows with relative formula kept (6 replies)
  229. label caption (5 replies)
  230. [SLEEPER:] Chart Series Selected Index (1 replies)
  231. Unable to set the FormulaArray properties of the Range Class (8 replies)
  232. [SOLVED:] I am trying to truncate cells in a column from a specific character in a string (5 replies)
  233. Create a custom calendar between two dates (1 replies)
  234. Open word files in excel (3 replies)
  235. Spinbutton value (5 replies)
  236. Solved: Insert an empty line between interval (2 replies)
  237. Display worksheet data in user form (1 replies)
  238. How to avoid pressing update button,delete button，confirm button by vba (3 replies)
  239. concatenate rows in column b for every corresponding value in column A (0 replies)
  240. Convert Data (5 replies)
  241. Solved: Find All function works Intermittantly (5 replies)
  242. Combine text from different cell in to one of them (4 replies)
  243. Macro to count and give totals (18 replies)
  244. Solved: Change textbox forecolor if date is earlier then today (1 replies)
  245. Solved: VBA Replace using regular expressions (25 replies)
  246. Help me - I'm still learning (18 replies)
  247. suppressing warnings / data connections in word (4 replies)
  248. Solved: Writing formula into cell with Macro. Inverted commas problem. (6 replies)
  249. Filter, Copy and Paste to New Tab (1 replies)
  250. Solved: Select line and send to specific fields to another worksheet (13 replies)