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. Insert hyperlink function to active cell (2 replies)
  2. Solved: #NA Error with VLookup (5 replies)
  3. Solved: Temporarily Change BG and Font Color of Active Cell (16 replies)
  4. Solved: Macro. (2 replies)
  5. Solved: Spreadsheet Max'd Out (4 replies)
  6. Solved: count of different products (17 replies)
  7. Why would scrolling cause Application.InputBox "Cancel" behavior? (5 replies)
  8. Copy to Last Row (7 replies)
  9. Solved: Sorting Alphanumerics and Extracting numbers from them. (26 replies)
  10. Solved: Mapping search (11 replies)
  11. How to add scroll bar in userfrom (1 replies)
  12. Solved: VBA macro - conditional column fill (23 replies)
  13. Matching elements of two character arrays (3 replies)
  14. Solved: To Copy Cell in other sheets (6 replies)
  15. Sending email with lotus notes using data from excel (0 replies)
  16. Redundant code (10 replies)
  17. Making a settable clock in VBA (1 replies)
  18. VBScript and Excel Addins (2 replies)
  19. Excel VBA Change text colour depending on another cell's content (6 replies)
  20. Obtaning current date time through VBA (1 replies)
  21. Solved: Reading data-range from excel workbook (3 replies)
  22. Solved: BeforeClose event not working (1 replies)
  23. Solved: Print Preview - Detect (1 replies)
  24. Solved: Macro explain. (4 replies)
  25. Open a subfolder deeper than the first (0 replies)
  26. Problem with RecordSet and "LIKE" Operator (3 replies)
  27. How to check on open event for macro (1 replies)
  28. [SLEEPER:] Moving data on networked drives (0 replies)
  29. Weekday Conditional Formatting (12 replies)
  30. Solved: recalculate a function (3 replies)
  31. Explain Excel’s Task Bar’s Toolbar Options (3 replies)
  32. Problem with deleting files (0 replies)
  33. Sorting quetion (2 replies)
  34. Solved: Viewing Hyperlink locations (2 replies)
  35. Solved: FIND, COPY AND PASTE (6 replies)
  36. Open the Task Pane (1 replies)
  37. Solved: workaround for using PNG files (3 replies)
  38. Solved: Combining workbooks into one workbook with a part of the a filename (16 replies)
  39. ref the activecell value in an inactive sheet (3 replies)
  40. I am in way over my head Need help (33 replies)
  41. Solved: Check Group Rows For Non Mathes (2 replies)
  42. Solved: Cycle through validation list and spit out value of a specified cell (2 replies)
  43. Solved: automaticaly fill date of write (5 replies)
  44. Solved: range value (5 replies)
  45. Embedding objects Excel 2007 (4 replies)
  46. Find workbook name when macro run in add-in file (9 replies)
  47. Solved: Get length of string inside parentheses (8 replies)
  48. Manage all Hyperlinks in Workbook from new Worksheet (9 replies)
  49. Find data only specified Range ?? (9 replies)
  50. Caculating time between dates and counting if another criteria is met (1 replies)
  51. I'm trying to create a time sheet with stopwatch (16 replies)
  52. Solved: Only run code if staffnumber is equal to xxxxx (2 replies)
  53. chart help (1 replies)
  54. macro (6 replies)
  55. Turning off Autofilters & formatting (2 replies)
  56. VBA Sheet Name (5 replies)
  57. Don't exit if there was no button clicked (3 replies)
  58. Error during compile (0 replies)
  59. Urgent - Countif as an array formula problem! (2 replies)
  60. Solved: Arrays (3 replies)
  61. Solved: Help with Userform (4 replies)
  62. Prompting User to Select a Data Range (4 replies)
  63. Change button focus (6 replies)
  64. [SOLVED:] If Range Is Nothing (4 replies)
  65. Solved: Macro for Insertion of Lines between data (7 replies)
  66. XML and VBA (1 replies)
  67. Problem with Paste Picture Link (14 replies)
  68. Deselecting double clicked item in listbox (4 replies)
  69. Solved: seperating folder and filename (7 replies)
  70. Solved: xls to xlsm files. (4 replies)
  71. Excel 2007 Crashes Frequently (0 replies)
  72. custom error message box (3 replies)
  73. Turkish character issue in query from SQL server (2 replies)
  74. microsoft developer map (0 replies)
  75. Solved: Delete used rows in worksheet(sounds easy) (15 replies)
  76. Macro to find the string before special character from Right (4 replies)
  77. renaming a file (3 replies)
  78. need vba code to automatically format cell as hyperlink (1 replies)
  79. Solved: VBA summation errors in macro (24 replies)
  80. Solved: how to check if a desktop shortcut exists (1 replies)
  81. links to closed workbooks (1 replies)
  82. Excel Pivot Table Failing to Calculate an Average on a Calculated Field (4 replies)
  83. Multi Time sheet production (3 replies)
  84. Date plus hours excluding specific time interval (8 replies)
  85. Join and Count (7 replies)
  86. excel help........ (2 replies)
  87. Solved: Text File import - recognising values (2 replies)
  88. Sheet protection and tabs (1 replies)
  89. Solved: create custom menu w/ hyperlinks to open files (5 replies)
  90. Find and Compare (7 replies)
  91. Solved: Delete 0 length strings (8 replies)
  92. how to facilitate multiple users. (8 replies)
  93. returning the reference to a cell, not the value in the cell (2 replies)
  94. [SOLVED:] Games Behind Formula (12 replies)
  95. Loading XML file using VBA (3 replies)
  96. [SOLVED:] Userform ComboBox - Type Mismatch error in code (11 replies)
  97. Solved: Occurance Count (5 replies)
  98. Please help! I don't even know where to start. (9 replies)
  99. Solved: CSV To Sheets In Workbook Using ID Number (19 replies)
  100. Sleeper: Is UDF called from Wizard ? (6 replies)
  101. Conditional Formatting (3 replies)
  102. [SLEEPER:] Deleting by columns lastrow (4 replies)
  103. Simplifying code from excel to word (3 replies)
  104. Solved: Conditional Formating for weekend (3 replies)
  105. name box extender (2 replies)
  106. Simple simulation help (11 replies)
  107. Autonumber form but be able to save as file each time (6 replies)
  108. Solved: Hide custom CommandBar form Popup Menu (4 replies)
  109. Solved: Send email from excel (11 replies)
  110. Solved: some countif ...sum if help (2 replies)
  111. Solved: windows scheduler and application ontime (5 replies)
  112. Solved: Now Function - convert to General format ? (4 replies)
  113. Update report filter across multiple pivot tables (6 replies)
  114. Compare two doubles (5 replies)
  115. Not able to save add-in file under different name (2 replies)
  116. Array navigation (9 replies)
  117. Solved: Delete Rows That Total 0 (2 replies)
  118. Automated formatting (4 replies)
  119. [SOLVED:] call stack question? (4 replies)
  120. Open .csv from code (3 replies)
  121. Date Modified (4 replies)
  122. Solved: ComboBox - SetFocus ? (7 replies)
  123. NUMBERS HELP (8 replies)
  124. Solved: TIMER (7 replies)
  125. Determining the working days (6 replies)
  126. autonumber depends upon start date (5 replies)
  127. Need EASY help with a plot (9 replies)
  128. Auto width of a listbox on a userform? (6 replies)
  129. SQL using Excel VBA & passed to Access doesn't run, runs directly in Access! (1 replies)
  130. Solved: Removing items from menu bar (3 replies)
  131. Userform submit to Worsheet (Subscript out of range) (6 replies)
  132. parent window refresh (4 replies)
  133. sum by cell color (1 replies)
  134. VBA findAll Copy & Paste (12 replies)
  135. Path finder (0 replies)
  136. Solved: select (3 replies)
  137. Select Previously Edited Cell (2 replies)
  138. manipulate two sheets (10 replies)
  139. Excel VBA beginners exercise (1 replies)
  140. Looping through cells and move sheets from file in folder. (6 replies)
  141. Solved: Stopping a file from being opened (4 replies)
  142. [SOLVED:] Vba Replace Function (4 replies)
  143. Solved: macro help (4 replies)
  144. Search / Find - across sheets - find multiple instances (4 replies)
  145. Excel, Date find issue (1 replies)
  146. Solved: Retrieving comments from a worksheet (2 replies)
  147. Regular expression to find negative number (4 replies)
  148. Charting Question with Line and Scatter (4 replies)
  149. utomatically close the shared spreadsheet (0 replies)
  150. Not delete or move an excel file (9 replies)
  151. [SOLVED:] Multiple fonts in excel forms textbox (4 replies)
  152. Graduated Cell Colour in Excel 2003 (5 replies)
  153. Solved: Query within Excel to SQL server with VBA Code (4 replies)
  154. Need Help With a User Form (20 replies)
  155. macro to conditonal format and negative numbers (2 replies)
  156. Weird Add-in Error (3 replies)
  157. Dimension x number of arrays based on user input (8 replies)
  158. Solved: Code works as Sub but not as a Function! (7 replies)
  159. Solved: conditional formatting (4 replies)
  160. Solved: Count the same items in a column (12 replies)
  161. Solved: Update an excel sheet, by loading from an object (2 replies)
  162. Prevent / Disable Sort function ? (1 replies)
  163. Custom Messaging with Mouseover (0 replies)
  164. Find "Hard Coded" cells? (1 replies)
  165. Solved: TIMER SCALE IN EXCEL (3 replies)
  166. Create New Macro Using VBA (8 replies)
  167. Error in the creation of multiple PivotCharts (1 replies)
  168. Find duplicate cells in a column and contitionally delete the dupes (7 replies)
  169. Extended Conditional Formatting (1 replies)
  170. Query a sheet using SQL (3 replies)
  171. why it find only each second value (4 replies)
  172. Listbox query (1 replies)
  173. HELP WITH CONCATENATE DATA (4 replies)
  174. Solved: Msgbox if value not found (5 replies)
  175. [SOLVED:] VBA Target.value (14 replies)
  176. [SLEEPER:] Macro to Search and Replace word within another Macro (8 replies)
  177. Solved: Controls.Remove causes unexpected behavior (5 replies)
  178. move pdf files (3 replies)
  179. Solved: Create Custom Menu Macro Items in Excel VBA (4 replies)
  180. [SLEEPER:] Date on Userform (4 replies)
  181. Protect a worksheet at startup with VBA (2 replies)
  182. [SLEEPER:] 2010 excel calendar (9 replies)
  183. macro to add addtional pivot tables after the first pivot table (8 replies)
  184. Solved: Copy sheet without the vba code (3 replies)
  185. Solved: Find and replace values from separate spreadsheet (11 replies)
  186. Application-defined or object-defined error (2 replies)
  187. Function Argument Window - Can it be expanded? (2 replies)
  188. Copy to new workbook the active sheets and erase the content of the original (2 replies)
  189. Find Desktop Folder Files (2 replies)
  190. Solved: VBA colours appearing as grey for other users (7 replies)
  191. Maximum limits (15 replies)
  192. round + sumproduct help (2 replies)
  193. Solved: VBA AUTO FILTER (15 replies)
  194. Solved: Need macro for this pivot functionality? (2 replies)
  195. Solved: Dynamic Drop down based on a dynamic named range (5 replies)
  196. Solved: How to know when Webquery has finished updating (12 replies)
  197. Porting UserForm to network of users (3 replies)
  198. Error while running Macro in excell (2 replies)
  199. Bug with shortcut for macro?? (10 replies)
  200. Push Excel Named Range to Word Bookmark (2 replies)
  201. [SLEEPER:] Multiple Macros for one Workbook/sheet (3 replies)
  202. get rid of unwanted characters and send to new txt or xls file. (3 replies)
  203. Solved: Count Files in Folder (2 replies)
  204. [SLEEPER:] Create Access database on the fly & import csv/txt file as table! (6 replies)
  205. [SOLVED:] Formatting New to Excel (5 replies)
  206. Solved: Copy and paste as an object (1 replies)
  207. Run a Macro when you click on a cell (25 replies)
  208. Assist with Hyperlink in Email (0 replies)
  209. 16 Digit number output (6 replies)
  210. ListBox Help! (4 replies)
  211. Stop running macro after specific time (1 replies)
  212. multipage search - duplicate entries (1 replies)
  213. [SOLVED:] Help with formula please (3 replies)
  214. Solved: product begins with XY (8 replies)
  215. Solved: auto number (8 replies)
  216. Solved: Floating a textbox over an excel worksheet (2 replies)
  217. Solved: VLOOKUP question (5 replies)
  218. counting (4 replies)
  219. Solved: Searching in multiple workbooks (3 replies)
  220. ATPVBAEN.XLA . . . One More Time (2 replies)
  221. Changing worksheet issues (1 replies)
  222. Save Progress Bar Not Displayed (7 replies)
  223. Write a string of text to all HTM files (1 replies)
  224. [SOLVED:] Shortwrite (2 replies)
  225. VBA: Copy chart from excel to word (1 replies)
  226. search for word (4 replies)
  227. Solved: delete leter (8 replies)
  228. Solved: Need to include Scientific Labels to a Form (2 replies)
  229. [SOLVED:] How to use DataBodyRange property to write to a specific sheet? (4 replies)
  230. Solved: letter index (18 replies)
  231. Simultaneous Entry (9 replies)
  232. Get information from a .MDB file (3 replies)
  233. Fetching data from the web (3 replies)
  234. Solved: Pick up peak(maximum) value in running data (5 replies)
  235. Run macro IF (4 replies)
  236. Counting date cells (16 replies)
  237. Select and name a Range (2 replies)
  238. SOLVEROK (3 replies)
  239. Combobox items (8 replies)
  240. vb script to copy selection (2 replies)
  241. msgbox more than 1024 chars (3 replies)
  242. Setting Sheet Visible Error (2 replies)
  243. VBA to Find and compare data from multiple columns (5 replies)
  244. MISSING: Ref Edit Control (3 replies)
  245. Solved: update opened read-only wb (1 replies)
  246. VBA which finds data in one sheet & return list with all relevant data in new sheet (3 replies)
  247. Not able to click a button on a webpage (0 replies)
  248. Solved: TRIM STRING (7 replies)
  249. Solved: Data Validation help (6 replies)
  250. Excel 2007/2003 files access (3 replies)