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. Need to Compare any Columns as given by user
  2. Solved: tricky copy and paste macro
  3. Master Formula
  4. Excell macro HELP PLEASE
  5. Replacing old vba code with new help
  6. Solved: Sheet Tabs
  7. How to detect IE modal window?
  8. Solved: Variable Named Ranges
  9. Solved: MaxRow . . . Where Is It Defined??
  10. Solved: Cycle through Collection of Check boxes
  11. automatically convert incorrect data
  12. listbox BeforeDropOrPaste event
  13. Search Entire Workbook
  14. Job Time Problem - further issue ??
  15. UserForm? question
  16. [SOLVED:] Select the lastrow using the active cell
  17. Open Excel file via Web Page with Arguments
  18. help with Int and Rnd
  19. Solved: Copy from one workbook to another
  20. Solved: help with vba
  21. functions in vba
  22. Solved: VBA Code for large number of cells in a range
  23. Solved: Adding a new item in menu bar
  24. Solved: macro to edit background colour
  25. [SOLVED:] Rows to Columns
  26. Solved: Declare 2 Named Ranges for Cell Properties
  27. delete one row of data
  28. Solved: Minutes and Seconds Validation
  29. Solved: Hyperlink as cell text in a range
  30. [SOLVED:] Range instead of Formula...
  31. Solved: Only do if not read only.
  32. Formula Help
  33. extract and compare data from text files through excel vba
  34. Fixing Size of Headers/Footers - print setup
  35. Assign Dynamic Colmumn Reference
  36. Data validation limitation: List source (Run-time error 1004)
  37. Solved: Run macro when spinner value changed
  38. macro to edit table rows
  39. Solved: date footer
  40. Using Vlookup in a userform to display data from search criteria?
  41. Hyperlink SubAddresses lost during Save As
  42. avoid outlook message
  43. Optimising Autofilter macro
  44. How to run excel module from javascripts?
  45. Restrict entry to text onlt
  46. [SOLVED:] Using Ranges with CountBlank
  47. Search Directory and Sub Folders Help
  48. Solved: Better understand macros
  49. [SOLVED:] Exiting Debugger when there's a constant stream of pop-ups
  50. Formula for finding text
  51. [SLEEPER:] macro tofind the least occurring numbers
  52. Solved: how do do i get my string to appear on the word document
  53. Out of Form
  54. Solved: Excel 2000 to 2003 compatibility issue with .Find
  55. Solved: Error with Date calculation
  56. [SOLVED:] Jump from a cell to another
  57. Solved: Help - Macro to convert column values into row values for various branches
  58. HELP!!! Very Important For-Next Loop
  59. use spreadsheet when running form
  60. Solved: macro to control rows in tables
  61. [SOLVED:] Macro to clear content and move data one column to the right
  62. Extracting Unique Rows based on multiple colunms
  63. class librarys
  64. Add extra step to current macro to reset table
  65. Solved: Renaming a Range
  66. Solved: Time format validation
  67. Value Paste Macro efficiency
  68. Solved: Run out of screen
  69. Solved: Writing one row to many rows depending of contents in column
  70. Solved: Deleting 0 (zero) from cells
  71. Help with charts
  72. Length of VBA line
  73. passing arguments to forms???
  74. Whats wrong with this code??
  75. Copying Pictures
  76. [SLEEPER:] Insert row by date
  77. Solved: VBA Worksheet Project
  78. Deactivated macros
  79. Solved: Moving Data from a form to Excel Spreadsheet
  80. Solved: Help with resize
  81. macro to copy and paste worksheet
  82. Solved: if & vlookup
  83. Using variable in property names
  84. Solved: Langauge problems
  85. VALIDATION PROBLEM
  86. cleaning up sheet/cell references
  87. Solved: Folder picker to output path chosen
  88. [SOLVED:] Transfering Data To Word
  89. VLookUP to Update List?
  90. Minimizing VBA user form window
  91. [SOLVED:] Building Word Documents based on Individual Excel Rows
  92. Goal Line in Bar Graph - Can't get it to work
  93. multiple freeze pains
  94. Hide rows based on data in visible columns only.
  95. Solved: Userform check boxes and controling them.
  96. Solved: Run-time Error '1004'
  97. Wildcard in loop 'until' condition
  98. [SOLVED:] Try Catch Block
  99. Solved: Macro to extract Word Info works in Word but NOT Excel
  100. writing a function
  101. Solved: Defining .csv-file as workbook
  102. Range.find
  103. Solved: Coding a button to activate action
  104. concatenate in conditional formatting?
  105. Solved: Current Timestamp "Now" funtion format change
  106. Solved: Test for a string in a active workbook name
  107. Solved: How do I do this without inputing it in a cell?
  108. Solved: How can you trigger on when the sheet is printed?
  109. Trick Validation of combo boxes using VBA.
  110. How to avoid gosth userforms on screen
  111. Turning data with dates into a chart
  112. Solved: How to check if Excel is run from REMOTE server
  113. Solved: How to create multiple files depending on column values
  114. Solved: Listbox selection change
  115. Help on Count
  116. Excel's Visual Basic Editor Window
  117. Solved: Problems with an Error Handler
  118. Solved: [SOLVED] List Files & Cell Values With Specific Sheet Names From ListBox
  119. Setting Application.ActivePrinter and .PrintForm
  120. Solved: VBA Copy and Paste Help
  121. VBA Code to reduce file size of Workbook
  122. Presenting a Pdf File on a user form
  123. [SOLVED:] Populate a textbox with the username
  124. Solved: Count help
  125. Solved: FORMATTING A CELL TO SHOW HR & MIN
  126. Solved: vlookup and copy data to spreadsheet
  127. Viewing a range of cells in Excel on a User Form
  128. Trouble with maximize and minimize button
  129. [SOLVED:] VBA DataGrid User Form
  130. hy , excel for match stats and scors
  131. UK Excel User Conference
  132. VBA Dictionary Key Order Fixed?
  133. Solved: Calendar Control question
  134. # in VB
  135. Solved: excel range
  136. Solved: form load event not working
  137. Solved: Call Folder Picker from Cell
  138. Solved: Copy Option Button Caption to Cell
  139. [SLEEPER:] Progress Bar Class Implementation
  140. Use multiple workbooks to one database with linking tables
  141. Solved: Shared network drive issue
  142. View worksheet as web page
  143. Solved: Input Box
  144. Need help with writing a program for importing data into Excel worksheet!
  145. Using ADO to connect multiple workbooks in a folder
  146. Solved: Better way to filter input?
  147. can a macro determine button that invoked it?
  148. Solved: Msgbox
  149. Using custom controls to call sub with argument
  150. Some Probably very basic VBA questions.
  151. Solved: Formula help needed
  152. Compare values in dedicated lists to values in pivottables.
  153. Excel Demds 120mb when starting
  154. [SOLVED:] Delete Duplicate Row
  155. Solved: Help with excel-Macro to open file from http-link
  156. Assistance with Formula please (VLOOKUP/IF)
  157. Sorting data from userform checkboxes
  158. How to use SavePicture
  159. Solved: Customizing How Word Displays Information from Excel
  160. Solved: Capture System Time
  161. create a reference to a copied worksheet
  162. Command Button click
  163. Picture Formatting
  164. Dim
  165. Counting based on multiple criteria
  166. Solved: Charts using vba, works with Excel 2007 but error with previous versions.
  167. Urgent help Run tiME error
  168. Solved: Make a list of unique names from columns on multiple sheets
  169. Multiple Worksheet Onto Summary Worksheet
  170. Solved: On Error
  171. Refresh HTML file BEFORE importing to workbook
  172. Capture the Certain text in excel
  173. Help needed with Filtering a Drop Down List
  174. How can I list out all the properties, method do not exist in Excel 2007
  175. Creating Combo Type Menu Bar
  176. Solved: How can I copy sheet 1 from multiple spreadsheets to one new workbook?
  177. Solved: Email an excel sheet range using outlook.
  178. Solved: Duplicates 2
  179. Solved: CopyFromRecordset without formatting
  180. sort by 4 criteria
  181. Modify Code
  182. Sleeper: Locate and Open Outlook
  183. Solved: Preserving Values in Custom Functions
  184. Solved: Checkbox
  185. Solved: Excel data backup to MS Access
  186. Solved: Do While
  187. eliminating dups on excel mailing list
  188. Solved: Conditional Formatting
  189. Solved: Copy from Datasheetview to clipboard
  190. Solved: A quite complex relation search macro (hard)
  191. Solved: Formatting Negative Numbers
  192. Solved: Adjust Screen Resolution
  193. Solved: Identify the Macro That Called Another Macro
  194. [SOLVED:] Alert message
  195. Solved: can you make command buttons look nice in excel?
  196. [SLEEPER:] Let user choose chart type
  197. Solved: CreateObject("Excel.Application") Problem
  198. Consolidating multiple work books in multiple folders to one worksheet
  199. Solved: Count a different cells depending on what colout the font is???
  200. Last Populated Row in Range
  201. [SOLVED:] Moving from one worksheet to another based on a cell value
  202. Complex task in Pivot Table
  203. Solved: Text box
  204. Solved: Excel - Variable Lookup
  205. Solved: change sheet
  206. auto fill button
  207. How to include a dash in my search - VBA?
  208. Solved: Using the RefEdit Control on a Userform
  209. Move row to different sheet on excel workbook based on a cell entry
  210. Solved: Excel ADODB worksheet
  211. Solved: Unprotect a worksheet
  212. Solved: DCOUNT Excel Funtion
  213. Paste as Value
  214. Chart code problem
  215. Column selection, inserting column, multiple workbook users
  216. Replacing data within one Sheet only
  217. macro for protecting cell value from deleting
  218. Solved: Breaking vbNewLine - Breaks - Too Many Continuous Lines
  219. Solved: Searh and edit record from listbox
  220. Solved: Allow workbook interaction while Form visible.
  221. Solved: Need help with a simple loop.
  222. Solved: Need help with adding Next year's month
  223. Solved: Error Handling Question
  224. help to eliminate repeated inputs
  225. Need code added to a button to list some numbers
  226. Solved: Calling code from multiple documents
  227. Solved: Macro Help
  228. PDF to Excel/CSV
  229. Frustrating
  230. Solved: Multiple users in excel 2007 enterprise
  231. SOLVED: Open a workbook and copy data into another
  232. evaluate multiple conditions
  233. How Can I?
  234. Import from Outlook Express
  235. Am I using .Find correctly?
  236. Solved: Problem with update sheet data via userform
  237. Solved: Add a timer to Macro
  238. Performance Improvement Tips Needed
  239. SOLVED: Dynamic Printing Range
  240. edit notepad
  241. Solved: Flashing command button
  242. Solved: creating files from dynamic sheet names
  243. find value and delete next row
  244. [SOLVED:] Excel Userform - Dynamic Controls - Type Mismatch?
  245. show ComboBox at target in sharedworkbook
  246. Solved: WS Name function
  247. Solved: How to get the filter criteria automatically in AutoFilter
  248. Splitting, Sorting and Sampling
  249. Solved: Inefficiencies of Multiple Sheets
  250. Solved: Type of Chart to Use