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 167 168 169 170 171 172 173 174

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