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. COPY FROM CELL (4 replies)
  2. Solved: Automating a Macro (16 replies)
  3. Downloading attachment from a specific user's email to hard disk, deleting the mail (2 replies)
  4. Code Stopped Working..sort of... (12 replies)
  5. Filtered Mode Copying and pasting as value yield as error? (1 replies)
  6. Extracting A Substring (4 replies)
  7. Solved: Get data from web page and paste to excel (21 replies)
  8. Downloading a non-excel file from server through Excel (0 replies)
  9. Solved: XLAM file replacement (7 replies)
  10. Complex Number Matrix Multiplication (2 replies)
  11. Solved: uncalled for msg (2 replies)
  12. Solved: Give result for duplications (2 replies)
  13. Solved: search help (6 replies)
  14. [SOLVED:] Entering Negative numbers (1 replies)
  15. Solved: Hiding Unused Rows (3 replies)
  16. Solved: need space in titled saveas (4 replies)
  17. Finding data range reference for a series in chart using vba (7 replies)
  18. [SOLVED:] Problem with Range using Auto Filter (8 replies)
  19. Select & drag all fields to Data area in Pivot in one key stroke (8 replies)
  20. Solved: Setting Paramaters for Builtin Dialogs (11 replies)
  21. VBA to copy/paste etc.. (6 replies)
  22. Solved By Xld Hit A Snag (14 replies)
  23. Solved: Row reference through selection in custom Function (8 replies)
  24. Autofilter function 2003 vs 2007 (1 replies)
  25. Solved: vba dir() need sorting by filename (1 replies)
  26. Solved: Move Row by Row in a listbox??? (2 replies)
  27. Solved: Adding Calculation code (9 replies)
  28. Solved: Excel VBA Sort with user Input (8 replies)
  29. Solved: Bottom controlled Do While loop (4 replies)
  30. Solved: Company Name and Full URL Separation (3 replies)
  31. [SOLVED:] Using Sumproduct to Calculate Weekly Totals (9 replies)
  32. Paste/Special/Values (3 replies)
  33. Solved: Combine worksheets - Specifying one sheet name from multiple workbooks to combine (12 replies)
  34. VBA to Filter Excel Data to a Different Sheet (2 replies)
  35. Solved: moving files greater than 1mg (4 replies)
  36. Solved: Resize a Cell thru Macro (2 replies)
  37. Solved: Refresh Pricing Data --> Date (6 replies)
  38. Solved: Code for not found (11 replies)
  39. Automatically updating pivot tables (2 replies)
  40. [SOLVED:] Save a Worksheet using VBA with more then 255 Characters (6 replies)
  41. Copy many workbooks into one master Workbook (5 replies)
  42. Solved: Converting FY formula into a VBA (5 replies)
  43. Solved: Disable UserForm OK icon until a selection has been made (3 replies)
  44. Foreign version of excel (1 replies)
  45. [SOLVED:] Export excel rows to doc (7 replies)
  46. stopwatch in Excel (2 replies)
  47. letters help (1 replies)
  48. How to count days between Months? (1 replies)
  49. Conditional Formatting of cells (5 replies)
  50. Total Months in Between Two Dates (4 replies)
  51. Solved: Form Help (3 replies)
  52. Solved: Code Runs on Excel 2000 but not on Excel 2002 (3 replies)
  53. macro help (3 replies)
  54. Delete rows with blank cells, do not check column A (3 replies)
  55. Solved: OpenText Method and Find Replace Syntax (10 replies)
  56. COPY DATA (9 replies)
  57. [SOLVED:] Insert blank rows automatically - based on cell value (4 replies)
  58. Solved: Conditional Format for percentage (2 replies)
  59. timer code (2 replies)
  60. Import multiple photos into excel (0 replies)
  61. error 1004 (5 replies)
  62. Solved: Copy row down based on last row of different sheet (4 replies)
  63. Adding numerous named ranges (4 replies)
  64. Compile Error Variable not Defined (2 replies)
  65. Disable Drag & Drop/Cut & Paste on worksheet (1 replies)
  66. [SOLVED:] Option Buttons in UserForm (3 replies)
  67. Solved: Userform checkbox active checkbox in sheet (3 replies)
  68. Error creating PP slide from Excel within IE (0 replies)
  69. Solved: Arrays of Array (7 replies)
  70. Solved: Generate Email BCC from Column of Email Addresses (19 replies)
  71. VBA Code: Reorganise data (1 replies)
  72. Solved: Multi line Msgbox (5 replies)
  73. copy cell without range (2 replies)
  74. Sleeper: Data entry validations (0 replies)
  75. dynamic search content (2 replies)
  76. find code & select multiple lines (2 replies)
  77. Transferring data from a closed workbook (1 replies)
  78. Solved: Testing entries in a text box (5 replies)
  79. unreadable content (1 replies)
  80. Get the name of the workbook on a different workbook (0 replies)
  81. How to stop screen flashing (2 replies)
  82. pull data from multiple workbooks....cell vs range (3 replies)
  83. Match up data (12 replies)
  84. Pivot table code (3 replies)
  85. OPEN a file,COPY a range and PASTE it (5 replies)
  86. Solved: Need to auto-populate a Status Indicator (2 replies)
  87. Solved: VLOOKUP Problem (9 replies)
  88. Solved: I need a "MATCH" help (2 replies)
  89. [SOLVED:] Handle to ribbon controls (4 replies)
  90. Filling an excel range from a vb function (7 replies)
  91. [SOLVED:] Name not getting captured in 2 input userform (12 replies)
  92. Solved: Enter date in a cell (4 replies)
  93. Solved: Replacing Special Characters & Symbols (10 replies)
  94. Userform textbox and calendar formula (2 replies)
  95. Need help to solve this critical scenario (9 replies)
  96. Accessing Worksheets (4 replies)
  97. List selection in pivot table report filter (2 replies)
  98. An impossible search and paste?Maybe not (6 replies)
  99. Solved: Help with VBA & html spidering/downloading! (5 replies)
  100. Solved: Save outlook message in Excel (2 replies)
  101. Sort in a Shared Workbook (1 replies)
  102. Solved: Automatically Populate dropdown for each new worksheet created (9 replies)
  103. Solved: VBA timer trouble (9 replies)
  104. [SLEEPER:] Object Required Error (5 replies)
  105. VB date error and transitioning to Case (2 replies)
  106. Solved: Find by phrase (22 replies)
  107. Conditional drop down lists (2 replies)
  108. Solved: excel help - adding checkboxes to sheet (6 replies)
  109. Need Listbox to be stored. (1 replies)
  110. column (3 replies)
  111. AVERAGE PROBLEM (3 replies)
  112. How do I take an output of a macro and place it into a single cell (3 replies)
  113. Solved: Need Help With Methodology (7 replies)
  114. Error message (11 replies)
  115. Disabling Toolbars in 2003 (2 replies)
  116. Activating mouse scroll wheel in listbox (7 replies)
  117. Cascading combo boxes from SQL Server (3 replies)
  118. Micro for TAT (9 replies)
  119. Solved: OPEN FILE (10 replies)
  120. Solved: How do I export my xls correctly? (2 replies)
  121. Excel file close (4 replies)
  122. Solved: Custom Array function for calculating variance (5 replies)
  123. Run-Time Error 3704 with ADO & SQL (1 replies)
  124. MAX and MIM problem in Arrays (1 replies)
  125. Solved: Using Variables in Named Ranges (7 replies)
  126. VBA Create Charts (0 replies)
  127. Solved: wildcard use with xlSheetVeryHidden ? (2 replies)
  128. Solved: Sorting using range names (4 replies)
  129. VBA - GOTO named range (1 replies)
  130. How do i Configure the I.E within Excel (2 replies)
  131. Solved: VBA Subscript out of range errors on sheet code (3 replies)
  132. Creating conditional lists using VBA (2 replies)
  133. Wrap text in text box (4 replies)
  134. time format display (3 replies)
  135. Solved: Delete select columns (2 replies)
  136. Manipulating Shapes in VBA (7 replies)
  137. Solved: BeforeClose not firing on hidden personal.xls (7 replies)
  138. Solved: date conversion macro (7 replies)
  139. Solved: How to answer the msg box automatically? (6 replies)
  140. Solved: Prevent save as .xlsx (8 replies)
  141. Solved: MIN formula (7 replies)
  142. [SOLVED:] Using msoFileDialogFilePicker (8 replies)
  143. Password Protected drives (1 replies)
  144. Change Application width of active worksheet focus (2 replies)
  145. simple loop macro (3 replies)
  146. [SLEEPER:] Excel data Connections to pull data (0 replies)
  147. Solved: LOOKUP, But Exact match (8 replies)
  148. Need help with a Formula Creation (1 replies)
  149. Solved: Populate listbox based on folder contents (3 replies)
  150. Solved: Macro To Loop through a column in the workbook (4 replies)
  151. Solved: Open 1st workbook from userform in workbook 2 (11 replies)
  152. Solved: Sort - convert code to work on 2003 ? (2 replies)
  153. Formula Error Message in Excel 2007 Sheet (6 replies)
  154. Solved: Select Specific Cell Range (2 replies)
  155. [SOLVED:] Delete Rows based on Multiple Cell Criteria (8 replies)
  156. [SLEEPER:] get data from other excel files dynamically (6 replies)
  157. Solved: Shell command to open pdf file in Acrobat 8.0 (3 replies)
  158. Hyperlink Error - Need Help! (2 replies)
  159. Excel screen stretching (4 replies)
  160. Solved: Difference between two times - Macro (4 replies)
  161. Writing the character " into Cell (4 replies)
  162. Dynamicalyy set range depending on the populated cells (4 replies)
  163. delete value (4 replies)
  164. cells value (2 replies)
  165. Solved: Set Range depending on font colour (7 replies)
  166. [SLEEPER:] Unable to Assign a Macro to a "Shape" in Excel 2007 (3 replies)
  167. Solved: Some sheets no hyperlinks. (7 replies)
  168. Change Font Within Formula (4 replies)
  169. Solved: vb "Upper" (2 replies)
  170. Calendar Control 12.0 enquiry (3 replies)
  171. Solved: Personal.xls not loading - usual solutions not working (8 replies)
  172. Monthly repayments (10 replies)
  173. Extracting a specific part from a string (5 replies)
  174. OLEObjects.Add and Worksheet_Change event (2 replies)
  175. Data Validation Question (17 replies)
  176. Moving cells from 1 line to another (5 replies)
  177. Browse Folder (16 replies)
  178. Solved: Cell value from cell in different sheet (2 replies)
  179. Solved: Duplicate Data Concatenating (10 replies)
  180. DoEvents ActiveWorkbook.RefreshAll Run second part of Macro Once Complete (4 replies)
  181. Conditional Formatting in VBA (9 replies)
  182. Tough one (7 replies)
  183. Solved: Variables in String Issue (12 replies)
  184. [SOLVED:] Macro Error (5 replies)
  185. I have a dynamic SUM function problem (1 replies)
  186. Check if a value is in an array (4 replies)
  187. Solved: % problems (3 replies)
  188. Drop down on every cell in column (10 replies)
  189. How to submit a web form without a name? (0 replies)
  190. Finds row count, but only 99% of the time (3 replies)
  191. Solved: Resources - Download (4 replies)
  192. scrolling through each entry (3 replies)
  193. Conditional Subtotal Help (1 replies)
  194. [SLEEPER:] Systematic access of files within directory (9 replies)
  195. Solved: Help with code to fill in emply code in worksheet (2 replies)
  196. Solved: Modifying workbook links (7 replies)
  197. Solved: Save worksheet as new workbook, with macros disabled (3 replies)
  198. Userform from hidden worksheet (6 replies)
  199. Clear Cell Value before re-running the VBA (4 replies)
  200. How to save intermediate values in a VBA code execution? (1 replies)
  201. Conditional Format based on two column criteria (3 replies)
  202. Solved: Excel 2003 Userform not posting until its closed (17 replies)
  203. Solved: What type of control do I need? (2 replies)
  204. [SLEEPER:] For..Next Loop with problem (6 replies)
  205. Solved: Why It doesn't find all hyperlinks? (7 replies)
  206. Solved: Adding Customers to my project (5 replies)
  207. Filters not applying in VBA code (2 replies)
  208. Problem in displaying a progress bar (2 replies)
  209. EXCEL VBA HELP SENDMAIL (1 replies)
  210. VBA Recalculation? (7 replies)
  211. [SOLVED:] Using SumIf with a Date Range as the Criteria (11 replies)
  212. Solved: Split string into two columns (2 replies)
  213. Solved: put current date in a column if any change in row (10 replies)
  214. Can not get data to change when I format the cells (12 replies)
  215. [SOLVED:] Filtering data up to a predetermined cumulative total (9 replies)
  216. Solved: Update Links window appears, why? (1 replies)
  217. How can one unlock a VBA project (and it's modules) using vba (6 replies)
  218. view two different sheets in same workbook (2 replies)
  219. Solved: Conditional drop-down lists (2 replies)
  220. Solved: Find the min or Max value in an autofiltered range (3 replies)
  221. Solved: VBA code to copy range to another specific range (4 replies)
  222. [SOLVED:] Formula to extract Lotus Notes username (6 replies)
  223. Solved: Subfolders (5 replies)
  224. Loop row deletion code through multiple sheets (7 replies)
  225. copying trough lock cells (18 replies)
  226. How to Change the Axis Numbers Color on a Chart (6 replies)
  227. Is this a solution for sumproduct? (8 replies)
  228. Creating new tabs (12 replies)
  229. Force Save to specific Folder (4 replies)
  230. [SLEEPER:] Emailing multiple attachments from Excel (2 replies)
  231. test file name (1 replies)
  232. Solved: Change Password - Multiple Files+Common Password (6 replies)
  233. Solved: Keep form on top while keeping full excel functionality (3 replies)
  234. Macro to save as filename and sheet name (7 replies)
  235. add a # of hours to a time? (12 replies)
  236. Solved: String into Array (4 replies)
  237. Solved: Select columns to copy (9 replies)
  238. Solved: Error 1004 Bad Range definition? (4 replies)
  239. Expiry Date Validations (15 replies)
  240. Solved: Chart formatting with VBA (2 replies)
  241. Runtime Error 1004 (1 replies)
  242. Solved: highlighting a row in excel if selected (6 replies)
  243. Solved: Set focus on a control (4 replies)
  244. Solved: hightlight highest time (6 replies)
  245. Solved: That Pesky #REF Error (5 replies)
  246. copy column (1 replies)
  247. How to Detect If .csv file Is Open in Win 7 (2 replies)
  248. [SLEEPER:] Find a value in a text file and remove the entire line (1 replies)
  249. Generate PDF file (1 replies)
  250. Do Loop help (1 replies)