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

  1. runtime error 438
  2. Solved: keeping log of all users
  3. Formula results in significant figures
  4. What do they mean these symbol
  5. web update and API interaction
  6. Select a column by matching the column heading content?
  7. To be sure looping through all the rows
  8. Looping through rows by colomn name?
  9. Change font in cell based on value
  10. 20 Second Wait tied into a Progress Bar
  11. excel2k FormatConditions question
  12. Problem with printing data from sheet to another
  13. Need differnt cell format from pivot table
  14. Solved: ActiveCell is current/horrible solution... need fix
  15. Solved: Hide/show column base on checkbox caption
  16. Yes/No Validation List with One Condition
  17. Deleting Blank Rows using VBA
  18. Finding Last Empty Cell
  19. To validate date format in Excel
  20. Solved: COUNTIF with multiple criteria
  21. finding the wordwarp charactere ?
  22. If Kill help
  23. Lost Password for Sheet Protection
  24. Hide all userforms that are open
  25. Solved: How to Detect a Time Entry
  26. Setting Value for Checkboxes
  27. How to return an array from a function ? And handle the result after ?
  28. Solved: spreadsheet formatting problems
  29. Keep track of value from another sheet base on time
  30. Password creation
  31. Solved: Two Passwords (User & Master)
  32. Generate list of dates
  33. navigate with scrollbar
  34. Solved: Open VBA Project from Excel Button
  35. select last sheet added
  36. VBA Code Delete Row
  37. Call macro pending on value
  38. What is wrong with this If statement?
  39. Solved: Why doesn't the dialog disappear
  40. Validating set of entries
  41. Solved: length of array
  42. Solved: Passing Worksheets
  43. Solved: userform not catching up
  44. Solved: sumif in vba
  45. Solved: AutoFilter Question
  46. Macro Adjustment
  47. Solved: Combine text data from 9 cells into 1 cell
  48. need help to get list
  49. VBA Open Dialogue Box to Select Multiple Files
  50. Solved: SQL error
  51. Night vs day working hours
  52. Solved: Import Multiple Tables
  53. Spreadsheet in dialog
  54. want to find max time & min time
  55. Disable menus / toolbars
  56. Question from a rookie VBA user
  57. Solved: parsing text & combinations
  58. Excel in Word
  59. Solved: Eliminate prompt
  60. Resize button control when clicked
  61. Pivot table to org chart
  62. Delete Rows from a Range
  63. Solved: better Array support??? to avoid Dim, ReDim, Preserve etc
  64. Error if file exists
  65. A quick copy/paste question
  66. Drop down data validation list
  67. Solved: Run two macros from one button
  68. Solved: SQL JOIN error
  69. Solved: Question regarding Filter function
  70. vlookup error?
  71. Format Cell by Left Click- On and Off
  72. Automation Error?
  73. Solved: using two values from a list box
  74. Solved: check for empty cells
  75. Importing an excel file into a template excel sheet that will enable automation
  76. Solved: Copy and Paste to an Active Cell on a Different Worksheet
  77. need loop code
  78. copy excel to word
  79. heybd_event Info
  80. Sumif and Sumproduct According to Multiple Criteria Function
  81. handle to IE to populate data
  82. Saving data to Access databse
  83. Cell Formatting VBA Help
  84. Help: How to pop-up plot point description when mouse cover
  85. spreadsheet 10 control
  86. Solved: Updating values in worksheet from CSV Files
  87. row and column headers
  88. Advice: Determine Excel in Edit Mode
  89. Forum Rules and HTML Help
  90. Newby-Putting together price build up for quotes
  91. Solved: Count unique numbers
  92. Solved: Copy and paste worksheets to a new workbook, minus the formulas
  93. Solved: NUMBER STORED AS TEXT
  94. Expand a financial statement
  95. Solved: Verify pre-requisites BEFORE running macro
  96. Copying,Pasting,Looping, Confusing!!!
  97. Check to see if add-in installed
  98. Multiple Cells Appear Active
  99. Solved: Pivot Table problem
  100. Org Chart problem
  101. Solved: Passing listview control value
  102. All charts in same sheet
  103. Last Row
  104. Solved: Mapping cells from column to column with UID?
  105. Solved: Need help modifying this code
  106. Solved: Error in Sumproduct
  107. Solved: Help with VBA code
  108. Application.ontime discover
  109. Open/Activate other Excel files from one
  110. Open/Activate other Excel files from one
  111. multiple workbooks with application.ontime
  112. EXCEL VBA
  113. Someone can help me out with writing a simple function??
  114. Resize elements of an org chart
  115. Dynamic Name Range in chart code
  116. excel to access w/ vba
  117. send email
  118. Solved: Sum If I think
  119. Solved: HELP me figure out how to use the formula commands
  120. How to copy many values...comparing with smae values
  121. VBA to copy .txt file
  122. Adjust UserForm Show Location on the Screen
  123. Solved: Limit Blinking Text To 30 Seconds
  124. VLookup with dynamic Filename
  125. Solved: Turning Off Email safety in VBA?
  126. Solved: Dialog Sheets
  127. Removing Close Button on UserForm Caption Bar
  128. Solved: countif
  129. Need help with Import and exporting a file
  130. count a filtered sheet
  131. Solved: VBA Help with Chr(13) problems
  132. Solved: macro slows down each time
  133. Solved: difference between activate and select
  134. Solved: format memory
  135. Solved: application.volatile
  136. Solved: email recipients
  137. Validating a column Head
  138. Scroll through worksheets using spinbutton
  139. Solved: Can a Constant be used as function parameter?
  140. Solved: Drop Down Menu to Display Other Sheets
  141. Function for validating a column name and length of entries
  142. Combine array with lookup in VB
  143. Solved: set reference to addin using code
  144. KB Article not running
  145. Solved: Copying non-sortable data into a new location in a new order
  146. Remove formula / Hardcode Data
  147. Printing All File formats using VBA
  148. Solved: multiple subtotals problem
  149. Search Criteria in User form (VBA- Excel)
  150. Interface Error
  151. Solved: 2003 Excel Listbox ? saving multiple selections
  152. Checkbox code
  153. Color Worksheet Tabs
  154. Solved: What is the mistake in this code
  155. Read current .Find Method settings
  156. peraphs impossible... order line base color...
  157. Open a database using vba
  158. Row VBA questions.
  159. Find Function Fail on Three-Four Letter Words
  160. Axis feature: how to switch off "crosses between categories"
  161. how to automate geocoding & maping
  162. Application.FileSearch query
  163. VBA : select all workbooks and Global FIND/ REPLACE
  164. Solved: Range Copy problem
  165. Solved: Alter code for macro to all worksheets for duplicates
  166. Disable Save from Ctrl S
  167. How to determine that category axis is related to time?
  168. Page Break Help please
  169. Solved: Filtered results to userform listbox problems!
  170. How to quickly count number of lines in a CSV or Text File?
  171. Need Macro to convert formula to value
  172. Solved: Keep date look in the result of a formula
  173. What is wrong with my code?
  174. Solved: What is wrong with my Validation code?
  175. Solved: UserForm Help needed
  176. SELECT A EXCEL ROW USING MACRO VBA
  177. Need userform to perform search and calculate
  178. ComboBox - Highlight default when userform loads
  179. Help me please
  180. Solved: Find Then Unhide Help
  181. Change Tabs in the Ribbon
  182. Solved: Help with Chart Lines
  183. Solved: Problems calculating static dates.
  184. Why Data Validation is not working?
  185. Seach Worksheet Names and Return Data
  186. Embedded Ppt in Excel Doc
  187. Filter Top 3 and display them in another sheet
  188. Assign Formula to Chart Sheet Text Box (migrating from Excel 2003 to Excel 2007)
  189. Changing an existing formatting macro
  190. Sheets Selection Through Combobox
  191. Solved: Delete Code After Copy
  192. Macro Edit
  193. custom random array
  194. Excel VBS SQL Code Problem
  195. Format with different colors
  196. VBA: how to interpret this code?
  197. Email, CSV, VBA
  198. Solved: Parsing?RegEx? Finding 1st character after 2nd Dash "-"
  199. Solved: Reduce x number of 'with' loops using code to update ranges from userform entries?
  200. Solved: Problem in Month days Calculation
  201. vlookup maybe ?
  202. Increase of the EXCEL.EXE memory
  203. comparing dates in vba
  204. Disable all textboxes in a userform
  205. Row Search & paste string
  206. Solved: Store a sequence of numbers in an array and recall them as required.
  207. Final Row help
  208. Need help with this Function code
  209. Need help with this Function code
  210. Solved: Save a sheet in workbook to a specific folder automatically
  211. Solved: Looking for a KB
  212. Solved: How to determine the axis title width?
  213. Add-in question
  214. Alternate row colours within a Listbox
  215. vb statement
  216. Solved: Retrieve value from chart data label
  217. Solved: Returning the Path of a Shortcut as a String
  218. Just checking the month
  219. Solved: Find and convert unix timestamps
  220. GUID for Excel 2007
  221. Tell VBA script to look for info in a cell
  222. Save As Location
  223. Multiple Filter
  224. Macro to add sequential WS and update summary
  225. Format entire column
  226. VBA Cell Format based on In-Cell Formula Result
  227. Copy specific data
  228. Solved: Copy data from multiple worksheets in a workbook
  229. Solved: Force users to enable macros in a workbook
  230. Solved: colornumber in excell
  231. How to auto log-in into IP Address using vba
  232. Counting Dates
  233. Please Help in Converting Excel spreadsheet to access 2003 table
  234. Solved: Triple Value Check Boxes
  235. Solved: Problem with save texts of UserForm.ListBox
  236. sort worksheets by tabcolor
  237. How to Make CountA Function Not to Count Hidden columns data
  238. Searching for a Consensus sequence
  239. Do Not Refresh
  240. How do I ignore Saturdays and Sundays with Autofilter?
  241. Exporting an Excel file to a text file with format .txt
  242. Need remote control vba help for my classroom
  243. Help: How to update all imported data in Excel
  244. Bind a key to a macro
  245. delete all comments
  246. Solved: copying ROW numbers into an array
  247. Critical Path Analysis
  248. Solved: Newb to vba need help with trig
  249. compare 1 out of 1,600,000
  250. Variable scope