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. Tool to clean up VBA code (5 replies)
  2. Solved: make workbook close if in use by other user (7 replies)
  3. MS Excel Macros to Update Spreadsheet automatically (0 replies)
  4. Defining Ranges Using VBA (1 replies)
  5. Solved: Ranges are the Worst... (5 replies)
  6. Solved: Code Not Cycling Workbook (6 replies)
  7. Dynamically Update Defined Names Range (12 replies)
  8. Solved: Creating an Array via a Range (10 replies)
  9. Solved: Pivot table column totals (4 replies)
  10. Solved: Pivot help (2 replies)
  11. Macro to email file location (1 replies)
  12. VBA code that sums column "C" in all active worksheets (3 replies)
  13. Solved: Userform Text Field Format (4 replies)
  14. application.hide and opened file by two users (2 replies)
  15. Getting a handle on internet explorer instance (3 replies)
  16. VBA Shared workbook (12 replies)
  17. Solved: VBA indenter (6 replies)
  18. Issue with custom Menu - how to have it only in one Excel file? (3 replies)
  19. Solved: Find N, Insert N and Shift down (4 replies)
  20. Save WordDocument as PDF using Excel 2010 (9 replies)
  21. Solved: Create pdf attachment from Url in cell and send via Outlook (3 replies)
  22. Email validation in vba (0 replies)
  23. How to populate an array with results? (16 replies)
  24. Target prices (8 replies)
  25. Macro to group rows (0 replies)
  26. Solved: Copy & Paste in same cell (2 replies)
  27. Help Creating a Macro (6 replies)
  28. Could not change the cell color using VBA (0 replies)
  29. Solved: Show top ten closest match amount (2 replies)
  30. Solved: Selection Caps Locks (3 replies)
  31. [SOLVED:] Check if File Is Open (4 replies)
  32. Auto Extracting Recording From RTF to EXCEL using VBA (1 replies)
  33. Selection Printing either Landscape or Portrait (0 replies)
  34. Auto deletion of worksheets based on multiple criteria, and automatically returning v (1 replies)
  35. Help with web adresses and vba (0 replies)
  36. Solved: Text to Columns (7 replies)
  37. Unable to access the link for the Add-in (11 replies)
  38. Solved: search for words in all caps in Excel (11 replies)
  39. Solved: Spinner Button (14 replies)
  40. Solved: VBA to convet to IF(ISERROR formula (4 replies)
  41. Get data from closed workbook (4 replies)
  42. Sum Base % (1 replies)
  43. Solved: Using Index and Match with Dates (1 replies)
  44. Need way to invoke macro at a different workbook the current (2 replies)
  45. More efficient code for copy/paste between workbooks (2 replies)
  46. [SOLVED:] Import data from closed WB to textbox in userform (6 replies)
  47. [SOLVED:] Expand 2 Columns to Multiple Columns with unique ID Rows (1 replies)
  48. copy values to another worksheet in next down cell (3 replies)
  49. [SOLVED:] Searching and Copying (4 replies)
  50. [SOLVED:] Move selected columns data from UserForms listbox to different ranges in Worksheet (3 replies)
  51. accepting and storing a user/password temporarily? (1 replies)
  52. I need help with creating a Macro!! (4 replies)
  53. Adjusting MyPath Variant to point to specific folder (1 replies)
  54. open workbook - check date and percentage - send email (2 replies)
  55. Solved: AutoRefresh 5-7 Pivots within a Workbook. (17 replies)
  56. dynamic chart in excel, size changes - desperate for help please! (0 replies)
  57. Autofill column to last row (3 replies)
  58. Complicated Charting Issue (0 replies)
  59. Solved: Move from first sheet to first sheet +1 (3 replies)
  60. Combining Multiple Workbooks only grab 1st sheet (0 replies)
  61. Expert Needed Macro Assist (1 replies)
  62. Solved: Resizing a range based on matching values. (11 replies)
  63. [SOLVED:] Get Column Letters (Excel 2010) (6 replies)
  64. Read/Export table from Outlook mail body to Excel using VBA (0 replies)
  65. How to average a column in vba? (0 replies)
  66. Retrieve highest number from an array (3 replies)
  67. help needed for column retrieval from various sheets. (2 replies)
  68. Compare Dates and Clear Cell Contents (2 replies)
  69. trouble with modestly large integers (1 replies)
  70. Excel VBA Chart.Axes(xlValue).MajorUnit (4 replies)
  71. Sometimes Simpler is better (2 replies)
  72. Unique List and tally from Rows (1 replies)
  73. Solved: VBA code to turn the formula into value (7 replies)
  74. Copy rows to 2 sheets using criteria (1 replies)
  75. Incremental number for saved files (19 replies)
  76. Solved: Sorting Issues. (1 replies)
  77. Solved: Loading and unloading forms (3 replies)
  78. Delete sheets with execption (7 replies)
  79. [SOLVED:] Application hanging for apparently no good reason (10 replies)
  80. hide/unhide textbox (1 replies)
  81. conditional formatting help (4 replies)
  82. Solved: Edit Cells finding the last row (3 replies)
  83. Automation Error Run-time error '-2147217871 (80040e31)' (7 replies)
  84. Find N, leave blank and move down (2 replies)
  85. Copying results from dropdown to separate sheets (3 replies)
  86. Solved: Looping through a two dimensional array, displaying element values, having problems (5 replies)
  87. vba code moving data of row from one sheet to another & vice versa (3 replies)
  88. Deduct Partial Vacation Hours Taken from a Date or Date Range (4 replies)
  89. Automate logon to intranet sites (1 replies)
  90. Copying values from one column and inserting below the values of another (1 replies)
  91. Getting Trendline formulae - results OK when stepping thru code, missing when running (1 replies)
  92. Solved: Sumproduct and Countif error if there is a blank cell (2 replies)
  93. Reference cell that has the fax number (4 replies)
  94. Solved: Conditional Format help (4 replies)
  95. Solved: Error on code to copy from excel and paste to word (6 replies)
  96. Hyperlink file based on cell text (9 replies)
  97. Solved: Userform to Spreadsheet help (2 replies)
  98. un joining text in cells (9 replies)
  99. Solved: Help with conditional formatting (7 replies)
  100. Copy and Paste Values at 1 min intervals (11 replies)
  101. Solved: check duplicate data in different worksheets (3 replies)
  102. CopyFromRecordset Decimal Values are copied as much longer decimals values (4 replies)
  103. paste cell offset to right??? (2 replies)
  104. Putting temporary data in a Combobox (1 replies)
  105. Helper column (2 replies)
  106. Calculations using excel vba (6 replies)
  107. Solved: Custom Text Format (4 replies)
  108. Worksheet change copy row &paste above macro (5 replies)
  109. Solved: Generalize code (3 replies)
  110. Passing values between userforms on different workbooks (20 replies)
  111. Solved: Opening And Printing A Word Document (8 replies)
  112. Solved: Selecting Cells (2 replies)
  113. create a permission on FIREWALL (2 replies)
  114. [SOLVED:] copy and paste in certain location in word (3 replies)
  115. Position cursor (5 replies)
  116. Only once error 91 (14 replies)
  117. Solved: How to read Excel or Word file (multi-word phrases) into Array (2 replies)
  118. Solved: Switching between Userforms (5 replies)
  119. VBA Code For Web Login Not Working (1 replies)
  120. Looping through dim'ed objects - can it be done? (2 replies)
  121. Merging Macros (8 replies)
  122. how to save a backup file (5 replies)
  123. Consolidate Workbooks Into Summary Sheet (6 replies)
  124. Create report from data (1 replies)
  125. Solved: how can i make this arry work (10 replies)
  126. Scrolling through a list box with a mouse wheel (6 replies)
  127. Solved: Error 1004 when copying and pasting with multiple sheets selected (2 replies)
  128. Solved: Track Cell Changes (1 replies)
  129. VBA copy template worksheet to multiple new worksheets based on a range (2 replies)
  130. A simple code to move data with a Button (6 replies)
  131. date display (1 replies)
  132. Retrieving Computer object information from AD (1 replies)
  133. Macro help - highlight dupe cells (2 replies)
  134. [SOLVED:] Adding a value to the first instance of duplicate values in a column (2 replies)
  135. Compare two columns values with another two columns of same sheet (3 replies)
  136. Solved: task scheduler to run vbs script (10 replies)
  137. Solved: Merge two codes (10 replies)
  138. Call a function in another Excel 2010 AddIn (.xlam) (4 replies)
  139. [SOLVED:] Refresh listbox (7 replies)
  140. Pasting from Excel to word (10 replies)
  141. Solved: Update summery cells using indirect function (1 replies)
  142. Solved: splitting a part of text into another column after last space (6 replies)
  143. VBA run-time error 438 (3 replies)
  144. Solved: prevent errors with multiple user input simultaniously. (16 replies)
  145. Passing variables to a specified control (9 replies)
  146. How to Disable the ... (1 replies)
  147. How to solve this security alert message? (3 replies)
  148. Copy to another sheet with find variable range (5 replies)
  149. Solved: VBA Excel Close Non Active File (11 replies)
  150. Referencing a closed external workbook - VBA (1 replies)
  151. Solved: Range object acting up in 2007 (7 replies)
  152. Solved: Match 2 fields and paste 2 values (3 replies)
  153. Solved: VLookup In VBA (2 replies)
  154. ADODB.Connection : Sourcefile + if condition = error (2 replies)
  155. How to use READYSTATE_COMPLETE (3 replies)
  156. Solved: Search for Values and copy certain columns to different worksheet (37 replies)
  157. Solved: Data picker and commandbuttons control (3 replies)
  158. Import text from word document into excel (4 replies)
  159. Keeping a userform on top of another when using taskbar button. (13 replies)
  160. Copying files from FromPath to ToPath VBA Code inclduing sub directories (37 replies)
  161. Solved: List box value from an active cell. (15 replies)
  162. Solved: change printer setting (5 replies)
  163. Color background detection in a cell (2 replies)
  164. Calculating Endtime/Duration (6 replies)
  165. Solved: Extra Series ("File") in Chart with VBA Code (2 replies)
  166. Printing dates (0 replies)
  167. Code to move data forward and back, using a checkbox (18 replies)
  168. A Custom UI code to do ... (13 replies)
  169. Get data without opening Excel? (3 replies)
  170. Solved: How to create a macro to unprotect the sheet? (2 replies)
  171. VBA code to copy files from one location to another based off of creation date (7 replies)
  172. Solved: Please Help" Create auto hyperlink folders" (2 replies)
  173. Dropdown List from Table w/o Duplicates (NON VBA) (3 replies)
  174. copying text that exceeds the width of the page to the line below (16 replies)
  175. CC more than one person on email (2 replies)
  176. Solved: determine how long user was on a sheet (3 replies)
  177. Application-defined or object-defined error (2 replies)
  178. 8192 areas error message (3 replies)
  179. Solved: How to Hide the Sheets Bar in a excel File? (3 replies)
  180. Renaming excel sheet in specific format (0 replies)
  181. Updating from 1997 to 2007... (1 replies)
  182. Method 'Range' of object '_Worksheet' failed (2 replies)
  183. Solved: replacement for Application.FileSearch (11 replies)
  184. round function in excel (2 replies)
  185. I need code automatically copy and paste (2 replies)
  186. Solved: Please Help me to create a macro! (1 replies)
  187. Remove duplicates, but keep the first one (17 replies)
  188. Need to show progress bar while executing the macro (1 replies)
  189. Solved: Print PDF Range (2 replies)
  190. Solved: Not important, error with the ISBLANK function (4 replies)
  191. Excel/AutoCAD Assistance Needed! (2 replies)
  192. Word Table formatting from excel vba (3 replies)
  193. Solved: Include decimals in a number range (4 replies)
  194. extract data from pivotfield not working (1 replies)
  195. Transparent UserForm With Visual Controls (7 replies)
  196. Solved: Custom Class - Property Set Question (3 replies)
  197. Solved: Move Data Row To Fill Empty Row (1 replies)
  198. Solved: Date calculation in VBA (2 replies)
  199. Assistance required with Excel Userforms (VBA) (2 replies)
  200. Solved: Pivot Table (7 replies)
  201. Solved: Change Cell Fill Colour (2 replies)
  202. Solved: New Workbook menu (4 replies)
  203. Solved: Listbox control and extract data (2 replies)
  204. Input 2nd line in text file (2 replies)
  205. Saving date in CSV file (2 replies)
  206. Solved: Target.Offset Function (11 replies)
  207. VBA Macro Help (1 replies)
  208. Interact with file dialog box opened in webpage (0 replies)
  209. [SOLVED:] Value from embedded ListBox - OLEObject (8 replies)
  210. change color of cells from Access (1 replies)
  211. Solved: add a word to the row have a data (8 replies)
  212. Pull Data off the Web (2 replies)
  213. IF statement not working probably (2 replies)
  214. Solved: Open & Print PDF (9 replies)
  215. Convert text file to excel and compare with actual result (0 replies)
  216. Solved: If Statement Insanity (2 replies)
  217. Solved: Late binding (8 replies)
  218. First time using VLookup (7 replies)
  219. Solved: Remove spaces from the beginning and end of a cell (3 replies)
  220. Countdown Timer on Userform (1 replies)
  221. Delete the incorrect used range after the last row of data. (2 replies)
  222. Time calculation with Excel (3 replies)
  223. Insertion and Deletion of rows in a Protected excel sheet (7 replies)
  224. Solved: Running an application at each blank row. (3 replies)
  225. Solved: Open website by excel vba (3 replies)
  226. Solved: Autopopulate Cell With Default List Value (12 replies)
  227. Solved: Printing to a Single Job with Dynamic Print Ranges (7 replies)
  228. match within countif ... (1 replies)
  229. Print Text From vbYes/No Message Box Using Default Printer (3 replies)
  230. Solved: select last 5 rows (3 replies)
  231. How do you create this logic? (8 replies)
  232. Solved: Using image URL to pull image into specific cell - excel 2007 (18 replies)
  233. Save certain Worksheets to a NEW/BLANK Workbook Via the Browse to file window in VBA (5 replies)
  234. Macro to generate multiple documents and send specific ones to specific emails (1 replies)
  235. Using excel find and replace (3 replies)
  236. What is your answer about this Question! (12 replies)
  237. Solved: Getting 1004 error for below code (15 replies)
  238. Excel: to populate date properly under a month (5 replies)
  239. Solved: delete rows (2 replies)
  240. Parsing a text file (7 replies)
  241. Pivot Table Help! (5 replies)
  242. vba insert multiple columns after each existing column (3 replies)
  243. capture Windows user name and login/logoff date time (4 replies)
  244. How to speed up VBA? (3 replies)
  245. autofill rows according to the integer in another cell. (1 replies)
  246. Splitting a list of numbers? (3 replies)
  247. create line diagram (1 replies)
  248. Problem initializing userform (6 replies)
  249. Solved: Code delete .pdf file don't work (11 replies)
  250. Solved: Please help me in this VBA Code to edit (2 replies)