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 162 163 164 165 166

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