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

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