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