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. Method Range of Object Workbook failed (8 replies)
  2. Solved: Disable any changes to tha value in the cell. (8 replies)
  3. Solved: MsgBox Loop Help (4 replies)
  4. Solved: Popup messages when clicking on a tab (3 replies)
  5. Solved: How to find (match) 3 criteria on a row? (7 replies)
  6. Solved: Custom button only works with specificied sheet (4 replies)
  7. Solved: ActiveCell Property Question (5 replies)
  8. Save Table as .mdb (2 replies)
  9. Solved: Timer based messages (3 replies)
  10. Solved: Time format in Statusbar (2 replies)
  11. Compile error in hidden module: ThisWorkbook (9 replies)
  12. Solved: Help: How to set a column Value become Key Index (4 replies)
  13. VBA Find based on cell value (4 replies)
  14. List files in a folder and open using correct app (2 replies)
  15. Do loop search (4 replies)
  16. Solved: Bringing a selected cell to the top of the screen (4 replies)
  17. Excel for MAC crashes (8 replies)
  18. Solved: Capturing Flag status of mail in Execl from Outlook (2 replies)
  19. Finding exact matches only (8 replies)
  20. Openning a workbook while a userform is running (4 replies)
  21. link a user interface to another user interface (3 replies)
  22. Auto Update/Sort (1 replies)
  23. Solved: Another delete rows query (5 replies)
  24. Solved: How to use Excel Functions from VBA. (3 replies)
  25. VBA macro to write from text file to excel (3 replies)
  26. [SLEEPER:] Sorting without absolute cell referenes (1 replies)
  27. [SOLVED:] Asking user to please enter all mandatory filed (16 replies)
  28. Solved: Removing and pasting rows using a collection? (6 replies)
  29. show numbers not used (5 replies)
  30. Removing special characters from text entered in a cell (9 replies)
  31. file transfer from one folder to another. (19 replies)
  32. PDF to Excel (1 replies)
  33. Print Without Background Fill Color (3 replies)
  34. Using number of digits before "-" to determine whether number is type A or type B? (2 replies)
  35. [SOLVED:] number pad key id? (36 replies)
  36. ForcePasteSpecial - Error 2147467259 (0 replies)
  37. AllowFormattingCells:= (4 replies)
  38. Custom Toolbars 4 Multiple Users (14 replies)
  39. [SOLVED:] Userform - textbox data (1 replies)
  40. Is there a way to Paste text into a Merged Excel Cell, from an outside file? (4 replies)
  41. Copying data from Multiple workbooks and combining in one sheet (4 replies)
  42. Change workbook reference to variable (3 replies)
  43. averaging 1 column depending on another (7 replies)
  44. Solved: Moving a worksheet (6 replies)
  45. Solved: Using VLOOKUP in VBA Code (2 replies)
  46. How to update value to a textbox according to loop-index (7 replies)
  47. Copy and paste to specific Worksheets (3 replies)
  48. Solved: Array formula to extract multiple values (6 replies)
  49. Need Help With User Form (3 replies)
  50. Search the value in the column. (11 replies)
  51. How to identify two instances of same exe? (8 replies)
  52. Attach Files (2 replies)
  53. Changes in Excel 2007 (8 replies)
  54. 2 Dimensions of a table (2 replies)
  55. Solved: Subtracting dates/times to show number of hours? (2 replies)
  56. help with a price list demo (2 replies)
  57. Adding item in listbox 1 (5 replies)
  58. How to make many protection properties on Ranges when I protect my Sheet? (2 replies)
  59. Update links when file names are different each time.... (6 replies)
  60. Web Browser Control - turn off error warnings (2 replies)
  61. Adding item in listbox (9 replies)
  62. Printing each page from a multipage object (4 replies)
  63. Solved: Trying to create a summary sheet (12 replies)
  64. Solved: sort multiple rows (7 replies)
  65. Plot charts with data position unfixed (4 replies)
  66. Paste into every sheet but first (1 replies)
  67. Dir function (3 replies)
  68. Add some .avi files in a ListBox (1 replies)
  69. Transferring Data from 2 columns to another sheet using For Next loop (4 replies)
  70. Solved: stopping users deleting sheets (13 replies)
  71. "Format" menu is not visible. (11 replies)
  72. [SOLVED:] How to change the shape of Command Button ? (8 replies)
  73. Need Excel macro (10 replies)
  74. Spreadsheet in user form (3 replies)
  75. Import 2 different text files and compare (2 replies)
  76. How do I set up a session timeout in Excel? (5 replies)
  77. Solved: get cell data into textbox on userform (6 replies)
  78. Help: Set Transparency for chart (1 replies)
  79. Time breakdown function in Excel (8 replies)
  80. Solved: www.domain.com TO name@domain.com (5 replies)
  81. Searching for cell Data via form (2 replies)
  82. opening a workbook (1 replies)
  83. Solved: clipboard message (1 replies)
  84. Solved: changing the default file path (1 replies)
  85. I need a code to recognize a trigger value of.... (2 replies)
  86. Disable design mode with password? (6 replies)
  87. Solved: Cell Value Question - Error Handling? (7 replies)
  88. Excel Export (4 replies)
  89. do until (8 replies)
  90. [SOLVED:] Presentation in UserForm (2 replies)
  91. Cut and Paste rows (7 replies)
  92. Deleteing excluded columns/rows in MS Graph Datasheet (2 replies)
  93. Solved: Macro runs regardless of Msg Box press NO (4 replies)
  94. Insert search and edit button (7 replies)
  95. Solved: How to get values from hidden sheet (9 replies)
  96. Keyboard (5 replies)
  97. [SOLVED:] Object Required error (5 replies)
  98. Solved: Workbook close event (5 replies)
  99. Pivot Table: Sort rows according to columns (0 replies)
  100. Solved: Date format help (5 replies)
  101. Using VBA to initiate a windows macro (1 replies)
  102. Add values when checkbox is checked. (5 replies)
  103. Random Records (1 replies)
  104. Remoing Pivot Items (0 replies)
  105. MaxLength for Textbox (10 replies)
  106. button works funny, why?? (5 replies)
  107. multiple workbooks--take values and match (5 replies)
  108. Clear cell value after data entry (4 replies)
  109. Help: 3D chart (0 replies)
  110. Verification on my defining variable and small piece of code (5 replies)
  111. drop down lists (5 replies)
  112. Automating Exporting Records (9 replies)
  113. search for a file in a folder using rows of data in an excel file (7 replies)
  114. Displaying Image on a Userform (2 replies)
  115. principle component analysis for excel (8 replies)
  116. Filter Issue (1 replies)
  117. Solved: Using Page Field to Create Multiple Sheets in Pivot Table (3 replies)
  118. runtime error 13??? (2 replies)
  119. Create Bandings within a Pivot Table (0 replies)
  120. xlDialogSaveAs: Lock it to a specific directory? (0 replies)
  121. Help with Password (1 replies)
  122. Solved: interacting with other applications (4 replies)
  123. Solved: Sub v Function (5 replies)
  124. Solved: Format Cell with Upper Case (6 replies)
  125. Vlookup Macro that updates values by file by date. (4 replies)
  126. Solved: Run macro only once within 20 hours (5 replies)
  127. Solved: Extract specific data from a worksheet. (2 replies)
  128. Using Windows Media Player in VBA (0 replies)
  129. Copy, Paste, Then Save (7 replies)
  130. Vlookup is this what I need??? (15 replies)
  131. [SOLVED:] VB to find first populated number & then sum range of cells (7 replies)
  132. String Cell Formula from Column Headings (1 replies)
  133. Solved: Tricky copying to a new Sheet - Urgent Help Needed Please! Thanks!!! (0 replies)
  134. Solved: more chart questions....defining specific ranges to axes (2 replies)
  135. Solved: Vlookup for Duplicates (8 replies)
  136. Issues With Adding TextBox (12 replies)
  137. Text file from Excel - MESSY! HELP! (3 replies)
  138. Opening Up a PDF Document via a Command Button (7 replies)
  139. Clear ComboBox (1 replies)
  140. Stop Webpage from popping up (0 replies)
  141. Validate Data entered in UserForm (1 replies)
  142. Sleeper: Preventing Duplicate data entry in a userform (24 replies)
  143. Is Excel 2007 back compatible to 100%? (10 replies)
  144. [SOLVED:] Defining both axes titles for charts (3 replies)
  145. Solved: Match Values in Column A and Column B and if matched copy entire row (0 replies)
  146. List sub folder permission groups (0 replies)
  147. Solved: Pivotable.pivotfield.pivotitem problem (8 replies)
  148. Deleting all named ranges except "Print_Area" (4 replies)
  149. Solved: count the cells with fill color (3 replies)
  150. Delete Columns if value equals zero (2 replies)
  151. Color cells based on values (9 replies)
  152. Query for Help (4 replies)
  153. Solved: Remove all lines (2 replies)
  154. linking problem.. (2 replies)
  155. Solved: Break the password protecting the code (1 replies)
  156. Solved: worksheet counting (3 replies)
  157. Macro for Tracing Precents and Formula Auditing (2 replies)
  158. calculating slope (3 replies)
  159. Solved: changing plot area of chart to have gradient look (3 replies)
  160. Change attributes of a folders contents (2 replies)
  161. msgbox help wanted (6 replies)
  162. Opening Access From Excel Macro - Security Warning (1 replies)
  163. Return Missing Lookups (5 replies)
  164. Solved: Help: Time Scale for chart (6 replies)
  165. User Defined Folder For hyperlink in Excel (1 replies)
  166. Help using list boxes (4 replies)
  167. Delete row if value does not exist (6 replies)
  168. Application.FileSearch and Excel 2007 problem (2 replies)
  169. How to efficiently handle sets? (6 replies)
  170. a formula in footer (1 replies)
  171. Changing the contents of the hint in a graph (4 replies)
  172. two questions.....public variables and naming charts (2 replies)
  173. Solved: using just the cells with relevent data in to plot graph... (10 replies)
  174. Solved: when closing file and users click on NO (do you want to save...)...ask one more time (3 replies)
  175. Solved: how to delete some range with values on another sheet (4 replies)
  176. Solved: phantom name ranges (11 replies)
  177. Embedding Word into Excel Form (1 replies)
  178. [SOLVED:] Check to see if macro has run (10 replies)
  179. Comparing 2 sheets (1 replies)
  180. form - cursor position - Excel 2007 (9 replies)
  181. Help with filling data in relative cells (1 replies)
  182. elements in an array (27 replies)
  183. Pivot Table processing problem (0 replies)
  184. chart background divided into segments (2 replies)
  185. Excel link in webpage works, but saves in temp file instead of original location (6 replies)
  186. Excelk VB code (8 replies)
  187. when last day in month and time is 23:55 then copy cells??? (8 replies)
  188. Selecting A Cell - In A Column By its heading (2 replies)
  189. Solved: Print problem (6 replies)
  190. Vague Drop Down Menu Question - Sorry! (5 replies)
  191. Autofilling (2 replies)
  192. Help protecting pivot tables with exceptions (0 replies)
  193. Dynamic Bespoke Chart (2 replies)
  194. UPDATE HYPERLIck (11 replies)
  195. Sending emails on behalf of a group - VBA - Lotus Notes (0 replies)
  196. Solved: Change text to numbers for different sheets and workbooks (6 replies)
  197. [SOLVED:] Form Navigation Buttons (9 replies)
  198. Solved: Excel Security (2 replies)
  199. code problem (8 replies)
  200. Authenticating against Active Directory AD usign Kerberso? (1 replies)
  201. solver and excell 2007 (2 replies)
  202. Update table reference while code runs (0 replies)
  203. Dynamic listbox, help! Stressed... (4 replies)
  204. Combobox ListFillRange (7 replies)
  205. Solved: Setting the print area for used rows and columns (4 replies)
  206. TREE hYPERLICK UPDATE (5 replies)
  207. Solved: Change Date Format VBA (2 replies)
  208. Assign picture to Image Control (2 replies)
  209. Solved: copy a cell value not the formula?? (12 replies)
  210. Returning RecordSet Objects from Functions (2 replies)
  211. Solved: Font color for string (2 replies)
  212. Find Column Difference (3 replies)
  213. Searching Words in a String (4 replies)
  214. Solved: Transfer data from one sheet to another based on criteria (3 replies)
  215. Solved: averaging variable sized ranges (11 replies)
  216. Print PDF script: check for pdf printer and give dialogue to choose? (18 replies)
  217. WebQuery difficulties (6 replies)
  218. Color cells (1 replies)
  219. Solved: Excel Comments item (2 replies)
  220. Solved: For loop for Large Data (2 replies)
  221. Solved: Run Once Then Delete Code (9 replies)
  222. look down column and paste values across cells (1 replies)
  223. Cell Incrementation (15 replies)
  224. Solved: select or activate fail when code is active? (10 replies)
  225. copy offset and paste loop (2 replies)
  226. Date Format US/UK (0 replies)
  227. Solved: WEEK in MONTH (20 replies)
  228. Solved: Minimize user form (7 replies)
  229. Solved: button problems... some extra wishes... (9 replies)
  230. Solved: Box Next To Column A And Above Row 1... (3 replies)
  231. Copy/Paste/Delete based on Date (4 replies)
  232. Generate Numbers Based On Month, Year And four Digit Number (4 replies)
  233. find the range in a sheet (9 replies)
  234. insert picture in cell (4 replies)
  235. Insert Rows (17 replies)
  236. Need help with command button (9 replies)
  237. Solved: listing errors in data, using Vlookup (3 replies)
  238. Solved: MsgBox not big enough? (13 replies)
  239. not a VBA question but please help (6 replies)
  240. sum every n-th row (4 replies)
  241. Solved: Barcode Help (6 replies)
  242. restricting copy paste so it won't copy formatting (3 replies)
  243. Adding/copying tables base on Input Data (1 replies)
  244. Solved: Understanding what used in this file (6 replies)
  245. Field cannot be updated (7 replies)
  246. Converting Excel 97/2000 to Excel XP/2003 (3 replies)
  247. Pics not being copied (1 replies)
  248. Solved: Formula with ranges based on variables (2 replies)
  249. optimization question (6 replies)
  250. Solved: Early Binding ADODB from Excel (7 replies)