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: SumProduct RowsandColumns (2 replies)
  2. Getting data from Word Controls into Excel (2 replies)
  3. Loop filter and copy (0 replies)
  4. auto save and close workbook after 15 minutes of inactivity (0 replies)
  5. Passing an Object to a Function (16 replies)
  6. Open Notepad and write something onto it (4 replies)
  7. Solved: VBA Formatting mess of text (4 replies)
  8. Solved: Do something every 14 minutes (3 replies)
  9. How to solve excel compatibility? (1 replies)
  10. Solved: Select the shape as shape variable (4 replies)
  11. Sum amounts based on another column (5 replies)
  12. Calculation On/OFF Basis On Selection (2 replies)
  13. use date stamp to trigger Shift:=xlDown? (2 replies)
  14. VBA functionality for String manipulation (3 replies)
  15. Solved: Problem in creating status bar (5 replies)
  16. Highlight the last selected cell (2 replies)
  17. Solved: Copy Range If Cell Value Equals (7 replies)
  18. A Combo Box for Certain Types of Information from another worksheet?? (4 replies)
  19. Solved: cut and pasted into Sheet2 (2 replies)
  20. Printing issue (9 replies)
  21. Help with concatrelated vba excel (2 replies)
  22. Modify Cut Paste (6 replies)
  23. Printing Unique Values (From a column) in a Combobox (9 replies)
  24. Loop through rows and delete/keep (1 replies)
  25. Run time error 1004 Applicatin-defined or object-defined error (Copy from src to dest (2 replies)
  26. show username if file is open (10 replies)
  27. Thematic Map (8 replies)
  28. Solved: Change color figures, with discretion (3 replies)
  29. Storing Variable From One Cell And Printing It Repetitively In Another Column (3 replies)
  30. Need to increase the percentage in a cell containing the original value (2 replies)
  31. Source workbook keeps opening when Destination workbook is protected? (1 replies)
  32. Excel code to open Access! (0 replies)
  33. Compare data between two workbooks (1 replies)
  34. Search Worksheet for Name if found copy to new workbook (12 replies)
  35. Syntax for Set_Cursor_Pos() (3 replies)
  36. Concatenate (Nest) "IF" Commands ?? (5 replies)
  37. Solved: Hide Rows...help in code (8 replies)
  38. Search Functionality that moves cursor (1 replies)
  39. [SOLVED:] Find Question (3 replies)
  40. Loop? Copy/Paste from to Summary from Workbooks on Server (0 replies)
  41. Code running amazing slow when file is shared (1 replies)
  42. Create Workbooks based on Unique Values from a Column (6 replies)
  43. Login and Password for user form (3 replies)
  44. MACRO help to delete some files in a particular folder (3 replies)
  45. Solved: Populating Textbox 2 on the basis of Textbox 1 (2 replies)
  46. Solved: insert row if match is missing in column above (12 replies)
  47. Formula to pull formula from another cell (18 replies)
  48. Solved: creating multiple xltx templates (3 replies)
  49. get data from word form into excel using macro (0 replies)
  50. "method range of object _worksheet failed" Error (2 replies)
  51. FileName (5 replies)
  52. Solved: Locate Date in cell formatted as DD-MMM (6 replies)
  53. XML Integration (8 replies)
  54. How to control an Excel file without opening it? (1 replies)
  55. xmlHttp get requst - cannot get past login (4 replies)
  56. Remove last few characters from a string (1 replies)
  57. Filtered Cells Problem (2 replies)
  58. Conditional Format On Specific Range (10 replies)
  59. Windows Explorer Shortcut Link Generator (1 replies)
  60. 'Partial' Julian Date Issue (4 replies)
  61. Populate Two Text Box using input value (2 replies)
  62. Solved: VBA table summarize (6 replies)
  63. Excel using Loop (12 replies)
  64. Solved: Add Hairline Border Via Vb (4 replies)
  65. Solved: Copy, Open, Paste (6 replies)
  66. Solved: Identifying Duplicates Prior to Data Entry. (5 replies)
  67. GOBACK subroutine for Excel 2007 (2 replies)
  68. Solved: Email active worksheet using Outlook (2 replies)
  69. Solved: Copy From Multiple Files To One (6 replies)
  70. Solved: Error found in codes given in KB (13 replies)
  71. Excel WB painfully slow (4 replies)
  72. How to enumerate a variant array? (9 replies)
  73. Solved: error with mouse_down (2 replies)
  74. Sumdata based on a table of possible criteria (2 replies)
  75. MyCheck Fuction (4 replies)
  76. Solved: Automatically Update date in cell value if workbook is saved under a different name. (8 replies)
  77. Sleeper: Passing transformed arguments to UDF (10 replies)
  78. Troubleshoot an Overflow Error (17 replies)
  79. What is the code to open access file (2 replies)
  80. Solved: Creating a dynamic concatenation from a list (2 replies)
  81. Moving Files Based on Last Modified Date (9 replies)
  82. modify macro with hyperlink (2 replies)
  83. Solved: VBA Interaction with IE (4 replies)
  84. Paste onto filtered cells (1 replies)
  85. Conditional Formatting - Change font (2 replies)
  86. shade header row (2 replies)
  87. Solved: Fill an array with vlookup vba (5 replies)
  88. date range and return value (1 replies)
  89. Filter a sheet and copy results to another sheet (0 replies)
  90. Solved: Creating a dynamic user defined function (7 replies)
  91. Solved: Delete Duplicate Values only... Not rows (9 replies)
  92. Sleeper: vba program (3 replies)
  93. Solved: Populate hyphen for continuous three or more zero in a row (4 replies)
  94. Solved: How to suppress replacing cells when using PasteSpecial? (6 replies)
  95. [SOLVED:] Index/Match VBA equivalent to append data (3 replies)
  96. Simple Merge of two lists/tables (2 replies)
  97. Macro to import entire text file into single cell (4 replies)
  98. alphanumerics only (7 replies)
  99. Real Time Clock in a Textbox on a Userform (2 replies)
  100. Solved: update pivot tables based on the value of cell 'C2' (2 replies)
  101. Determining the 2nd highest number in a list (3 replies)
  102. VB disable conditional formatting code (1 replies)
  103. How to create a sequence of dates? (1 replies)
  104. Copying sheets into new workbook (4 replies)
  105. simple auto macro :) (4 replies)
  106. getting the row numbers of visible rows in an filtered selection (3 replies)
  107. Using conditional formatting (5 replies)
  108. How to copy an active Excel worksheet to another excel file? (1 replies)
  109. Solved: Command Button (Save as PDF) (5 replies)
  110. Can somebody help to achieve following tasks? (1 replies)
  111. Worksheet on change code a bit slow (3 replies)
  112. Reference across sheets (1 replies)
  113. Insert and Delete Rows in Entire Workbook (8 replies)
  114. Solved: Stop watch in excel which just displays minutes (5 replies)
  115. FileSystemObject create file containing text copied from IE (2 replies)
  116. Getting Application defined error 1004 for vba (1 replies)
  117. Save as xlsm function (2 replies)
  118. Solved: Calculate Distribution (8 replies)
  119. find closest date (4 replies)
  120. Solved: Opening and writing to multiple ASCII text files (6 replies)
  121. Solved: Detecting Last Time File Was Opened (6 replies)
  122. Sleeper: Macro loop issues (2 replies)
  123. Macro Triggers Unreadable Content Error on Restart (2 replies)
  124. Macro is getting Runtime error 91 - why? (3 replies)
  125. Excel 2 XML using Macro (1 replies)
  126. Project locked for viewing - SendKeys? (32 replies)
  127. Solved: Loop through multiple sheets and delete rows based on a cell reference (4 replies)
  128. Accessing files in order of Date Last modified (1 replies)
  129. Solved: Dynamically populate combobox in userform (10 replies)
  130. Solved: function to find the number of iterations/loops Do...Loop (7 replies)
  131. Synchronizing Multiple Worksheets (1 replies)
  132. Solved: CAGR formula using only range as input (7 replies)
  133. VBA from Excel to Outlook 2010 help (2 replies)
  134. Master Directory Search (Needs A Tweak) (6 replies)
  135. Find all hard coded references (14 replies)
  136. Change Dropdown Macro (1 replies)
  137. Solved: code running too fast? (9 replies)
  138. Solved: run macro from one workbok to affect other workbook (3 replies)
  139. How to post sample excel data (1 replies)
  140. VBA Help - Desk sharing solution - thanks in advance (1 replies)
  141. Drop Down List to Copy Contents of Another Column into a Certain Column (4 replies)
  142. VBA pivot with no range (3 replies)
  143. VBA HELP! - Need slight change to my code (9 replies)
  144. Total values associated with unique value in adjacent column (5 replies)
  145. Solved: Converting the VB code to VBA. (6 replies)
  146. [SOLVED:] 3 cells USERFORM to enroll in one cell in excel (2 replies)
  147. Something odd has happened with an "Always on Top" window. (8 replies)
  148. Solved: VBA Copy a template sheet and paste it into multiple sheets (2 replies)
  149. Combine multiple rows into one and then seprate specific columns (1 replies)
  150. Adding MMM-YY to filename (1 replies)
  151. To paste in Word the selected text in webpage by an Excel macro (1 replies)
  152. Macro doesn’t work after a table is created. (5 replies)
  153. VBA with PI Datalink (2 replies)
  154. Solved: Dynamically setting a dropdown dependant upon cell value (4 replies)
  155. Help getting script to exit if cell is blank (1 replies)
  156. Sort duplicates on top (1 replies)
  157. Copying and pasting cells from Excel to a fillable PDF file (7 replies)
  158. Split Data in one cell into below rows (4 replies)
  159. Array raising each element to a power - please help! (3 replies)
  160. To get in Excel the URL of the opened Webpage ? (1 replies)
  161. Input box to select sheet then rename sheet (2 replies)
  162. Compare two worksheets and give the difference as result (3 replies)
  163. [SOLVED:] Many urgent excel at vertical instead of horizontal word (5 replies)
  164. Open Workbook transfer info then close workbook (2007) (2 replies)
  165. Solved: help getting listindex from listbox (1 replies)
  166. Multiple LIKE operators? (10 replies)
  167. Solved: Loop Help (3 replies)
  168. fill Combo box data acroding to text box data entry. (4 replies)
  169. Retreiving the properties out of a class. (4 replies)
  170. Conditional formatting according to range (3 replies)
  171. Solved: msgbox displaying new workbook object path (7 replies)
  172. Closed workbook and extract sheet by cell value (4 replies)
  173. Find the Double ID (11 replies)
  174. Solved: populate with range from another sheet (4 replies)
  175. [SOLVED:] Application or Object defined error (2 replies)
  176. Pop Up Message Keeps popping up (5 replies)
  177. Solved: how to copy range and paste in same range in another workbook (3 replies)
  178. Macro for hidding and unhidding sheets (14 replies)
  179. VBA - Setting Pivot Chart height at pivot table refresh (4 replies)
  180. [SLEEPER:] Retrieve Values through an RS232 Connection (3 replies)
  181. Find Times Greater than Time Entered (1 replies)
  182. Auto-filter turning off in protected worksheet (2 replies)
  183. Worksheet Security based on Windows ID (1 replies)
  184. Excel Page Format-help pls. (6 replies)
  185. Macro showing various errors in my code for charts. (1 replies)
  186. VBA excel 2011 save as PDF (9 replies)
  187. VBA to view QT Connection String (13 replies)
  188. SQL Statement Help (9 replies)
  189. Search and highlight project help (3 replies)
  190. Solved: Lock a row after a value is chosen from a drop down menu (6 replies)
  191. Need some code tweaking. To scan text files to find certain figures (5 replies)
  192. Combine over 100 workbooks into a single workbook (3 replies)
  193. Sub based on form control checkbox (13 replies)
  194. Copying Column A to Column E and removing the 4th cell of each value (7 replies)
  195. [SOLVED:] Transpose ADO import (16 replies)
  196. TurnOff AutoCalc on one sheet only (10 replies)
  197. Variable Sheet name issue (7 replies)
  198. Linking Cells From Two Worksheets - Advanced (0 replies)
  199. Check first 10 characters of every file in list (17 replies)
  200. range determined by cell value (13 replies)
  201. help needed to update and edit data from Userform to worksheet. (5 replies)
  202. Populate ComboBox with text/value (0 replies)
  203. Solved: Append function formula to range (3 replies)
  204. Solved: Remove line break in cell (4 replies)
  205. Adding progress bar to existing code (4 replies)
  206. Solved: if column B is empy delete the data on column A (2 replies)
  207. Filling table i e-mail (2 replies)
  208. Solved: Remove the comma of the first cell (7 replies)
  209. Set noteApp = CreateObject("notepad.Application") , failed (12 replies)
  210. Solved: Hyperlinks to sheet with single quote in name (7 replies)
  211. Find Function excel VBA Help (1 replies)
  212. Cant get the macro to click a button (1 replies)
  213. Show sum of textboxes in a textbox. (3 replies)
  214. Solved: Combine data from row to one cell (2 replies)
  215. Converting Word to PDF using VBA (5 replies)
  216. Single Cell to ListBox (2 replies)
  217. Solved: Deinstall Add-in? (2 replies)
  218. Application Defined or Object Defined error (3 replies)
  219. Solved: select correct sheet if complied to 2 values on a selected worksheet (2 replies)
  220. Deleting Worksheets Containing Dates Older than X (2 replies)
  221. Solved: mergeing all date in each row (5 replies)
  222. Solved: Copy Paste from Dropdown (2 replies)
  223. Solved: Populate listbox based on sheet selected from a ComboBox (2 replies)
  224. delete all the entries based on the user input (2 replies)
  225. Excel sheet cell referencing. (6 replies)
  226. How to protect VBA if read-only? (2 replies)
  227. Basic problem needs help: undesired looping in alternate rows (3 replies)
  228. Importing Tables From Word Into Excel Spreadsheet Cells (7 replies)
  229. Solved: faster way to delete cells not containing certain word (5 replies)
  230. Active Cell formula to change automatically (11 replies)
  231. Solved: Divide column based upon character count (4 replies)
  232. Solved: Find specific word from text string and poulate in seperate cell (continuation) (5 replies)
  233. VBA code comboboxes (skip blanks & avoid repeats) (16 replies)
  234. Macro works part does not change the picture (3 replies)
  235. combine workbooks with same column count (0 replies)
  236. Mental Math workbook - vba to copy down (23 replies)
  237. Finding file name by numerical order (9 replies)
  238. Solved: Branch to specific line in another macro (5 replies)
  239. Solved: VBA Code Help please :) (14 replies)
  240. Pivot Chart Macro Problem In Excel (2 replies)
  241. Solved: Find specific word from text string and poulate in seperate cell (7 replies)
  242. Solved: VLOOKUP or INDEX/MATCH ? (2 replies)
  243. ADOX :Object or provider is not capable of performing requested operation (1 replies)
  244. Solved: VBA: Unusual LastRow Range (6 replies)
  245. Start HTML parsing at an already open webpage (2 replies)
  246. Solved: Evaluate("INDEX vs Application.Index (4 replies)
  247. Problems with variables and properties (3 replies)
  248. unlock the vba project (6 replies)
  249. Sleeper: Changing the current macro using if Statement or offset (6 replies)
  250. Solved: Change code to Private Sub Worksheet_Change (ByVal Target As Range) (12 replies)