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. Solved: Part of macro to work from renamed file (5 replies)
  2. Solved: RibbonX - Label update (3 replies)
  3. Combining Sheets into one table from different excel files (1 replies)
  4. Remove middle characters? (1 replies)
  5. Code will protect but not unprotect (4 replies)
  6. How to use datavalidation in VBA (2 replies)
  7. Solved: verifying password in txtbox (2 replies)
  8. Help With Vba Code! Please (8 replies)
  9. Set x = CreateObject() (7 replies)
  10. Solved: Creating multiple charts formatted the same (10 replies)
  11. Complicated SUMIF situation ): (9 replies)
  12. Solved: Copy, merge and save to a new workbook (6 replies)
  13. Updating records in Access from Excel (2 replies)
  14. Solved: find/replace in protect worksheet (1 replies)
  15. Conditional Cell Location (1 replies)
  16. Activewindow Zoom (3 replies)
  17. Problem with adding OL task code (2 replies)
  18. Sleeper: Urgent Help needed.... (0 replies)
  19. Macro an Outline based on value o: (3 replies)
  20. Command button: copy and paste in next available cell on another worksheet (3 replies)
  21. copy & paste from webbrowser. (2 replies)
  22. Solved: Passing Arrays into Functions problem (8 replies)
  23. Linking worksheets (0 replies)
  24. Solved: Run macro after leaving a cell (6 replies)
  25. Solved: Program is slow (6 replies)
  26. Solved: Sum a column based on two column values (11 replies)
  27. sort and paste macro (4 replies)
  28. Solved: Last weeks date (2 replies)
  29. [SOLVED:] Insert button for upload documents (2 replies)
  30. Solved: Select from lists (1 replies)
  31. Solved: fill up cell background colour (2 replies)
  32. Change pdf name (1 replies)
  33. Solved: Workbook_beforesave saves file twice (7 replies)
  34. Solved: Column selection not working properly (5 replies)
  35. Solved: Chart Labels need to be dynamic? (7 replies)
  36. getting data from Access at specific cells of the worksheet (2 replies)
  37. Solved: Please help me compile this code (4 replies)
  38. Converting Euro Number Format using Substitute Command (1 replies)
  39. Solved: highlight entire row when click and during editing (8 replies)
  40. Solved: count the number of ";" in cell (3 replies)
  41. open as read only no save prompt (1 replies)
  42. Merge data (7 replies)
  43. Combine specific worksheets and columns with modified generic code (1 replies)
  44. use VBA to covert .xls to .xlsx (4 replies)
  45. Links updates and split workbook CSV (0 replies)
  46. data sorting macro question (1 replies)
  47. Duplicate RowLabel data range between two pivottable (3 replies)
  48. Read data from a website (1 replies)
  49. SubString help (7 replies)
  50. Find a worksheet by name (3 replies)
  51. read textfile (6 replies)
  52. Another Conundrum (8 replies)
  53. Re-arrange data based on their group (12 replies)
  54. Macro to automatically update variable ranges? (1 replies)
  55. Subscript out of Range (3 replies)
  56. get data from Access database onto Excel (1 replies)
  57. Solved: Macro to delete duplicate rows on condition (2 replies)
  58. Solved: open xlsx file with part of name (3 replies)
  59. Add two rows of text in the end of my documents (15 replies)
  60. Lock Ranges (Excel 2007) (6 replies)
  61. "shell" not work in Excel ? (4 replies)
  62. Solved: Delete Only Visible Rows in Table (6 replies)
  63. Using Office Web Components/Controls in Excel 2010 (8 replies)
  64. Verify data is the same or not (1 replies)
  65. Inserting data from excel to word files? (5 replies)
  66. Solved: RowCount (3 replies)
  67. [SOLVED:] Controls array (7 replies)
  68. Solved: Importing multiple .emf files into excel 2007 (7 replies)
  69. Check the status of the HTML form submitted using Excel (0 replies)
  70. VBA Replace (7 replies)
  71. Solved: Change font colour when string found (4 replies)
  72. Solved: Copy Multiple sheets with filtered value. (3 replies)
  73. disable cells based on time (2 replies)
  74. show formulas in Excel Vba (6 replies)
  75. Runtime Error 9: Subscript out of Range (5 replies)
  76. Sleeper: Save the workbook without Macro (2 replies)
  77. Populate cells based on dropdown selection (7 replies)
  78. Macro to create variable range sizes to be used in an averaging function (8 replies)
  79. Solved: What is the diffrence between Private Sub and just Sub in a macro (3 replies)
  80. Scraping website (0 replies)
  81. How to insert a wait timer in for loop (5 replies)
  82. macro help (4 replies)
  83. Solved: OLAP Cube issue with Excel 2010 (5 replies)
  84. Auto filter with protection on (4 replies)
  85. Export All Excel Charts as Pics to Outlook (1 replies)
  86. Solved: Inte problems under MSOffice 2010 (11 replies)
  87. Solved: automatically select 'Don't Save' if message box pop up (18 replies)
  88. disable certain cells based on a value of another cell (1 replies)
  89. Retrieve data from database onto Excel cells (1 replies)
  90. Solved: Help: Need VBA to Copy Each Autoshape Hyperlink to Another Cells (1 replies)
  91. Is this possible ? (1 replies)
  92. Open and Hyperlink in IE and Save as HTML (0 replies)
  93. Solved: Userform looping & adding 2nd record to database (4 replies)
  94. Extract values from Text files to Excel (3 replies)
  95. VBA to Access General Code (6 replies)
  96. pleace help me sort my table. (1 replies)
  97. Solved: Suggestions on Determining the max and min values of a sine wave (3 replies)
  98. Sum values (3 replies)
  99. Change comment properties XL2003 (1 replies)
  100. need to find last active row in EXcel (1 replies)
  101. Trigger code on cell input (2 replies)
  102. HELP! Need code to Update and Get new information (1 replies)
  103. Solved: VBA Help Remove first Character (9 replies)
  104. Solved: Macro showing subscript out of range (3 replies)
  105. I can't seem to get Recordsets loaded with data from SQL Server 2008 Express... (8 replies)
  106. Solved: If ... then find next cell where Len() < 2 (2 replies)
  107. [SOLVED:] Setting a cell range then hiding rows with a certain value. (1 replies)
  108. Prevent Restore Down (3 replies)
  109. [SLEEPER:] Connect to oracledb and export excel file to oracle db (0 replies)
  110. Print to Word (6 replies)
  111. How to solve my combobox bug in Excel-Vba? (7 replies)
  112. Code not working when click button is moved (2 replies)
  113. Print sheets based on filtered results from multiple workbooks (0 replies)
  114. Get Specific Cell Values from another Workbook using VBA (1 replies)
  115. For loop to fill textfields (2 replies)
  116. Passing a cell to a sub routine (4 replies)
  117. How can I write a loop to clear cells evenly spaced apart? (2 replies)
  118. Date function error (5 replies)
  119. Forecasting (4 replies)
  120. Running command button from another workbook (1 replies)
  121. How implement a summary chart for my Codes below?? (1 replies)
  122. Need to modify a User Defined Function (1 replies)
  123. multiple select combo box (1 replies)
  124. highlight the row after I input something in column a (4 replies)
  125. Solved: Change event simply not working (1 replies)
  126. Solved: MODE function to display the most common value present in a particular range of cells (2 replies)
  127. VBA Needed? Auto populate cells with hard-coded value (7 replies)
  128. TreeView, selected element and all below (0 replies)
  129. Copy two sheets (or more sheets) data into new sheet (1 replies)
  130. show a tab when a particular worksheet is activated (1 replies)
  131. Problem with code (1 replies)
  132. Solved: How to add few sheet name (5 replies)
  133. Find Method (Skipping Rows) (6 replies)
  134. Need VBA code for selecting row that meets 2 criteria (1 replies)
  135. subtract 30 minutes and round (10 replies)
  136. Extract Sheets from Workbook (1 replies)
  137. Macro to hide blank columns (disregarding header) (1 replies)
  138. Solved: Parse a string to Range (8 replies)
  139. Help me on this issue.... (2 replies)
  140. Correct NPV function (0 replies)
  141. Solved: Application.Ontime Assistance (4 replies)
  142. Solved: copy a range uniqe with out empty rows (0 replies)
  143. Find term and paste row help (4 replies)
  144. VBA Code To Click Button On Web Page (2 replies)
  145. Copy specific tab into wb (3 replies)
  146. Solved: Check if number has a asterisk (14 replies)
  147. Not able to access elements on a web page (8 replies)
  148. Help needed Run-Time Error 13: Type missmach (1 replies)
  149. Solved: Compile error: sub or function not defined (12 replies)
  150. Excel to Sharepoint (1 replies)
  151. average range of data with missing cells (4 replies)
  152. vba to cut row to different sheet (0 replies)
  153. Solved: VBYesNo Help (4 replies)
  154. Solved: Runtime error (6 replies)
  155. Importing "relevent" data from excel columns to word doc? (3 replies)
  156. Solved: Find cell with text and delete if it matches with next one (26 replies)
  157. Copying Merged & Unmerged Cells (7 replies)
  158. 'Search Engine' Help: String with 2 values (4 replies)
  159. Compatibility and VBA dropping out (2 replies)
  160. Unhiding the 1st two columns in an excel spreadsheet (1 replies)
  161. Automatically print certain pages of pdf (4 replies)
  162. Looping thru Multiple Comboboxes (3 replies)
  163. [SOLVED:] VBA needed to extract data from specific cells in different worksheet (4 replies)
  164. Extracting strings from a string (1 replies)
  165. Automatic Conditional Highlighting Column (1 replies)
  166. How to retrieve Value in Frame in user form (2 replies)
  167. Msg Box pops up many times (2 replies)
  168. Autofiltering data in several sheets and pasting to file with same name as criteria (0 replies)
  169. Exporting into XML from a sheet, and then updating an another sheet using a XML file (0 replies)
  170. There is not enough memory to complete this operation (2 replies)
  171. Solved: Need to correct this excel formula immediately (3 replies)
  172. How to use On Error (5 replies)
  173. Title and ribbon bar (3 replies)
  174. VBA Needed to populate employee data from data dump (10 replies)
  175. Sleeper: VBA Needed to extract from raw data and summarize employee data by project (7 replies)
  176. Convert Excel Geographic database to Google Earth KMZ file (5 replies)
  177. How to divide the window screen? (1 replies)
  178. VBA Code help- Paste to next empty cell in another worksheet (4 replies)
  179. Solved: Need to modify a complex formula in excel 2007 (0 replies)
  180. find the text in the cell in column A within the text in column B in the same row (3 replies)
  181. Solved: where am i going wrong? (3 replies)
  182. Solved: Insert dash in password (4 replies)
  183. Running on the web (2 replies)
  184. Dynamic charts (4 replies)
  185. Solved: Sheets vs Worksheets? (15 replies)
  186. Using Vlookup between text file & spreadsheet (2 replies)
  187. Disable passwords/unhide sheet (5 replies)
  188. Solved: vba to open web page in IE and save it (0 replies)
  189. Solved: Help with Commad bar (2 replies)
  190. oracle connectivity (7 replies)
  191. getting #N/A as value (14 replies)
  192. how to create a aktive excel table (0 replies)
  193. Solved: Help modifying excel timer (7 replies)
  194. [SOLVED:] Get Final URLS? (6 replies)
  195. Solved: copy first sheets from all work books in a file into a collective sheet (22 replies)
  196. Solved: Returning TextBox data to msgbox or cell (2 replies)
  197. How to Connect to an API (1 replies)
  198. Solved: Page Break (2 replies)
  199. Solved: VBA to calculate last month (6 replies)
  200. Insert picture in sheet + send range via email (0 replies)
  201. Solved: Creation of Folders and Sub-Folder (5 replies)
  202. Solved: Setting filters from a form (5 replies)
  203. draw arrows (4 replies)
  204. How to pick the random numbers from a set of numbers (4 replies)
  205. [SOLVED:] Start Counting when cell changes (9 replies)
  206. right-click in textbox (2 replies)
  207. Solved: Problem with cut/paste to last row of sheets (10 replies)
  208. [SOLVED:] Message Box Reminder (5 replies)
  209. Solved: Problem with declarations and Str function (6 replies)
  210. Swapping Cells (5 replies)
  211. Solved: Problem with ListBox (5 replies)
  212. Copying File issue (2 replies)
  213. [SOLVED:] Auto open file at fixed length of time (9 replies)
  214. Copy WS to a Named WS values only (8 replies)
  215. Solved: PRICING GRID (5 replies)
  216. Solved: .Find not working between Workbooks (3 replies)
  217. VBA code to import pdf as txt to Excel (2 replies)
  218. [SOLVED:] Need help in event (4 replies)
  219. Is it possible to do automation to control another application through vba code? (1 replies)
  220. find info in cells,delete cells with no info and paste to printsheet. then repeat (0 replies)
  221. FileDateTime(pathname) (1 replies)
  222. Solved: Copy deleted info (5 replies)
  223. Solved: Variable dimension of a matrix (3 replies)
  224. Using data collected in a module/ macro (3 replies)
  225. Is it possible to automate results from an access query into Excel? (16 replies)
  226. On error resume next (1 replies)
  227. Loop through all visible worksheets in excel (2 replies)
  228. read/write to textfile (2 replies)
  229. Declaring global Boolean variable? (9 replies)
  230. Comboboxes filling with for loop (3 replies)
  231. Two Columns (Search and Copy) (2 replies)
  232. SendKeyys command turns off Numlock (11 replies)
  233. Solved: variable formular depending on number of work sheets (5 replies)
  234. VBA web queries - error 1004 "The site reports that the address is not valid" (1 replies)
  235. Cannot Insert Column (7 replies)
  236. Solved: Separate generated password with dashes (2 replies)
  237. Solved: Msgbox interrupts drawing on worksheet (2 replies)
  238. Copy text from Word and paste into Excel VBA (2 replies)
  239. Solved: Re-calculating cells with unrecognized functions (3 replies)
  240. controlling cell entries (4 replies)
  241. Extract email out of changing string count (1 replies)
  242. mutliselect listbox via looping a range (2 replies)
  243. Solved: userform multiselect listbox - select item (0 replies)
  244. Make a simple report with VBA (7 replies)
  245. Automate Click, Save Close (4 replies)
  246. Delete and Move a row in excel (1 replies)
  247. Solved: Runing a macro by clicking on a sheet (2 replies)
  248. Solved: Insert Row after Specific Text (4 replies)
  249. Return Types in Excel VBA (1 replies)
  250. Solved: Not understanding Custom Icon Macro (3 replies)