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. VBA code to run on specified time (3 replies)
  2. Solved: Only copy selected sheets (2 replies)
  3. Printing Copies with VBA (2 replies)
  4. For loop trouble (2 replies)
  5. VBA to export 2 worksheets at a time (9 replies)
  6. Loop Help (1 replies)
  7. Solved: Decrease qty thru msgbox (12 replies)
  8. Permutations (5 replies)
  9. Help defining and setting variables (9 replies)
  10. Solved: Select Row problem (3 replies)
  11. Request for review (11 replies)
  12. Solved: (5 replies)
  13. Solved: Stop CommandButton moving or rename button (1 replies)
  14. Transpose single column array (4 replies)
  15. Worksheet Delete (4 replies)
  16. Loop the code (16 replies)
  17. [SOLVED:] How to print from sheet active to the another sheet (4 replies)
  18. Last row of the worksheet (6 replies)
  19. Solved: Search for text in IE (4 replies)
  20. Is there a formula or statement that works out percentage rates in Excel? (4 replies)
  21. Help with clear contents (3 replies)
  22. VBA Select Case (4 replies)
  23. Extract data from PDF (6 replies)
  24. Update only the latest data from Excel to Access table (6 replies)
  25. Compile Error (5 replies)
  26. Solved: Specific cell selection (4 replies)
  27. UDF to calculate average according to condition, ignoring blanks (6 replies)
  28. Sleeper: Input Mask (2 replies)
  29. Problem switching between Excel and Word (1 replies)
  30. Solved: disable protected sheet message (1 replies)
  31. Solved: Excel - Change font color if invoice number is out of order. (31 replies)
  32. highlight the cell with "peter" (6 replies)
  33. Basic question about Application.enableevents (9 replies)
  34. Solved: Question About copy Selection (2 replies)
  35. Solved: Insert row above next empty cell within a column (6 replies)
  36. Error using Find function (3 replies)
  37. Cut and paste the challenge (2 replies)
  38. VBA code-Signature code failure (0 replies)
  39. Highlight The Selected. (2 replies)
  40. Is that possible to excute code by using Keboards "CTRl+Eneter" (10 replies)
  41. Solved: Disable all saving (2 replies)
  42. Solved: Ignore Countif If Cell Contains a Value (4 replies)
  43. clear contents formula (2 replies)
  44. Is it possible to upgrade Excel and perform File Remediation using vba? (3 replies)
  45. Run-time error '13' on comparing arrays help needed (2 replies)
  46. Solved: use input box chara to create new woorksheet name (10 replies)
  47. Solved: display multiple labels as $0.00 (4 replies)
  48. excel VBA and post for ASP.NET (4 replies)
  49. How to select option in pop-up list???? (6 replies)
  50. Data Input Form Workbook (6 replies)
  51. Detecting a cell change (4 replies)
  52. SaveAs Command to Overwrites a Excel File (6 replies)
  53. Solved: Why does code need On Error Resume Next? (7 replies)
  54. Sending Excel Cell Data via E-Mail (3 replies)
  55. Solved: Merge Workbooks (2 replies)
  56. Solved: Code prevents formulas working! (10 replies)
  57. formula for logical condition (3 replies)
  58. Finding special charecters in excel (5 replies)
  59. Solved: Mortgage loan spreadsheet problem (8 replies)
  60. using conditional formatting (9 replies)
  61. Solved: Selecting a Rows with Data (2 replies)
  62. Solved: Split cell contents into multiple rows (6 replies)
  63. Return control after application.run (2 replies)
  64. Need help with default save script from 2010 to 2003 (3 replies)
  65. Solved: VBComponents - how to retrieve "Sub" or "Function" exactly (14 replies)
  66. Solved: Create new folder with name and date (1 replies)
  67. Ado DB connection in Excel (1 replies)
  68. Report from excel database ?? (2 replies)
  69. Creating charts using VBA: problem with intervals (2 replies)
  70. Sumif (14 replies)
  71. pervent only one sheet from deletion (2 replies)
  72. How to turn any URL input into file name (7 replies)
  73. Set Cell Value As Variable? (1 replies)
  74. Open web Page and clink on a link within the page (1 replies)
  75. max value of another textbox (2 replies)
  76. Excel stopwatch needed (2 replies)
  77. Solved: Find maximum value in a column (3 replies)
  78. Solved: Input Box Validation please help (4 replies)
  79. Is it possible to use vba to automate a count on recurring data? (1 replies)
  80. VBA array difficulty (1 replies)
  81. Filter Sheet With text on cell (3 replies)
  82. VBA code below (2 replies)
  83. System Error: &H8001010D (-2147417843) An outgoing call cannot be executed... (1 replies)
  84. Excel 2007/2010 - Can I have workbook specific disabling of row inserting? (5 replies)
  85. VBA Copy & Paste (20 replies)
  86. count the no. of A (1 replies)
  87. excel addin problem (1 replies)
  88. Solved: Clear Red Interior if Text is Red (4 replies)
  89. Excel keeps switching between 'ready' and 'chart updating' (1 replies)
  90. Macro help required if possible (2 replies)
  91. DOM: Searching only the tags embedded within one particular div tag (6 replies)
  92. VBA Help needed total newbie (8 replies)
  93. "Window" menu item (6 replies)
  94. Write data to sheet 2 if sheet 1 is full (1 replies)
  95. Solved: need a magic formula to .. (3 replies)
  96. Sum Values in defined target (3 replies)
  97. How do I close an instance of Quickbooks in VBA? (3 replies)
  98. Print workbook - disable (3 replies)
  99. creating a data base using Excel & VBA (1 replies)
  100. File (path to a folder) not found (1 replies)
  101. Solved: Two listboxes on same userform problem (2 replies)
  102. Read external data from dynamic text range, then calculate stats (5 replies)
  103. Excel 2003 VBA coding tweak (1 replies)
  104. Excel 2003 VBA coding and "pop up button" help (1 replies)
  105. VBA Chart fill area (8 replies)
  106. Insert Hyperlink from External Source to a Protected Sheet (3 replies)
  107. Automatic Macro execution (2 replies)
  108. Excel 64bit issue with Winsock UDP connection (0 replies)
  109. Using Yes No Message Box (6 replies)
  110. Solved: Problem with copy/paste "Formats" (4 replies)
  111. SUM IF in vba and result in message box (1 replies)
  112. Update code in 220 objects (10 replies)
  113. SSN Format (3 replies)
  114. Solved: Code not updating all worksheets (2 replies)
  115. Solved: Selection Rows CountA? (2 replies)
  116. Excel Problem (1 replies)
  117. Extract rows to new worksheet and save as new workbook (5 replies)
  118. Solved: Locate values from List (7 replies)
  119. Using vba to open website (1 replies)
  120. Solved: how do i get the the name of the user who opened the file? (4 replies)
  121. Using iMacros in a loop with input from Excel (2 replies)
  122. Solved: Excel, append & retrieve numbers in a txt file with next number in increments one (27 replies)
  123. data model in excel (4 replies)
  124. Formatting a column into "text" (2 replies)
  125. Menu tree (0 replies)
  126. Solved: POP UP Message when a criteria is met (1 replies)
  127. Create 1 Public Sub for 5 textboxes (4 replies)
  128. Navigating Through a Recordset (Adding a Record Counter) (1 replies)
  129. Solved: Make sure numbers are increasing (26 replies)
  130. Searching from a list in Excel, extract Phone#'s from contact's in outlook 2003 (4 replies)
  131. Solved: Loop through controls and add data from cells (3 replies)
  132. Solved: Import a Silhouette & select X & Y coordinates then do a vlookup Based on the value (0 replies)
  133. Solved: Conditional Formatting only when value is present (5 replies)
  134. Is it possible to transfer data from ms access to excel using vba code? (5 replies)
  135. email different sheets to different people - code needs changing (4 replies)
  136. Clear contents in the last populated cell (3 replies)
  137. using Excel function TRIM rather than VBA function TRIM (1 replies)
  138. Listbox active workbooks and copy data (9 replies)
  139. Solved: Enter the next consecutive number (3 replies)
  140. comparing the 2 excel (1 replies)
  141. Solved: Need to loop thru a folder of workbooks and extract customer addresses (17 replies)
  142. option button macro (1 replies)
  143. Solved: need dynamic range (3 replies)
  144. Excel + Access Help (1 replies)
  145. [SOLVED:] Is it Vlookup or Sum Product ? (4 replies)
  146. Solved: TRIM in VBA (10 replies)
  147. Solved: Positioning UserForms (2 replies)
  148. Solved: Login Prompt (0 replies)
  149. Retrieving Data from another Worksheet (0 replies)
  150. Solved: Using Excel To Send Emails Through Lotus Notes (42 replies)
  151. "FindNext" function (7 replies)
  152. Is it possible to write vba code to create a conditional format on cells? (2 replies)
  153. VBA for combo box (4 replies)
  154. checking string in IF Loop (3 replies)
  155. Delete rows when the code gets deleted. (2 replies)
  156. Edit objects (4 replies)
  157. Solved: display msgbox once (3 replies)
  158. Excel Chart Object Name (3 replies)
  159. Adding a chart (2 replies)
  160. Consolidating multiple sheets onto one "parent" report sheet. (1 replies)
  161. cells colour (2 replies)
  162. [SOLVED:] Question on Hpyerlink (2 replies)
  163. Find problem (7 replies)
  164. Noob with a (probably) simple one (4 replies)
  165. Solved: VBA - Value Copy Multiple Criteria (4 replies)
  166. Solved: Validation data - excluded from list (3 replies)
  167. Solved: Array Formula not recognizing Imported Data as a Number (3 replies)
  168. do not display hide worksheets in data validation list (1 replies)
  169. Error handling: #REF! (1 replies)
  170. Solved: Rounding in units of 0.5 (7 replies)
  171. Solved: Trouble Storing Worksheet in a Variable (12 replies)
  172. Automatic Cut/Paste to new sheet at every month end (3 replies)
  173. Strange formula - now sure how it works (2 replies)
  174. Macro help - "Force Use Macros" plus "Auto Close" (5 replies)
  175. Solved: Printing Problem (2 replies)
  176. Selecting a range of sheets using crit in my Criteria (2 replies)
  177. Custome objects and Collections Classes. Help Please!!! (7 replies)
  178. Solved: Concatenate If in an Array (3 replies)
  179. Toolbare with option (3 replies)
  180. [SOLVED:] Further variation of Index/Match (5 replies)
  181. how to remove some range of cell only, (4 replies)
  182. Need a reference on where I can hire a local vba Excel expert to work on a project (4 replies)
  183. Solved: Copy/Paste All Cells on a Non-active worksheet (2 replies)
  184. [SOLVED:] Optionbutton deselection erases range value (2 replies)
  185. Excel VBA. Calculating worktime with different overtimes (5 replies)
  186. Solved: TextBox: Entering Date in specific format (5 replies)
  187. Solved: copy paste doesn't work (2 replies)
  188. Solved: .FormulaR1C1 = "=" & Formula_A (4 replies)
  189. Macro to do logic based on other column (3 replies)
  190. Solved: number format 0.00 €/m² (1 replies)
  191. Solved: cell.adress question (2 replies)
  192. Check box control on a worksheet (5 replies)
  193. Solved: Sales forecast (7 replies)
  194. ANNIVERSARY DATE (3 replies)
  195. Combinations (1 replies)
  196. tab colour (3 replies)
  197. Solved: Supressing '#N/A' in WorksheetFunction.VLookup (20 replies)
  198. Solved: VBA Assigning Variable / Runtime Error 1004 (4 replies)
  199. Solved: Formula results are different then Pivot Table (2 replies)
  200. sorted data (6 replies)
  201. Solved: Using Vlookup On UserForm (11 replies)
  202. [SOLVED:] Building Tables from List (4 replies)
  203. Solved: For Next Loop not completing (3 replies)
  204. user form textbox issue (2 replies)
  205. Couple days of work - now lost (3 replies)
  206. Pastespecial xlvalues (6 replies)
  207. Solved: Restrict Text Box (5 replies)
  208. Variables declared with 'New' cannot be made Nothing! (2 replies)
  209. Solved: Excel 2003 and 2007 - Cannot make selection in Listbox2 if click Button twice (4 replies)
  210. VBA Cond. Formatting, two sheets (17 replies)
  211. Solved: Vba to Okay Digital Cert and Signing data? (3 replies)
  212. How to fill all filenames into array without for-next or do-loop... (5 replies)
  213. show numbers with commas (5 replies)
  214. Solved: remove the repeated words/numbers in a cell (2 replies)
  215. Excel VBA to add/delete windows scheduled task (4 replies)
  216. label right-click event (4 replies)
  217. Excel 2003 - Can I notify user that I'm waiting for read/right access to a workbook? (3 replies)
  218. Excel 2003 – History log file of new row inserted and any data added into it. (0 replies)
  219. Displaying Images from Folder on Network in Excel Based on Cell Value (11 replies)
  220. activating a window in the taskbar (1 replies)
  221. Solved: How to open a Specific file MsWord( example C:\MyW.doc) from MsEXcel... (17 replies)
  222. if..............in (2 replies)
  223. Solved: Excel 2003 - Need the numer value at the end of a string (3 replies)
  224. Solved: Excel 2003 - My for ea loop is not looping per inputbox number (3 replies)
  225. Code Error: object variable not set (5 replies)
  226. Filter Sheet With date (3 replies)
  227. Help writing a VBA code!!! (1 replies)
  228. Import text file into spreadsheet (3 replies)
  229. VBA E-mail Open Workbook as Attachment in LOTUS NOTES (0 replies)
  230. Significant digit issue (7 replies)
  231. Incorrect Field Types in ADODB Recordsets (5 replies)
  232. Using Excel and VBA (2 replies)
  233. Solved: User Id/Password (7 replies)
  234. Issue Selecting Unique Date: Data Validation List used to Filter Pivot Table Field (0 replies)
  235. Issue Selection Data Validation List used to Filter Pivot Table Field (0 replies)
  236. Can anyone help with an IF formula (1 replies)
  237. Looping a solving procedure? (5 replies)
  238. Solved: how to determine the trimester of a date (4 replies)
  239. Insert row on value change and copy values from above (1 replies)
  240. Calling other macros (1 replies)
  241. extract specific data from a txt file (8 replies)
  242. Solved: Which sheets are select in a workbook? (4 replies)
  243. Solved: Looping through Dynamic Array (5 replies)
  244. Runnung JavaScripts as a button. (2 replies)
  245. Autofit Merged Cells / Autosize Formatting (4 replies)
  246. userform.print problem (4 replies)
  247. Solved: is it possible to disable xl2003 file open in xl2007+ (9 replies)
  248. Using Calendar Control to fill in dates (6 replies)
  249. Solved: Vlookup on todays date (2 replies)
  250. Solved: specific lentgh for a textbox (6 replies)