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: If, End If; UserForm textbox to numerical variable (7 replies)
  2. Solved: Preventing user entering duplicate values in a cell range (9 replies)
  3. how to do a variable odbc/.mbd database query (2 replies)
  4. Cannot stop Highlight (2 replies)
  5. Center Across Selection ... (3 replies)
  6. Tab Order Screwy (2 replies)
  7. [SOLVED:] Custom right-click menu (2 replies)
  8. Solved: Combining Lookahead and Lookbehind in regular expressions (5 replies)
  9. Function dosn't update value (8 replies)
  10. Solved: Changing the column order in a worksheet according to an array (4 replies)
  11. [SOLVED:] SaveAs Then CopyDown Then Sort (11 replies)
  12. Solved: Worksheet function help (3 replies)
  13. Solved: Merge Workbooks (4 replies)
  14. Solved: Insert columns in multiple sheets along with formula in a specified row numbers. (8 replies)
  15. Solved: Finding number of items in an Array (4 replies)
  16. Create Excel add-in (6 replies)
  17. programmatically clearing checkboxes (9 replies)
  18. Conditional formatting question (6 replies)
  19. Solved: Clipboard (4 replies)
  20. Count rows between two range (11 replies)
  21. find & open a file (1 replies)
  22. Solved: links (7 replies)
  23. Present Value (3 replies)
  24. frustration with protecting a sheet! (10 replies)
  25. Solved: Help with a Vlookup function. (7 replies)
  26. Solved: Altitude estimation program (5 replies)
  27. Export to excel (5 replies)
  28. PO numbers (4 replies)
  29. speed up link s (1 replies)
  30. Solved: Existing codes need help PLS (11 replies)
  31. Solved: minimizing all windows except mine (3 replies)
  32. Select or If Statement? (9 replies)
  33. Solved: Getting rid of old data...but keep formulas (8 replies)
  34. clear memory? (1 replies)
  35. Solved: Selecting a different database in Lotus for automated message (0 replies)
  36. Weekdays between two dates (9 replies)
  37. COUNT VALUE AND BLANK CELLS VALUE (1 replies)
  38. Putting in 1,000's of hyperlinks. (3 replies)
  39. Solved: Array to store range (3 replies)
  40. Conditional Formatting (1 replies)
  41. find all cell containing comments (2 replies)
  42. Solved: Looping in Userform (5 replies)
  43. Solved: need help urgently (6 replies)
  44. Extracting data from pivot table (0 replies)
  45. Only if has value (1 replies)
  46. Solved: Concatenate problem (8 replies)
  47. VBA to replace ranges of array formulae (6 replies)
  48. Office 12 (7 replies)
  49. Add ins Order (2 replies)
  50. Populate list box from another sheet (2 replies)
  51. Solved: "Integer" vs "Long" in For...Next Loops (21 replies)
  52. Data import from web (2 replies)
  53. Solved: macro doubt (15 replies)
  54. Solved: Add In Problems (4 replies)
  55. Filtering a ListBox (10 replies)
  56. Solved: Delete line if.... (0 replies)
  57. [SOLVED:] Copy, destination & paste special (8 replies)
  58. Solved: Return based on mutliple criteria (8 replies)
  59. Is formula solution available? (15 replies)
  60. Image Control changing images from network based on data validation (0 replies)
  61. Solved: Excel confirmation messages (4 replies)
  62. [SLEEPER:] Image path (url) in cell A1 (3 replies)
  63. [SLEEPER:] "Pause" Checking ... (6 replies)
  64. Unique Entries to be dispalyed in drop down list as per renge given in data sheet (3 replies)
  65. if function using option buttons. (7 replies)
  66. Creating Pivot Table using Userform (1 replies)
  67. Solved: Check if IE is running (3 replies)
  68. Bad coding habits (17 replies)
  69. this file is opned from.... (2 replies)
  70. Solved: Copy a hyperlink address from a website (17 replies)
  71. Embedded Charts or Chart Sheets (1 replies)
  72. Embedded Object "Management" (1 replies)
  73. Solved: Distribute xla in other language versions of Excel (23 replies)
  74. Solved: Very helpful piece of code (26 replies)
  75. Solved: Copy Module or UserForm into another file (7 replies)
  76. Getting an event from an ActiveX dll in VBA (1 replies)
  77. Solved: Copy/Paste strange thing happening (2 replies)
  78. For each vs For I = ... (10 replies)
  79. Solved: Good books? (8 replies)
  80. Solved: Call Macro From Hyperlink (5 replies)
  81. Solved: word doc as attachement (11 replies)
  82. Solved: Emailing file from excel (8 replies)
  83. pivot table: divide data columns with same data field (9 replies)
  84. Solved: Set a Trial Period For Use of Your Project (5 replies)
  85. Fun Stuff - System Tray Icon for a userform (5 replies)
  86. send message to Outlook for user alert (12 replies)
  87. Solved: Code inconsistancey (8 replies)
  88. [SOLVED:] get column letter (23 replies)
  89. Easiest Way To Build Currency Converter (4 replies)
  90. Solved: Document properties. (5 replies)
  91. Solved: Columns in MsgBox (2 replies)
  92. Using a path to the source ss (1 replies)
  93. Get data from XML file (1 replies)
  94. Solved: Creating/Updating ShortCuts (2 replies)
  95. Solved: Open another workbook w/o macros executing (4 replies)
  96. Solved: Transfer dynamic cell value to second sheet (6 replies)
  97. Solved: Hiding a password in a code (31 replies)
  98. Solved: Chart to only use visible data (7 replies)
  99. ComboBox with 1 to 100 (2 replies)
  100. Recording time spent on a worksheet (5 replies)
  101. Solved: Using VBA to fill in Web Login Form (3 replies)
  102. Solved: Hyperlinking to Embedded Object (7 replies)
  103. Autofilter copy/paste (1 replies)
  104. button link worksheet prob (1 replies)
  105. Search for whole words (27 replies)
  106. Solved: AutoFit - Expand Cell With Data Entered? (24 replies)
  107. Solved: trsnsfering value from column.... (5 replies)
  108. Solved: New Day, New Project (7 replies)
  109. autofilter with a cell as the criteria (9 replies)
  110. Solved: Unique find with VBA (8 replies)
  111. Solved: Register a dll via VBA (5 replies)
  112. Solved: Save Active Worksheet (3 replies)
  113. Solved: LOOPING through a date range? (39 replies)
  114. Solved: Using VLOOKUP command (5 replies)
  115. Book.xlt and insert sheets (2 replies)
  116. Solved: Check if Range is Empty (13 replies)
  117. Solved: Date Stuff (3 replies)
  118. Solved: Need Help - Duplicate entries (10 replies)
  119. Solved: RowHeight - Multiple (2 replies)
  120. Solved: Truly secure macro code with password? (3 replies)
  121. Maximization of Value by Changing Parameters (5 replies)
  122. Reading RTF Format (0 replies)
  123. Solved: shapes.visible (3 replies)
  124. Call A Macro (7 replies)
  125. average calculation (4 replies)
  126. Solved: Addins - Using worksheet as a template (4 replies)
  127. Allowing validation on protected sheet (2 replies)
  128. Simple Find Macro/Input box... (4 replies)
  129. Solved: Advanced import of txt files data in to Excel (4 replies)
  130. cell for read only (1 replies)
  131. tracking changes (3 replies)
  132. Solved: Paste Special, Values (1 replies)
  133. Solved: Dynamic range reference (9 replies)
  134. alternative to pivot tables (4 replies)
  135. custom autoformat (0 replies)
  136. Solved: list of exception for loop (15 replies)
  137. Print file using commandbutton (1 replies)
  138. Solved: button for delete entire data in worksheet (2 replies)
  139. Open document as "Read ONLY" only (5 replies)
  140. create wbook from wbook template (1 replies)
  141. rangename/column#/refersto ISSUES (3 replies)
  142. Solved: MsgBox problem (6 replies)
  143. Solved: Check Cells and Before Close (17 replies)
  144. Solved: Create New Series on the Secondary Axis (5 replies)
  145. Solved: External Links (1 replies)
  146. Solved: arrays (4 replies)
  147. select single cell as auto filter (9 replies)
  148. Solved: Userform to edit filtered data (9 replies)
  149. Dynamic Named Formula for a table, not just one column (12 replies)
  150. I could really use some help with this... (2 replies)
  151. Solved: Moving data (9 replies)
  152. Solved: Copy after the last line of data (4 replies)
  153. Mac files (1 replies)
  154. Import Property of User into Excel (3 replies)
  155. Solved: Picking out data (4 replies)
  156. Balance Sheet, SumProduct and VBA, how to? (4 replies)
  157. Solved: Saving contents of Clipboard (6 replies)
  158. Solved: Copy a Hidden worksheet from a protected excel file and Save AS (6 replies)
  159. Solved: understand a file is open from a zip folder (4 replies)
  160. Solved: Hide then unhide worksheet (2 replies)
  161. "Auto Complete" Internet Form (31 replies)
  162. Solved: Using the Registry in an Application (9 replies)
  163. Solved: Assigning Values to Multiple Cells (5 replies)
  164. Solved: offset property (3 replies)
  165. Solved: Changing tab color (3 replies)
  166. Solved: Date functions (4 replies)
  167. Solved: Macro Copying and Pasting (3 replies)
  168. Solved: problems with loop (19 replies)
  169. Solved: Reducing Userform Load Time (2 replies)
  170. Solved: rank top4 with vlookup (3 replies)
  171. Solved: Copy a worksheet from excel file and save it as another new file (2 replies)
  172. Solved: Help ...Passing Arguments (11 replies)
  173. Solved: SUMIF (8 replies)
  174. user form pop-up with excel start (5 replies)
  175. AUTO UPDATE WBOOK (1 replies)
  176. datediff function (2 replies)
  177. file search method using msoConditionIsExactly or msoConditionEquals (4 replies)
  178. timesheet code (3 replies)
  179. Solved: Browsing for folder shell (3 replies)
  180. Solved: Deleting cell contents rather than cell itself (6 replies)
  181. Solved: Entering date into adjacent cell to selected (4 replies)
  182. Solved: Yes/No Checkboxes Complete Before E-mail? (9 replies)
  183. [SOLVED:] Copy / paste Word file from 1 destination to other (5 replies)
  184. Solved: Time&Date Calculation and Formatting issue (2 replies)
  185. Solved: Still hate shapes... (5 replies)
  186. Sending Email from Excel (3 replies)
  187. Code Review - Files from Directories (17 replies)
  188. Solved: ComboBox Query (11 replies)
  189. Solved: Saving code into a "normal" template (22 replies)
  190. Solved: Flippin awkward task! (5 replies)
  191. Solved: check for existing value (2 replies)
  192. Solved: Username from Office/Excel (6 replies)
  193. Solved: Print out macro code (15 replies)
  194. Solved: Set all array elements to same value? (2 replies)
  195. Issues with InputBox (17 replies)
  196. Solved: Count occurrence or particular keyword within Excel (7 replies)
  197. Solved: Help... Excel VBA Problem (5 replies)
  198. [SLEEPER:] Copy sheet problem with protection (2 replies)
  199. Solved: macth and copy plus calculate before paste (3 replies)
  200. Finding data (3 replies)
  201. Solved: SQL Problem (4 replies)
  202. Solved: Macro to copy and paste special values (8 replies)
  203. Input Box (5 replies)
  204. Solved: Making months and years from now. (9 replies)
  205. Solved: Center Across Selection...How Does It Work?? (0 replies)
  206. Solved: PV formula (2 replies)
  207. Solved: Hide a Row when Formula is "True or False" (8 replies)
  208. [SOLVED:] Manipulating a pie chart (3 replies)
  209. detecting range selection for copy (8 replies)
  210. Is ActiveX my boatanchor? (3 replies)
  211. Mail Merging problem (3 replies)
  212. Solved: Deleting numbers automatically (7 replies)
  213. Solved: maximise user form (6 replies)
  214. Solved: How to delete A LOT of autoshapes (6 replies)
  215. Column widths in ListBox (3 replies)
  216. Solved: What Triggers This Message?? (11 replies)
  217. Solved: Divide number of days (3 replies)
  218. Solved: Testing the value of a check box (5 replies)
  219. more than 3 conditional formats? (4 replies)
  220. Application.Evaluate error (12 replies)
  221. Solved: Every Friday in a month (2 replies)
  222. count rows after worksheet is filtered (16 replies)
  223. Search Listbox and Click it Find (5 replies)
  224. Solved: Different quest on Excel -> Word (6 replies)
  225. How to get consecutive data in different sheet (2 replies)
  226. Solved: Excel Text Newsbar - Moving Text (16 replies)
  227. adding in list box (1 replies)
  228. Solved: If statement to change format (2 replies)
  229. Solved: Generate sheets based on data (7 replies)
  230. Break down a Target range? (4 replies)
  231. Pass parameters to SQL query in Excel (4 replies)
  232. Copy worksheets (2 replies)
  233. Overflow, Double Type (5 replies)
  234. Solved: Minimize excel (2 replies)
  235. Solved: Delete , in column A. (4 replies)
  236. Progress Bar (2 replies)
  237. Solved: Arbitrary Array (5 replies)
  238. Solved: little code needed (8 replies)
  239. Solved: VBA error (3 replies)
  240. Solved: auto filter pivot table (1 replies)
  241. Solved: userform (3 replies)
  242. Solved: Find "-" position in text (3 replies)
  243. count unique words in columns (17 replies)
  244. Hide or Unhide checkbox (10 replies)
  245. Why does it find itself Loop (11 replies)
  246. selecting all sheets w/ a condition (macro) (11 replies)
  247. Solved: Urgent! Exit this loop! (2 replies)
  248. Solved: Sort a column (15 replies)
  249. Solved: Multi Information from Listbox (2 replies)
  250. macro- using date in one ws to move to various new ws's (5 replies)