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. How to pass combobox/textbox selected member into sql string in main module (2 replies)
  2. Solved: Clear Specific InteriorColor Index (4 replies)
  3. Solved: Macro to change text to date in a set range of cells. (18 replies)
  4. Two Quick Questions: Using Count Method + Using Offset Property (1 replies)
  5. PDFCreator automation in VBA Excel (10 replies)
  6. Solved: Strange behaviour of =cell("filename",A1) formula (4 replies)
  7. Solved: (How to) Transpose one long list of numbers in CSV file to a number of rows (4 replies)
  8. Solved: Using a loop with Select Case (2 replies)
  9. Help Referencing Other Spreadsheets (1 replies)
  10. Tooltip on Labels (3 replies)
  11. Buggy Pivot Tables? (3 replies)
  12. Solved: Workbook_SheetChange and If Not Intersect error (1 replies)
  13. Solved: Cancel a Loop if .Find Parameters Do Not Exist (8 replies)
  14. Excel VBA Get Internet Explorer Data (7 replies)
  15. Specify paper tray (4 replies)
  16. Solved: copij formula in protected sheet (4 replies)
  17. VBA to Concatenate Variable Range (3 replies)
  18. Solved: Combobox: Enter, Tab and Backspace Keys Not Triggering Keypress Events (2 replies)
  19. Extract Text from Word Document and Put in TextBox (4 replies)
  20. Number Format Short_Cut (1 replies)
  21. Data editing/moving/arrange. (2 replies)
  22. Populate a useform textbox with text from Control Box form (8 replies)
  23. Solved: VBA average and standard deviation homework help (11 replies)
  24. Solved: VBA function procedure homework help (5 replies)
  25. Empty vs Zero (6 replies)
  26. VBA Vlookup (3 replies)
  27. Solved: Detecting when a different sheet is made active without using Worksheet_Activate (5 replies)
  28. Solved: VBA -- IF Statement (6 replies)
  29. Solved: Inconsistent updating of spreadsheet formula when changing file name (8 replies)
  30. Computing average over columns with VBA (7 replies)
  31. VBA – Array Filter (4 replies)
  32. Create Search Form (0 replies)
  33. Solved: Macro to Re-arrange Data (4 replies)
  34. Solved: Operate with data from txt file (3 replies)
  35. 430 Error when Macro Run (1 replies)
  36. Solved: Track Cell Value Change (5 replies)
  37. Choose range (17 replies)
  38. Application defined or Object defined error (7 replies)
  39. Run HLOOKUP macro on outcome of Data Validation (2 replies)
  40. vba workbook_sheetchange event for xlam thisworkbook (5 replies)
  41. Solved: Copy formula automatically & Paste valuse :VBA code error Rectification (2 replies)
  42. Generating Custom Report thru VBA (2 replies)
  43. Add value, as seconds, to LongDate (4 replies)
  44. Solved: Vba code to clear data cells only not those with formula (1 replies)
  45. Solved: Dynamic array in VBA of newly added worksheets (4 replies)
  46. Scroll to a named macro in the VBE (10 replies)
  47. Solved: Inserting data into the column and maintain it locked (8 replies)
  48. Copying Excel range to Word doesn't copy the image (1 replies)
  49. Selecting 2 Cells to the right of the ActiveCell (3 replies)
  50. VBA merge from some open and some closed workbooks (0 replies)
  51. Code doesn't send in email (0 replies)
  52. excel pivot table problem (2 replies)
  53. Filter : date after 15 /10/2012 (2 replies)
  54. Solved: Copy and Paste Row if Cell Has Value (22 replies)
  55. Solved: Copy B4 value of each guide based on column A of worksheet "Plan2" (4 replies)
  56. Searching multiple workbooks for hidden content (1 replies)
  57. If Statement checking (5 replies)
  58. Madness - Excel Crashing (1 replies)
  59. Private Sub : copy formula (3 replies)
  60. Highlight the selected cell (2 replies)
  61. Read/Write Userform to variable range of cells (4 replies)
  62. Excel 2007 (7 replies)
  63. combine all file in a one workbook (2 replies)
  64. Solved: Advice and Help which database to use (6 replies)
  65. Need help on MultiPage control (1 replies)
  66. Application.MacroOptions: StatusBar property not working (7 replies)
  67. Solved: count, insert, copy, paste rows from one worksheet to another (2 replies)
  68. Help please want to write string sorting function (4 replies)
  69. Nested IF Function not working when the first condition is False (6 replies)
  70. Solved: Locking a Row Question (2 replies)
  71. Problem with keeping the year end dates of downloaded financial data (2 replies)
  72. Solved: Pivot Date Filter between variable number of days (2 replies)
  73. Sine Wave Audio Sound Generator (10 replies)
  74. Solved: Change in Path to Server - Query Macros Affected (2 replies)
  75. [SOLVED:] File Renaming Tool - Working in Subfolders (18 replies)
  76. Sort Values In Array (24 replies)
  77. Plotting to PDF (0 replies)
  78. Solved: Workbook Slowdown (1 replies)
  79. Highlighting particular cells (1 replies)
  80. Play Sound in Excel (23 replies)
  81. Count members of AD group from Excel (0 replies)
  82. Same number of trades (1 replies)
  83. Excel VBA Error 445 in 2007/10 but 2003 is fine (1 replies)
  84. Send Excel Body by Outlook (0 replies)
  85. editing text in a cell (2 replies)
  86. Data transfer based on certain findings (4 replies)
  87. auto Email (0 replies)
  88. Compare two worksheet current code modification (6 replies)
  89. Merging two or more files, column by column (1 replies)
  90. Nested loops and populating a new ws with the items (2 replies)
  91. Solved: vary column (5 replies)
  92. Help VBA code for calculating time difference (1 replies)
  93. Solved: automatic FormulaCalculation Option using VBA (5 replies)
  94. Disable File Save And Highlight Empty Cells (5 replies)
  95. Formatting excel sheet (5 replies)
  96. Solved: Runtime error '13', Type Mismatch (9 replies)
  97. Copying range to variant (12 replies)
  98. Question on ActiveWorkbook.Calculate (4 replies)
  99. Populating IP Address & Username of the user in Excel (9 replies)
  100. Solved: SumProduct RowsandColumns (2 replies)
  101. Getting data from Word Controls into Excel (2 replies)
  102. Loop filter and copy (0 replies)
  103. auto save and close workbook after 15 minutes of inactivity (0 replies)
  104. Passing an Object to a Function (16 replies)
  105. Open Notepad and write something onto it (4 replies)
  106. Solved: VBA Formatting mess of text (4 replies)
  107. Solved: Do something every 14 minutes (3 replies)
  108. How to solve excel compatibility? (1 replies)
  109. Solved: Select the shape as shape variable (4 replies)
  110. Sum amounts based on another column (5 replies)
  111. Calculation On/OFF Basis On Selection (2 replies)
  112. use date stamp to trigger Shift:=xlDown? (2 replies)
  113. VBA functionality for String manipulation (3 replies)
  114. Solved: Problem in creating status bar (5 replies)
  115. Highlight the last selected cell (2 replies)
  116. Solved: Copy Range If Cell Value Equals (7 replies)
  117. A Combo Box for Certain Types of Information from another worksheet?? (4 replies)
  118. Solved: cut and pasted into Sheet2 (2 replies)
  119. Printing issue (9 replies)
  120. Help with concatrelated vba excel (2 replies)
  121. Modify Cut Paste (6 replies)
  122. Printing Unique Values (From a column) in a Combobox (9 replies)
  123. Loop through rows and delete/keep (1 replies)
  124. Run time error 1004 Applicatin-defined or object-defined error (Copy from src to dest (2 replies)
  125. show username if file is open (10 replies)
  126. Thematic Map (8 replies)
  127. Solved: Change color figures, with discretion (3 replies)
  128. Storing Variable From One Cell And Printing It Repetitively In Another Column (3 replies)
  129. Need to increase the percentage in a cell containing the original value (2 replies)
  130. Source workbook keeps opening when Destination workbook is protected? (1 replies)
  131. Excel code to open Access! (0 replies)
  132. Compare data between two workbooks (1 replies)
  133. Search Worksheet for Name if found copy to new workbook (12 replies)
  134. Syntax for Set_Cursor_Pos() (3 replies)
  135. Concatenate (Nest) "IF" Commands ?? (5 replies)
  136. Solved: Hide Rows...help in code (8 replies)
  137. Search Functionality that moves cursor (1 replies)
  138. [SOLVED:] Find Question (3 replies)
  139. Loop? Copy/Paste from to Summary from Workbooks on Server (0 replies)
  140. Code running amazing slow when file is shared (1 replies)
  141. Create Workbooks based on Unique Values from a Column (6 replies)
  142. Login and Password for user form (3 replies)
  143. MACRO help to delete some files in a particular folder (3 replies)
  144. Solved: Populating Textbox 2 on the basis of Textbox 1 (2 replies)
  145. Solved: insert row if match is missing in column above (12 replies)
  146. Formula to pull formula from another cell (18 replies)
  147. Solved: creating multiple xltx templates (3 replies)
  148. get data from word form into excel using macro (0 replies)
  149. "method range of object _worksheet failed" Error (2 replies)
  150. FileName (5 replies)
  151. Solved: Locate Date in cell formatted as DD-MMM (6 replies)
  152. XML Integration (8 replies)
  153. How to control an Excel file without opening it? (1 replies)
  154. xmlHttp get requst - cannot get past login (4 replies)
  155. Remove last few characters from a string (1 replies)
  156. Filtered Cells Problem (2 replies)
  157. Conditional Format On Specific Range (10 replies)
  158. Windows Explorer Shortcut Link Generator (1 replies)
  159. 'Partial' Julian Date Issue (4 replies)
  160. Populate Two Text Box using input value (2 replies)
  161. Solved: VBA table summarize (6 replies)
  162. Excel using Loop (12 replies)
  163. Solved: Add Hairline Border Via Vb (4 replies)
  164. Solved: Copy, Open, Paste (6 replies)
  165. Solved: Identifying Duplicates Prior to Data Entry. (5 replies)
  166. GOBACK subroutine for Excel 2007 (2 replies)
  167. Solved: Email active worksheet using Outlook (2 replies)
  168. Solved: Copy From Multiple Files To One (6 replies)
  169. Solved: Error found in codes given in KB (13 replies)
  170. Excel WB painfully slow (4 replies)
  171. How to enumerate a variant array? (9 replies)
  172. Solved: error with mouse_down (2 replies)
  173. Sumdata based on a table of possible criteria (2 replies)
  174. MyCheck Fuction (4 replies)
  175. Solved: Automatically Update date in cell value if workbook is saved under a different name. (8 replies)
  176. Sleeper: Passing transformed arguments to UDF (10 replies)
  177. Troubleshoot an Overflow Error (17 replies)
  178. What is the code to open access file (2 replies)
  179. Solved: Creating a dynamic concatenation from a list (2 replies)
  180. Moving Files Based on Last Modified Date (9 replies)
  181. modify macro with hyperlink (2 replies)
  182. Solved: VBA Interaction with IE (4 replies)
  183. Paste onto filtered cells (1 replies)
  184. Conditional Formatting - Change font (2 replies)
  185. shade header row (2 replies)
  186. Solved: Fill an array with vlookup vba (5 replies)
  187. date range and return value (1 replies)
  188. Filter a sheet and copy results to another sheet (0 replies)
  189. Solved: Creating a dynamic user defined function (7 replies)
  190. Solved: Delete Duplicate Values only... Not rows (9 replies)
  191. [SLEEPER:] vba program (3 replies)
  192. Solved: Populate hyphen for continuous three or more zero in a row (4 replies)
  193. Solved: How to suppress replacing cells when using PasteSpecial? (6 replies)
  194. [SOLVED:] Index/Match VBA equivalent to append data (3 replies)
  195. Simple Merge of two lists/tables (2 replies)
  196. Macro to import entire text file into single cell (4 replies)
  197. alphanumerics only (7 replies)
  198. Real Time Clock in a Textbox on a Userform (2 replies)
  199. Solved: update pivot tables based on the value of cell 'C2' (2 replies)
  200. [SOLVED:] Determining the 2nd highest number in a list (3 replies)
  201. VB disable conditional formatting code (1 replies)
  202. How to create a sequence of dates? (1 replies)
  203. Copying sheets into new workbook (4 replies)
  204. simple auto macro :) (4 replies)
  205. getting the row numbers of visible rows in an filtered selection (3 replies)
  206. Using conditional formatting (5 replies)
  207. How to copy an active Excel worksheet to another excel file? (1 replies)
  208. Solved: Command Button (Save as PDF) (5 replies)
  209. Can somebody help to achieve following tasks? (1 replies)
  210. Worksheet on change code a bit slow (3 replies)
  211. Reference across sheets (1 replies)
  212. Insert and Delete Rows in Entire Workbook (8 replies)
  213. Solved: Stop watch in excel which just displays minutes (5 replies)
  214. FileSystemObject create file containing text copied from IE (2 replies)
  215. Getting Application defined error 1004 for vba (1 replies)
  216. Save as xlsm function (2 replies)
  217. Solved: Calculate Distribution (8 replies)
  218. find closest date (4 replies)
  219. Solved: Opening and writing to multiple ASCII text files (6 replies)
  220. Solved: Detecting Last Time File Was Opened (6 replies)
  221. Sleeper: Macro loop issues (2 replies)
  222. Macro Triggers Unreadable Content Error on Restart (2 replies)
  223. Macro is getting Runtime error 91 - why? (3 replies)
  224. Excel 2 XML using Macro (1 replies)
  225. Project locked for viewing - SendKeys? (32 replies)
  226. Solved: Loop through multiple sheets and delete rows based on a cell reference (4 replies)
  227. Accessing files in order of Date Last modified (1 replies)
  228. Solved: Dynamically populate combobox in userform (10 replies)
  229. Solved: function to find the number of iterations/loops Do...Loop (7 replies)
  230. Synchronizing Multiple Worksheets (1 replies)
  231. Solved: CAGR formula using only range as input (7 replies)
  232. VBA from Excel to Outlook 2010 help (2 replies)
  233. Master Directory Search (Needs A Tweak) (6 replies)
  234. Find all hard coded references (14 replies)
  235. Change Dropdown Macro (1 replies)
  236. Solved: code running too fast? (9 replies)
  237. Solved: run macro from one workbok to affect other workbook (3 replies)
  238. How to post sample excel data (1 replies)
  239. VBA Help - Desk sharing solution - thanks in advance (1 replies)
  240. Drop Down List to Copy Contents of Another Column into a Certain Column (4 replies)
  241. VBA pivot with no range (3 replies)
  242. VBA HELP! - Need slight change to my code (9 replies)
  243. Total values associated with unique value in adjacent column (5 replies)
  244. Solved: Converting the VB code to VBA. (6 replies)
  245. [SOLVED:] 3 cells USERFORM to enroll in one cell in excel (2 replies)
  246. Something odd has happened with an "Always on Top" window. (8 replies)
  247. Solved: VBA Copy a template sheet and paste it into multiple sheets (2 replies)
  248. Combine multiple rows into one and then seprate specific columns (1 replies)
  249. Adding MMM-YY to filename (1 replies)
  250. To paste in Word the selected text in webpage by an Excel macro (1 replies)