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