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