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. Highlight current row & column revisited (7 replies)
  2. Run Time Error 7 Out of memory Issues (3 replies)
  3. Solved: populate a two column search result (4 replies)
  4. Solved: Incremental counter that resets every year (7 replies)
  5. Help Troubleshooting a VBA Application (1 replies)
  6. Solved: COUNTIFS Formula not working in Excel 2007 (2 replies)
  7. Simple one - one cell - another cell, both datetime cells (1 replies)
  8. Solved: Using an Access form as a Dialog sheet? (3 replies)
  9. Solved: Event Macro to add text to cell (8 replies)
  10. Performing Find loop on all Word documents in a folder, writing results to a Spreadsh (5 replies)
  11. Flagging Rows based on Several Variables within the Row (8 replies)
  12. Managing and copying data obtained from UserForm (0 replies)
  13. Arrange (Cut and Insert Cut Cells) Rows using VBA Code (5 replies)
  14. Solved: Code Selection Change is fired by Enter key (14 replies)
  15. Open Files that include todays date (2 replies)
  16. Solved: Stopping a macro using a macro! (30 replies)
  17. Solved: Copy from sheet1 & paste to sheet2 in corresponding column (9 replies)
  18. Case in Case in If then .. else ... end if: compilation error (6 replies)
  19. Vba code for parent-child (9 replies)
  20. Incredibly Urgent Help - VBA Excel (12 replies)
  21. Solved: Add "<br />" before number. (7 replies)
  22. Criteria for Sumif (3 replies)
  23. Comparison of a set range of columns in Sheet2 to insert correct image to userform... (3 replies)
  24. pulling excel variable into webform and submit (1 replies)
  25. Changing several button properties only for the buttons in a list (1 replies)
  26. Solved: Unique record ID generator: please help! (17 replies)
  27. OWC10 issues (17 replies)
  28. Solved: VBA (7 replies)
  29. Using a filter to identify, copy and paste using VBA (0 replies)
  30. Sum cell values if highligted Red (1 replies)
  31. Need Outlook mails information by Excel VBA (6 replies)
  32. Format Ranged Cells Based on Value - VBA help (7 replies)
  33. Creating several buttons from a list in runtime (7 replies)
  34. Saving textbox data from a userform to Sheet2 cells... (2 replies)
  35. Update the current Macro (3 replies)
  36. VBA module / sub / function tree (9 replies)
  37. Solved: Compare 2 spreadsheets (3 replies)
  38. Can you use match within a countifs function? (2 replies)
  39. sort range (2 replies)
  40. changing color of cells with vba (1 replies)
  41. VBA winHTTP in async mode (5 replies)
  42. Help required, identify, copy and paste using VBA (0 replies)
  43. Newbie - Simple code needed (6 replies)
  44. Solved: Data_from_another_Spreadsheet (27 replies)
  45. Solved: Ammending a Copy/Paste between two workbooks macro (5 replies)
  46. SpellNumber as per Currency Selection (8 replies)
  47. calculate a checksum (10 replies)
  48. =IF function with 2 true results and 3 false results (26 replies)
  49. removing the double names by changing the current macro (25 replies)
  50. [SOLVED:] Sorting Different Ranges on Different Columns (3 replies)
  51. Is it even possible? (12 replies)
  52. Solved: Deleting Rows (7 replies)
  53. VBA Conditional Formatting - code efficiency (4 replies)
  54. Switching worksheets in another workbook (4 replies)
  55. Solved: Can "Lock project for viewing" cause issues? (7 replies)
  56. [SOLVED:] Macro to extract url from hyperlink and populate the url in the cell below? (2 replies)
  57. Ultimate VBA protection (2 replies)
  58. Solved: Hidden Userform (7 replies)
  59. Data missing in file downloaded using URLDownloadToFile (6 replies)
  60. Capturing data from a userform to specifice column rows in a worksheet (2 replies)
  61. problem with array formula (3 replies)
  62. Creating a Timestamp (9 replies)
  63. Sum less than 999 (4 replies)
  64. Excel 2010 to OutLook 2010 Meeting Request Problems (0 replies)
  65. Help me find example files? Imaging (1 replies)
  66. Solved: Data type mismatch on Regex replace (20 replies)
  67. VBA Macro: sorting in Column A (7 replies)
  68. Copying Excel data to Word, Only executes once. (Error 462) (1 replies)
  69. Solved: Match Transpose data to a column Using VBA (6 replies)
  70. Duplicate values (1 replies)
  71. Trying to reduce execution time (4 replies)
  72. Create Break, Reset and Continue buttons in the Excel Sheet (0 replies)
  73. Solved: Macros and cell references (4 replies)
  74. Siebel (1 replies)
  75. VBA not catching error (2 replies)
  76. Sorting two Arrays Together (0 replies)
  77. VBA Help - Newbie (4 replies)
  78. error (8 replies)
  79. [SOLVED:] Copy row and insert between existing rows with relative formula kept (6 replies)
  80. label caption (5 replies)
  81. Chart Series Selected Index (1 replies)
  82. Unable to set the FormulaArray properties of the Range Class (8 replies)
  83. Solved: I am trying to truncate cells in a column from a specific character in a string (5 replies)
  84. Create a custom calendar between two dates (1 replies)
  85. Open word files in excel (3 replies)
  86. Spinbutton value (5 replies)
  87. Solved: Insert an empty line between interval (2 replies)
  88. Display worksheet data in user form (1 replies)
  89. How to avoid pressing update button,delete button,confirm button by vba (3 replies)
  90. concatenate rows in column b for every corresponding value in column A (0 replies)
  91. Convert Data (5 replies)
  92. Solved: Find All function works Intermittantly (5 replies)
  93. Combine text from different cell in to one of them (4 replies)
  94. Macro to count and give totals (18 replies)
  95. Solved: Change textbox forecolor if date is earlier then today (1 replies)
  96. Solved: VBA Replace using regular expressions (25 replies)
  97. Help me - I'm still learning (18 replies)
  98. suppressing warnings / data connections in word (4 replies)
  99. Solved: Writing formula into cell with Macro. Inverted commas problem. (6 replies)
  100. Filter, Copy and Paste to New Tab (1 replies)
  101. Solved: Select line and send to specific fields to another worksheet (13 replies)
  102. Which is better? Processing speed question (5 replies)
  103. Best method to detect 32/64-bit Program Files Folder? (6 replies)
  104. Simple Data Entry form (8 replies)
  105. VBA To Send Email From Lotus Notes (24 replies)
  106. Calculate Matches (12 replies)
  107. Compare the date range and pull the values (6 replies)
  108. Image Catalogue - VBA Code (1 replies)
  109. calculate numbers using a key with VBA (3 replies)
  110. Saving to a folder and prompting user to enter file name (4 replies)
  111. Please explain this code to me (5 replies)
  112. Filter by color using checkbox (3 replies)
  113. Solved: run automatically each time the cell 'B5' changing information. (3 replies)
  114. Unexpected Behavior of VBA Code (3 replies)
  115. VBA-WebControl HTML Custom Change (1 replies)
  116. I need to copy a range of cells starting from a header row to "sheet2".. (14 replies)
  117. Copying all, not just content (2 replies)
  118. Find Multiple Text in Single Cell - Make Bold (14 replies)
  119. Code VBA Excel slowly (2 replies)
  120. VBA Arrays - Faster alternative than Vlookup? (5 replies)
  121. Failing to open existing workbook (6 replies)
  122. Solved: Pulling data (4 replies)
  123. Index problems in for loops - excel vba (5 replies)
  124. VBA coding help (16 replies)
  125. Solved: Search For String (13 replies)
  126. Excel VBA, how to retrieve textbox title/label in word fillable form (7 replies)
  127. formula not working at column E of NE sheet (3 replies)
  128. Solved: If and ElseIf Statement (5 replies)
  129. Iterate Columns using Solver and Goal Seek (2 replies)
  130. OnTime reschedule based on cell date days from today (1 replies)
  131. Import and Update Outlook Claendar to Excel (1 replies)
  132. Help PLEASE (2 replies)
  133. Changing the code (3 replies)
  134. Solved: Display 1 empty row only (9 replies)
  135. Solved: UserForm find not finding dollar amounts (2 replies)
  136. Custom Report form Excel data to text file (3 replies)
  137. [SOLVED:] How to get the series range of a chart ... (3 replies)
  138. Moving folders using VBA (12 replies)
  139. Fill List Box With Data From Two Or More Columns (12 replies)
  140. Private Sub Workbook_Open() and links (1 replies)
  141. Solved: How to code to open a read-only file with a "No" option? (1 replies)
  142. Protect cells at different intervals and allow to select certain range (7 replies)
  143. Help modifying code (6 replies)
  144. Solved: .TXT Batch replacing Macros (12 replies)
  145. Creating an outline based on data in column: (6 replies)
  146. Error when rng.find is nothing (8 replies)
  147. Solved: lookup and populate (2 replies)
  148. VBA Printing Code Problem (0 replies)
  149. System Error &H80004005 (-2147467259) Unspecified Error (6 replies)
  150. swapping values array (2 replies)
  151. call code (2 replies)
  152. Solved: nested looping (2 replies)
  153. [VBA] Reading a file from the server (2 replies)
  154. Solved: FindAll from Textbox Search on Form and fill ListBox with 34 columns (8 replies)
  155. Solved: Dependent combo boxes in a User form (10 replies)
  156. Application-defined or object-defined error (1 replies)
  157. [SLEEPER:] How to enter inputs from VBA a interface to excel spreadsheet? (2 replies)
  158. Troubleshooting Function (14 replies)
  159. Solved: VBA Print Code and Protected Sheet Problem (1 replies)
  160. Not able to Add a Scenario (3 replies)
  161. Vlookup entire row with match 2 criteria (9 replies)
  162. Solved: Copy all data on Sheet 1 to the latest blank row of sheet 2 (7 replies)
  163. Stopping macro (1 replies)
  164. Loop through subfolders (3 replies)
  165. Can't get .presentations.Open ThisWorkbook.Path & "\Pres.ppt" to work (0 replies)
  166. VLookup Help (5 replies)
  167. From text file to excel spreadsheet (3 replies)
  168. Compare Data and Tabulate Fields Using VBA (0 replies)
  169. Solved: Copy Data of duplicate item to first sheet . (13 replies)
  170. Solved: Find all occurrences in col T (18 replies)
  171. Solved: if find data delete the row on another sheet (2 replies)
  172. Solved: Find duplicates on 4 column and copy result on another column (3 replies)
  173. Event Workbook_BeforeClose (10 replies)
  174. Highest Values to the New Sheet (5 replies)
  175. Solved: QueryTables Loop Question (20 replies)
  176. Go to worksheet that is specified by user in a drop down list (8 replies)
  177. conditional formating. (7 replies)
  178. Problem with AfterUpdate for Listbox (4 replies)
  179. Solved: VB to insert missing rows with average of rows around it (2 replies)
  180. Solved: Specifying last row range (6 replies)
  181. Solved: enable or disable comboboxes based on textbox enter (3 replies)
  182. ADO / Worksheet range display in userform (7 replies)
  183. Macro to copy result based o criteria (1 replies)
  184. VBA and Citrix applications (0 replies)
  185. Solved: Data from multiple sheets into one sheet? (5 replies)
  186. A lending hand to PDF FDF (12 replies)
  187. Solved: How to activate the cells by using VBA (8 replies)
  188. Loop to Copy Text From Excel to Powerpoint Text Boxes (2 replies)
  189. Solved: UserForm with ComboBoxes and TextBoxes (24 replies)
  190. Solved: Code wont run in certain modules (4 replies)
  191. Solved: Cell value = #NUM! (10 replies)
  192. Solved: Round down to nearest 5,000 (4 replies)
  193. Saving a file vy referencing a cell and using RDB Create (1 replies)
  194. excel 2010 windows 7 64 bit hangs fooooorever (7 replies)
  195. Solved: Macro request: Copy rows that match values in a column of names (9 replies)
  196. Flag on birthday calendar (3 replies)
  197. Create Desktop Shortcut - Change Icon (2 replies)
  198. How can I change part of my title by referencing a value in a cell? (1 replies)
  199. MultiPage in UserForm (1 replies)
  200. Concatenate string with itself in a "while" loop (8 replies)
  201. Urgent VBA Debugging help (1 replies)
  202. SaveCopyAs not working. (3 replies)
  203. Automatic Calculation when sheet tab clicked (6 replies)
  204. VBA code for Cursor to stay Stationary in one cell (4 replies)
  205. Solved: Moving cell values based on specific criteria (6 replies)
  206. Solved: Move to Next Record (2 replies)
  207. Force ontime Macros to run one after another instead of simultaneously (1 replies)
  208. How to copy and paste the date (1 replies)
  209. Want to create a variable that references a cell (7 replies)
  210. Formating (pivot) (1 replies)
  211. Find 1st Empty Cell in Range (9 replies)
  212. Solved: how to make shipping label with picture (4 replies)
  213. Userform limit? (4 replies)
  214. Combining MsgBoxes into one box (1 replies)
  215. VBA code to send excel sheet as PDF (3 replies)
  216. Passing variables (1 replies)
  217. HTTPS GET REQUEST ***HELP*** (12 replies)
  218. Solved: Simple VB? Take one file and make many (7 replies)
  219. Solved: Sum particular data (15 replies)
  220. Validating more than one textbox for Null values (1 replies)
  221. Solved: Lastrow + (3 replies)
  222. Copy from one worksheet and save to another (2 replies)
  223. Hide columns based on cell value (5 replies)
  224. Solved: Report to collect filtered data from multiple sheets and consolidate (4 replies)
  225. [SOLVED:] Removing Duplicates for Multiple Columns independently (12 replies)
  226. group data (8 replies)
  227. Boost Macro running speed (3 replies)
  228. Solved: Increment Formula With If Statement (10 replies)
  229. Solved: Print pages that contain data (4 replies)
  230. Convert sub to function - prompt not appearing in formula bar (11 replies)
  231. display worksheet data in user form (2 replies)
  232. VBA Code to export Excel to OVERWRITE an EXISTING PowerPoint (2 replies)
  233. Solved: Hiding columns (6 replies)
  234. Open XML file in Notepad and delete all "-"es (7 replies)
  235. Input difference words run difference macro in one textbox (3 replies)
  236. Invoice Processing (4 replies)
  237. Right click option menu...specific items (3 replies)
  238. Solved: VBA to create a separate sheet for each month (8 replies)
  239. data conversion (3 replies)
  240. UK National Insurance Number Validation (3 replies)
  241. exe (3 replies)
  242. Solved: If wb is open give message (6 replies)
  243. Pull info from one Active Workbook and Save in Another (4 replies)
  244. Help with Macro and Object Variable (8 replies)
  245. Solved: Parsing Addresses (8 replies)
  246. Solved: Moving files from different source folder to different destination folders (5 replies)
  247. Solved: How to get Last Key or Key-Combo Pressed (Not Event) (7 replies)
  248. Solved: Select the cell with the click of a mouse, and have the result of calculation (2 replies)
  249. Help with macro to update text on shapes (2 replies)
  250. Solved: Get Textbox Value (2 replies)