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. Using VBA to download a file from a website (6 replies)
  2. Solved: Select Case (9 replies)
  3. how to set import defaults? (2 replies)
  4. combine (1 replies)
  5. COPY (4 replies)
  6. Excel 2007 Saving issues (3 replies)
  7. Solved: return which Option Button was clicked (2 replies)
  8. Solved: Extracting words in Uppercase (5 replies)
  9. Solved: How do you count this? (19 replies)
  10. Solved: Excel Macro for trade reconciliation (10 replies)
  11. ListBox1 populates Listbox2 upon selection from a sheet? (4 replies)
  12. Pivot Table keeps showing wrong results (1 replies)
  13. open file from outlook (2 replies)
  14. Multiplying an arbitrary number of polynomials (4 replies)
  15. Show Formula Value (2 replies)
  16. 2 colors in one cells. (3 replies)
  17. Consolidate data to one master workbook (30 replies)
  18. Dynamic hyperlink formula won't link to file path when saved to new location (0 replies)
  19. remove text from an unmerged cell (3 replies)
  20. Solved: VBA Highlight row (10 replies)
  21. [SLEEPER:] Replace dots with commas (3 replies)
  22. [SOLVED:] Called sub not working (15 replies)
  23. Need to make DTPicker invisible based on another cell's value. (7 replies)
  24. Solved: check if anything in userform changed (3 replies)
  25. Issue with the macro which downloads the files from internet. (0 replies)
  26. Copy files, from a given list! (1 replies)
  27. Merge workbooks sheets (1 replies)
  28. Solved: how can i use the userfrom to replace the value in sh (13 replies)
  29. Find dupe row, move one of them (4 replies)
  30. [SOLVED:] Open new message and populate To: Box in outlook from excel (1 replies)
  31. Solved: Worksheet_Change not running right (2 replies)
  32. Solved: Control Workbook from another Application Window (6 replies)
  33. Solved: How to run macro for 2 event changes (3 replies)
  34. Userform/Checkboxes Formatting (4 replies)
  35. Merging Cells Using Excel-VBA (10 replies)
  36. Personal.xls??? (2 replies)
  37. Controlling the display of a text box (8 replies)
  38. [SOLVED:] Range = index() + textBox.value (4 replies)
  39. Solved: How to obtain two cell data from each worksheet in an Excel file? (2 replies)
  40. Reg : Merging of cells (3 replies)
  41. Solved: Excel Concatentate formula... (4 replies)
  42. Module question (4 replies)
  43. Solved: Averages of column and formatting (9 replies)
  44. Border war (3 replies)
  45. Fill a combobox from a spreadsheet? (1 replies)
  46. Solved: Target.Offset(0,2) & Run-time error (2 replies)
  47. [SLEEPER:] Permuations (5 replies)
  48. Solved: test filter and delete row in OLD and NEW office (2 replies)
  49. Merge two data inputs (3 replies)
  50. Solved: Delete range based on 3 cell values? (1 replies)
  51. Solved: Loops that write specific data to file (18 replies)
  52. Solved: Command Buttons fire 'Runtime 438' (5 replies)
  53. How to save an SQL file using Save Dialog in excel (4 replies)
  54. FORM - goto first text box if not found (2 replies)
  55. [SOLVED:] Turning Checkboxes into Numeric Values (4 replies)
  56. Calling Function with 2 args results in "Expected: =" compile error (12 replies)
  57. Solved: loop varaible (9 replies)
  58. Solved: How to write imported file's name in a cell? (9 replies)
  59. How to record delete event in excel (1 replies)
  60. converging data (1 replies)
  61. Macros that can translate from English to Spanish. (4 replies)
  62. How to record a deleted row value in excel (8 replies)
  63. How to select a range of cells which are filled in not an active sheet. (6 replies)
  64. Check cell range contains data if adjacent cell is not blank (6 replies)
  65. Crashes When Saving (1 replies)
  66. How to select Random Rows after Autofilter?? (11 replies)
  67. Duplex printer needs help (1 replies)
  68. Formating table (3 replies)
  69. [SOLVED:] Excel crashes (5 replies)
  70. Populate a combobox & textbox in a userform with data from a dynamic table (7 replies)
  71. pivot labels (2 replies)
  72. web browser control focus trouble! (1 replies)
  73. Solved: VBA to to unhide sheet (7 replies)
  74. read write access using VBA (1 replies)
  75. Solved: Print Page Numbering by Tab index in Footer (3 replies)
  76. 3 cells to another sheet next row (6 replies)
  77. [SLEEPER:] Workbook locking up (4 replies)
  78. Complex data output into html (1 replies)
  79. Excel/VBA date compare not working (3 replies)
  80. Looping through a batch of workbooks (5 replies)
  81. change font color for disable textbox (6 replies)
  82. Solved: Help with VBA subtotal and remove subtotal (2 replies)
  83. Solved: Creating a Dynamic Nested ForLoop (ie.variable number of nests) Recursive functions? (8 replies)
  84. Change arrow key behavior (3 replies)
  85. [SOLVED:] Problem with setting Range, and calculating SUM (2 replies)
  86. Unique items and renaming of sheet issues (2 replies)
  87. Counting the filled cells (2 replies)
  88. Solved: Sending an Outlook message from Excel (4 replies)
  89. Solved: Code to unprotect only one worksheet (11 replies)
  90. Solved: What is this EXTRA bit of code - date format) (5 replies)
  91. Solved: Bulk Insert of Names for Ranges/Cells? (12 replies)
  92. Solved: Dial and Gauge Charts for Excel 2007 and 2010 (1 replies)
  93. Solved: Find and Replace in Range - Compare Codes (2 replies)
  94. saving code in VBE window (4 replies)
  95. Help debug an R1C1 formula (4 replies)
  96. decimal points (3 replies)
  97. XML Node attributes (2 replies)
  98. Excel crashes when calling Doc Readystate (4 replies)
  99. Solved: only numbers (6 replies)
  100. [SLEEPER:] Callng a sub from another sub (2 replies)
  101. Solved: combine all workbook (1 replies)
  102. Sleeper: Excel Macro - Word doc as message body images (0 replies)
  103. Solved: Update UNLOCKED cells on a different sheet? (4 replies)
  104. Load list of ftp files from directory into a userform? (0 replies)
  105. Compare two worksheets (1 replies)
  106. [SOLVED:] Conditional formatting for entire row for text based values using VBA code (2 replies)
  107. Solved: Create chart based on current month (4 replies)
  108. Find value and copy value from another column (0 replies)
  109. Hide Horizontal Scrollbar (5 replies)
  110. Solved: conditional formatting VBA (6 replies)
  111. Solved: Combining two bits of vba (29 replies)
  112. Solved: finding if two controls overlap (3 replies)
  113. Best Match (3 replies)
  114. Selecting typical Data and copying in a new sheet in other format (4 replies)
  115. how to force paste-special values in excel (0 replies)
  116. Tidy up of code required (6 replies)
  117. Array Help (6 replies)
  118. Solved: remove vba (5 replies)
  119. opening new instance of Excel when opening file (3 replies)
  120. Accessing a Database through VBA (7 replies)
  121. Solved: Setting a range to the result of a formula (2 replies)
  122. return specific values (2 replies)
  123. APIs in VBA Help (3 replies)
  124. [SOLVED:] Locked cells - values from macro (3 replies)
  125. Disable userform.show (5 replies)
  126. open a file based on a modified date (1 replies)
  127. encrypted macros (7 replies)
  128. Solved: Hiding Columns if all cells = zero (3 replies)
  129. Linking Password Protected Workbooks (2 replies)
  130. Solved: Changing color of item in listbox based on value of specific cell (5 replies)
  131. calculation col and rows min and max values (0 replies)
  132. setfocus on a form (2 replies)
  133. autofilter problem (1 replies)
  134. date problem on a form (2 replies)
  135. Form Picture help (4 replies)
  136. Controlling IE sub documents from Excel VBA (2 replies)
  137. Solved: Issue with applying a name to a range in autofiltered table (6 replies)
  138. IFS, ORS, ANDS??? (5 replies)
  139. Solved: Save as 'todays date' (3 replies)
  140. Solved: Copy files given location to a new location (3 replies)
  141. Solved: Run Time Error '76' (3 replies)
  142. Pivot Table VBA (1 replies)
  143. Disable cut/copy/paste - but still be able to copy between workbooks?? (4 replies)
  144. How to do Multiple If Statements Shortcut! (13 replies)
  145. Linking Excel Cell with Text Box (5 replies)
  146. Solved: encounter error (2 replies)
  147. Automatic Select Based on Cell Value (5 replies)
  148. Solved: Counting Substring Presence in Range (4 replies)
  149. Excel 2007 Clear Cache at run time? (10 replies)
  150. Application.InpuBox restriction - input 1 cell (1 replies)
  151. Solved: KB Article (21 replies)
  152. Solved: How to Exlcude some charts from Macro (6 replies)
  153. Remove Conditional Formatting (8 replies)
  154. Hiding, Copying and pasting in a specific order (7 replies)
  155. Solved: Formula take 2 (6 replies)
  156. Refreshing External Database Query In Excel using VBA (2 replies)
  157. Can I use IF function and run a macro? (6 replies)
  158. Solved: Sort Defined Range (3 replies)
  159. Solved: How to do repeated File-Open commands in alternate locations (6 replies)
  160. Solved: Exit and Exit Full Screen (3 replies)
  161. Hide/Unhide rows - NT login (1 replies)
  162. Solved: Formula help again (7 replies)
  163. Question about CountA() and dynamic named ranges (7 replies)
  164. How to close FORM in ANOTHER WORKBOOK (0 replies)
  165. Solved: Compare columns in different excel files (12 replies)
  166. Excel attachment with lotus notes (2 replies)
  167. Solved: Have code check for 2 sheet names and copy values from them (5 replies)
  168. delete workbook after a certin time period (10 replies)
  169. show me the way to the next ... (0 replies)
  170. Solved: combine multiple workbook become one (1 replies)
  171. Solved: upload file (10 replies)
  172. Solved: VBA to Hide Toolbar (10 replies)
  173. dynamic graphs (3 replies)
  174. Solved: Date stamp in column L if forumlua in column W = 1 (17 replies)
  175. extracting phone & fax # (4 replies)
  176. click save csv files (1 replies)
  177. Excel VBA Help (1 replies)
  178. Recognizing Time > 24h (7 replies)
  179. Solved: Excel VBA - Save As with Password (13 replies)
  180. Entering data in next empty row (2 replies)
  181. Solved: delete content after save (3 replies)
  182. Solved: convert formula to VBA (4 replies)
  183. Solved: delete part of string in every string (3 replies)
  184. getting file path of image (1 replies)
  185. global arrays are reset after pasting images from another sheet (3 replies)
  186. Scrolling down a list to find a specific number (9 replies)
  187. Toolbar macro won't run (8 replies)
  188. Solved: trigger msgbox once (2 replies)
  189. Solved: Possible for excel to detect inactivity at pc? (9 replies)
  190. VALUE = NOTHING (2 replies)
  191. Solved: Cleaning up a list.... direction please. (3 replies)
  192. Solved: Remove Duplicates (6 replies)
  193. [SOLVED:] Identify Unique Cells In Range (16 replies)
  194. Logo Place Holder (0 replies)
  195. Copying Down Formula using VBA (1 replies)
  196. vlookup or something else (2 replies)
  197. i have a problem about fields of executed query in vba (1 replies)
  198. populate comboboxes multicolumns ignoring empty filds (7 replies)
  199. Macro to Select Range and Copy (8 replies)
  200. Solved: Save file with worksheet name (5 replies)
  201. Change formulas to values, but with some exceptions (2 replies)
  202. Rename Worksheet Tab in UPPER CASE (3 replies)
  203. Excel Password Recovery (4 replies)
  204. Extending COUPNCD for monthly payments (2 replies)
  205. Events (3 replies)
  206. Solved: Menu? (6 replies)
  207. File is not a recognizable format (3 replies)
  208. Filter rows on sheet 2 when a certain option is chosen on sheet 1 (4 replies)
  209. Solved: check box logic (9 replies)
  210. overflow runtime error (1 replies)
  211. [VBA - UserForms] Adding (2 replies)
  212. How to add rows to tables using macros (11 replies)
  213. Face IDs and Buttons (6 replies)
  214. Solved: vba delete entire row (2 replies)
  215. Activating Hyperlinks (3 replies)
  216. multiply names in variable (userform) (0 replies)
  217. Worksheet function Sum in Excel VBA (1 replies)
  218. using VBA instead of fomula in the sheet due to multiplie calculation (0 replies)
  219. Excel Spreadsheet to Word UserForm (3 replies)
  220. simulating keystrokes (4 replies)
  221. loop help (1 replies)
  222. message box format (3 replies)
  223. Loop link to spreadsheet. (0 replies)
  224. Vba help (3 replies)
  225. Create Macro - Select Range? (3 replies)
  226. Count Formula (4 replies)
  227. Open, find and replace in notepad++ using VBA script (2 replies)
  228. Solved: VBA inserts spaces into formula (6 replies)
  229. VBA PLOT JUMP ROW (1 replies)
  230. Solved: VBA to find last populated cell but ignore formulas returning blank (2 replies)
  231. Search entire column for word/phrase and list results (0 replies)
  232. Command Button to send SS as E-Mail (7 replies)
  233. Autofilter with VBA (2 replies)
  234. [SLEEPER:] Link to another workbook and find duplicate entries (10 replies)
  235. Solved: paste file name in all rows of a column (3 replies)
  236. Making a chart's x axis dynamic (3 replies)
  237. Solved: sort activeworksheet, out of range (4 replies)
  238. Conditional Formatting for Constantly Changing Spreadsheet (2 replies)
  239. Excel 2002 Find and copy to another worksheet" (2 replies)
  240. UpdateLinksNever when Adding Template (1 replies)
  241. Formula help (3 replies)
  242. STOPWATCH (1 replies)
  243. Increment in date value if time exceeds a particular value (16 replies)
  244. Fixing postal addresses (2 replies)
  245. Solved: Date formula (13 replies)
  246. making calculation on named range col but returning col number total (6 replies)
  247. Solved: Copy Module (6 replies)
  248. Solved: Help required on Filtering a Pivot Table (1 replies)
  249. help with vba calculation on several columns based on row. (5 replies)
  250. copy and search (11 replies)