PDA

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

  1. Solved: VBA to import files to sheets
  2. Excel Advanced Filter
  3. Solved: unload userform before worksheet deactivate
  4. Edit Work Sheet Whilst Msg Box Remains Open
  5. Solved: Unable to delete custom toolbar created in excel 2003.
  6. Add blank row after each record
  7. Solved: Autoconstruct Forecast Formula from Linest function based on number of variables
  8. find unknown values which adds up to some values
  9. vba cursor in textbox
  10. Email macro failing
  11. Solved: Macro with a Formula to rename sheets
  12. Solved: Unable to set the property of the Series Class
  13. New worksheet ...help pls
  14. Business day only
  15. Validation On Columns
  16. Solved: Insert a column based on columns header
  17. Solved: VBA and FTP
  18. Howto repeat/cycle code through all populated cells in column
  19. A Macro to replace a matching row in a block of cells
  20. Solved: Pick email address from cell in workbook
  21. Solved: Copy paste special different worksheet to Summary
  22. Solved: Option Button in a Protected Worksheet
  23. Start Excel 2007 with an empty worksheet
  24. Data storage problem
  25. Solved: CopyToRange then delete duplicate
  26. Solved: A way to avoid charting blank cells?
  27. Solved: Compile Error - Variable Not Defined
  28. Solved: Consolidating & Cleaning Data - Is there a better way to Do it?
  29. Importing Recordset to Access?
  30. Conditional statement in a macro
  31. Solved: search for string, write coordinate to variable
  32. VBA Tab Reference
  33. Solved: Dynamically Expand Validation Dropdown List
  34. Solved: Inventory report
  35. Solved: Deleting name ranges (xl '97)
  36. Solved: Combining workbooks then selective worksheets
  37. Solved: Assistance with email SendTo (xl '97)
  38. Multiple GoalSeek macro: Runtime error '1004': Reference not valid.
  39. accessing outlook global address book
  40. Insert multiple rows-Delete Rows with formulas
  41. Solved: Insert formulas macro
  42. List of Files in Directory - Almost works
  43. Showing a userform, but not stopping code
  44. Solved: Colour of multipage headers
  45. Solved: Copy Macro that Won't Copy :(
  46. Highlight cells which have no dependents
  47. Retrieve the Path of MouseIcon Picture
  48. Solved: Code that runs automatically when a dropdown object selection changes
  49. Solved: function to extract chars from string using VBA
  50. Solved: VBA -Clearing the dropdown cells
  51. Solved: Toggle:Hide/Unhide Columns on 2 separate sheets
  52. Counting business days
  53. Solved: Macro to create a Table using individual sheets totals as the input
  54. Solved: Removing duplicates from filter
  55. Solved: Loop through worksheet and delete rows inbetween 2 search criteria
  56. Use data in txt file in Case Select statement
  57. Solved: VBA SQL statement (xl '97)
  58. Solved: Macro to Insert Entire Rows
  59. Solved: Concatention Problem
  60. Allocated Day Off (ADO) coding- VBA HELP
  61. Solved: Create folder structure
  62. Manipulating Plots in Macro
  63. Help needed - Memory leak in VBA script
  64. Solved: Look for word then copy and paste row
  65. Solved: Next without For error
  66. Collections Overflow
  67. Solved: Macro not selecting correct sheet
  68. Solved: Absolute Row, Relative Column Refernce VBA
  69. File Details - Need correct syntax
  70. Create Workspace issues
  71. Solved: Sorting a non-active sheet
  72. VB code for cell linked to multiple selection list box
  73. Subtotal, Find Max and apply rules using Macro
  74. Macro to run at change of cell value without hitting enter key
  75. Disable a Checkbox with VBA depending on linked cell
  76. Solved: Script with cells.find returns wrong values compared to VLOOKUP
  77. Worksheet Change - Target Range & changes to more than one other cell
  78. Solved: Merging Sheets of Data
  79. Macro only sorts 1 column
  80. Sum amounts of field on multiple records
  81. Solved: VBA to Delete Column based on Header
  82. Solved: can anyone see what's wrong with this?
  83. Solved: Macro to Sum 2 cells of the Lastrow on another sheet
  84. Solved: Need to remove duplicates based on date in an input box
  85. Solved: My Userform loading takes time
  86. Modify default size of insert comment
  87. Solved: Teacher needs help in randomizing an answer into one of 4 multiple choice columns
  88. Solved: Moving Data
  89. Solved: macro to convert all txt files in a folder to excel files
  90. Button to import cells from another spreadsheet
  91. Solved: Teacher needs help in evaluating some simple math text equations
  92. Solved: Enter Formula on Multiple Locations using Macros
  93. Question in logic
  94. Excel - Date formula and Row Highlighting
  95. Colour cell dependent on condition
  96. Worksheets.Calculate not updating worksheet!
  97. Currency format from VBA
  98. Filtering and copying
  99. Solved: auto-open and populate
  100. Solved: Proper syntax for writing a user defined function?
  101. Directory Listing doesn't get ZIP files
  102. Solved: Odd behaviour of UserForms
  103. Manipulating Data for Graph creation
  104. Executing an external application with Excel
  105. Solved: Find column with a value and replace it with another column
  106. Solved: Can't loop through worksheets
  107. Formatting numbers within formulas
  108. Solved: case to line 1 locks up
  109. Check Box Formula
  110. Solved: Place Date stamp on Chart
  111. Solved: pull excel workbook into excel template
  112. Solved: Extract hyperlink from cell and place in cell to right
  113. Solved: Lookup values in varying locations?
  114. Solved: Move to end of data in Column in different worksheet
  115. Solved: customize sort
  116. Solved: Add to end of cell
  117. Print Macro using validated list
  118. sum of different cells in 20 different workbook-sheets
  119. Solved: Fill empty cell with previous value if condition is met
  120. Solved: Accumulate the values
  121. combo box -no edit
  122. Solved: hyperlinks() syntax
  123. Solved: DateAdd Function
  124. Data Validation
  125. Solved: Sort without selecting the Sheet
  126. Run Code after Automatic Refresh
  127. Solved: Count click events then add value to label
  128. Group and ungroup certain rows in a protected sheets
  129. Possible Vlookup, or Index/Match or...
  130. Data Import MAcro
  131. Retrieving pixel counts in Excel sheet charts
  132. changing sheet name and issues that go along with this...
  133. Data Validation and Formatting Question
  134. Display an array from one field.
  135. VBA Copy and Paste HELP
  136. Search box within data entry form
  137. Solved: Time Sheet Help!!
  138. Need to compare 2 very large worksheets
  139. Solved: Go to next row 1st column when cell selected
  140. Data Validation
  141. Solved: Presence of a Chart Sheet causes VBA to erro
  142. Challenge: Triangle Area Select tool
  143. Solved: 2 codes with ambigous names, HELP
  144. VBA for excel
  145. End Loop after submitBtnClick
  146. Creating strongly typed array - Is this possible??
  147. run code after finishing web query load
  148. Solved: How to add a text column to a dynamic range using a macro
  149. Solved: Save As Pop up issue
  150. Add range of rows at the last row
  151. Solved: Determine name of caller procedure
  152. Solved: Method 'Range' of object '_Worksheet' failed when that worksheet is not active.
  153. Solved: Average Difference with Date:Time Format
  154. Solved: Conditional Formatting on Spreadsheet
  155. Using a repeating bottom row as a footer
  156. Solved: Can I use VBA or DataVal with symbols?
  157. Solved: Adding Time with 30 minutes interval
  158. Solved: Macro in a Toggle Button
  159. retrieve names from external file
  160. Find cells with like values & automatically sum them
  161. DSUM Formula
  162. Solved: Message Box in Macros with variables
  163. Excel to Internet Explorer Google Search
  164. Problem with loop & variable values
  165. Need to get web page elements and info
  166. Solved: Write a vba variable out to a sheet
  167. Solved: Toggle:Hide/Unhide Issue with calling a module
  168. Solved: Lookin for values between workbooks and get the details
  169. Solved: VBA: Copy Worksheets to new Workbook & Rename Tabs from Vlookup
  170. Solved: Turn txtbox on an off
  171. Evaluate() to return column number
  172. Save an excel file got from a '.do' script automatically
  173. show source of value
  174. Solved: Required to copy and paste a formula to a column range
  175. AutoSum an unknown range
  176. Solved: How to auto populate data from Worksheet
  177. Excel - Data Validation Lists
  178. Solved: Counting rows?
  179. Solved: Before Save Prompt Userform
  180. How to copy from Column A2 to the last populated Column.
  181. how to use an input box to create a formula
  182. Solved: VBA to create Charts for several sheets with different data lengths
  183. Selecting a picture
  184. Moving Forms
  185. Shapes as a Toggle Button?
  186. Solved: Extract Data from multi worksheets
  187. CountIF statement
  188. Cells.find works but found info is not copied
  189. new to vba
  190. disable menu items
  191. Adding zeros to numbers entered
  192. Solved: Insert/Delete Row Code Issue
  193. The last date of use
  194. Solved: Change Code Modules and Userforms
  195. Solved: Sort worksheets using a Range as the Sort Order
  196. Solved: Macros to be disabled on the workbook
  197. Change multiple worksheet names based on cell values.
  198. Switch to a specific open application
  199. Average with vba
  200. Solved: Userform & enabling textboxes
  201. Solved: Select case statement problem
  202. Solved: Recordset Seek method issues
  203. Need VBA help - coming up with runtime error when remote users run a macro
  204. Cells Index
  205. Creating a userform to perform a search function
  206. assign values next to the last used cell
  207. Solved: Excel formula needed for if or countif or both
  208. To open Another Excel in a different Window using code
  209. VBA Advanced Filter
  210. Solved: VBA to Delete rows using IsError
  211. Solved: VBA Hiding Unused Cells
  212. Solved: AutoFill Active Cell
  213. Insert-Delete Rows with Formulas Error
  214. Excel Data to Word Labels
  215. Auto calculate active worksheet
  216. Solved: Join an array and join a Range
  217. export/update from excel workbook to access database file
  218. Enable copy and paste
  219. Force an opening workbook to open in an alternate instance of Excel
  220. Solved: Random Numbers Repeating
  221. Solved: Search column a for value select and past rows to next sheet
  222. Solved: IF Statement Help
  223. Solved: UserForm, Passing Variable (Excel '97)
  224. dynamically merging cells in different rows based on the position on the worksheet
  225. Solved: Code not summing properly
  226. Userform Problems
  227. Updating duplicate worksheet
  228. Solved: sort dates
  229. Solved: Addin Command Bar Not Loading
  230. Solved: Dependent in Invoicing
  231. Solved: 50% Excel, 50%Outlook, 100% fail
  232. Solved: find same value in two different lists and copy cells in new sheet
  233. Solved: find same value in two different lists and copy rows in new sheet
  234. How to Get the Name of Executing Macro
  235. Solved: Excel/Access - SQL statement - WHERE/AND (Office '97)
  236. Solved: How to validate data in a userform prior to the data being transferred to a worksheet
  237. A really annoying Loop, Help please!
  238. long data type in ADO recordset
  239. Solved: Message while running macros
  240. Help Opening Embedded Word File
  241. Solved: Hide rows
  242. Solved: Update a Word TOC from Excel VBA
  243. Solved: VBA to Save a workbook with an incrementing Version Number
  244. Excel UDF Error - Connecting to SPSS
  245. Reformat Data with Macro
  246. Solved: Save a document with today's date in a macro
  247. Changing Cell Value Code
  248. 2007 title bar
  249. Solved: Save document with new filename, close it and re-open original file
  250. Macro letting the user decide where to save the file (and decide the filename)