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

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