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. Adding Criteria to UDF functions
  2. Solved: Change value of one cell based on another cell (Tree logic)
  3. Solved: VBA create hyperlink
  4. average over several columns/spreadsheets
  5. Solved: VBA : multidimensional arrays to fill from a worksheet
  6. Solved: VBA: Extract Number from Cell
  7. Solved: VBA: Find next empty cell in a certain range
  8. Solved: How to find broken links
  9. Transfer zip code to another column
  10. Need Help: Updating dates monthly
  11. Solved: split cell based on a multiple delimiters list
  12. Solved: How to draw following plot is excel?
  13. Formula and Insert the Column problem
  14. ListView .finditem syntax
  15. Solved: Userform writing to worksheet
  16. Solved: Value Matching Validation
  17. Extract Application information
  18. Treat Several Columns as one in Pivot Report
  19. Solved: Shift rows to columns by condition
  20. Solved: If range has values then.....
  21. Test for Parenthesis at end of string
  22. Compiling Multiple XML Workbooks
  23. "Should Cost" Model template in Excel
  24. Trying to create a chart without a Legend
  25. sum then devide by a hundred
  26. basic syntax query
  27. Multiple nested arrays to fill from a worksheet
  28. VBA to extract information from Pivot Table
  29. SpaceChart plot does not show up
  30. Convert Sheet To PDF Before Emailing
  31. Solved: Can macro let user click to choose workbook
  32. vba open workbooks
  33. Solved: Lost Workbook
  34. Design of set up
  35. Solved: Simple error message
  36. vlookup probs
  37. VB Stopwatch Code
  38. For a website, are Excel scripts better than other programming language scripts?
  39. VBA to adjust print area based on UsedRange
  40. Solved: Excel chart
  41. VB Formula Assistance needed
  42. Solved: Okay, here is a wierd one for you!!!
  43. Run code when cell changes
  44. need VB solution for comparing trendlines
  45. Embeding HTML in Excel
  46. VB Button Code, HELP
  47. Controlling powerpoint from excel
  48. Solved: Getb Special Folders with Enums
  49. Solved: Correct method for a second FindThis criteria
  50. excel to powerpoint
  51. Drop down validation using array
  52. Excel VB Programing
  53. selecting a range from a user defined reference in another sheet
  54. VBA to perform specific instruction upon identification of duplicate entries
  55. anchor picture to cell
  56. Saving an activeworkbook as a time stamp
  57. Add dynamic subtotals and then hide all blank rows
  58. Moving files from one folder to another
  59. SPLIT TEXT BY MACROS
  60. VBA issue exporting Chart to Word
  61. Solved: changing cell value/mapping
  62. Input Line
  63. Data number, symbols, sectors
  64. Detect Change in Row . .
  65. Tough VBA data pulling from IE to Excel coding question
  66. Solved: ADO Assistance (Excel into Access) ('97 versions)
  67. Probably simple VBA issue
  68. Force users to enable macros in a workbook
  69. Solved: Filtering multiple worksheets based on master worksheet
  70. Time Out and auto close after expired time
  71. Solved: Creating directories from within excel?
  72. VBA to click OK in Javascript popup box?
  73. Solved: color code range
  74. List File Attributes of Directory and Sub-directories
  75. Conditional formatting question
  76. Problem with deleting empty cells
  77. Disable Cut, Copy, Paste
  78. Any way to prevent deleting a specific WS?
  79. VBA code to use a hyperlink to email file
  80. Vlookup problem
  81. Solved: ListFillRange from another workbook
  82. Solved: Adding a button to a commandbar (Excel '97)
  83. Solved: move cursor to row X in active column
  84. Solved: VLOOKUP problem
  85. test of KB code on Disable Cut, Copy, Paste
  86. Solved: Identify column or number
  87. Solved: Insert Image from Userform Commandbutton.
  88. Solved: Find Value in Column And Paste data into it
  89. Advice: Redefine type of variable
  90. refresh all on protected sheet
  91. dates in columns
  92. redefinition type in VBA
  93. Solved: Problem in personal worksheet
  94. Solved: Avoiding a <type mismatch> error using IsError ?
  95. Find maximum and minimum values each day
  96. Prevent variable from being initialized
  97. sumifs in VBA
  98. vlookup and hlookup on multiple criteria
  99. Write to text file question
  100. IF Formula
  101. [SOLVED:] Excel to World find Wholeword
  102. Two add-ins for one custom ribbon tab
  103. How to write a click event from a list box???
  104. Solved: Excel 2003: Disable screen refresh during intensive chart updating
  105. Excel Visible/Invisible
  106. Excel Chart
  107. Solved: Rearranging data
  108. Excel 2003 Query Sharepoint List
  109. Cycle thru worksheets and import shape according to dynamic values
  110. Excel Print Specific word document page
  111. Solved: How get TargetPath of .lnk or .url shortcut files?
  112. Solved: Protect UserForm but not module
  113. Help with USerForm Contain MultiPages
  114. Solved: Load IE to Excel Sheet
  115. Solved: 6 dependant drop down boxes
  116. [SLEEPER:] Prevent user from viewing the code
  117. Solved: make sure 2 values always equal
  118. Problem with hyperlink
  119. PDF all worksheets and print
  120. Using NORMSDIST() Function in VBA
  121. Adhoc SumIf on variable criteria
  122. Code help
  123. Solved: Can I insert a copied row with a macro?
  124. Solved: Test before paste special
  125. Solved: public functions
  126. Grey out menu item
  127. Solved: creating new workbook/searching for wkbook
  128. change code help
  129. [SOLVED:] Sort Sheets in ascending order
  130. VBA Project Password
  131. Solved: Visible Range after AutoFilter
  132. Strange problem with excel chart
  133. Solved: Soap: need refresher
  134. auto-complete scroll bar
  135. Converting number to text
  136. Solved: How can I return cell value via worksheet name
  137. Solved: Generate a random string of letters
  138. Dynamic Validation Not working?
  139. Solved: Macros across workbboks
  140. Solved: Setting Dynamic Print Range
  141. Solved: Fade Away Userform doesnt work properly when closing userform
  142. Clean the working mess
  143. Sleeper: Multiple pictures in one section in the header
  144. enter seperate cells in chart
  145. Opening File in VBA code
  146. Viewing VBA when passwd protected
  147. Referring to pasted shapes / pictures
  148. Read a Mainframe Dataset (PDS) using VBA
  149. Macro to Loop Through a Repetitive Task?
  150. Solved: 2007 Application.Quit
  151. Solved: Sheet Code is not working correctly
  152. Object-oriented programming in VBA
  153. Printing time period based on usr input.
  154. Solved: What formula or vba code for this case
  155. Solved: External Data Requery
  156. Solved: Extend range of cells from active cells
  157. VBA Running Excel 2003 when you have 2007 Installed
  158. Derived classes in VBA
  159. IMPORT *.LOG file into textbox + autosize
  160. Solved: Find, Cut, Move & Copy issue
  161. Solved: Prevent the user from bypassing Data Validation
  162. Folder/Subfolder list help.
  163. Solved: Prevent the user from seing some worksheets
  164. Solved: Subtracting Numbers with Sheets 1/2 data
  165. VBA help needed :(
  166. Solved: insert rows based on cell value
  167. A special calculation
  168. Enter seperate cells in chart
  169. Global Error Handling
  170. Solved: Highlight the line when certain cell is selected
  171. How to end unlimited cycle?
  172. Find last row, insert row retaining format of last line and repeat for named tabs
  173. Solved: Check if cell has data validation
  174. Print Multiple Sheets as Word Docs
  175. Functions can change some properties?
  176. Parse SAS LOG using RegExp
  177. Counting Data between Decades
  178. Solved: SOAP Action fails
  179. How to put together caption
  180. Sleeper: Distribution of data among employees
  181. How to construct VLOOKUP in VBA?
  182. help with "select method of range class failed"
  183. VBA userForm: changing images
  184. Excel VBA to check if multiple worksheets exist
  185. Solved: Run an access macro thru excel
  186. Solved: VBA to identify duplicate entry and insert row to other worksheet
  187. Sleeper: Using a UDF in Multiple Worksheets
  188. color grid
  189. Report to show >2 Instances of an Absence
  190. Hlookup
  191. What is the VBA code to enter text from a cell into a website's form?
  192. Solved: Text boxes
  193. How do I launch a program from Excel?
  194. Solved: How to copy only formats and formulas, not values
  195. Automatic Reconciliation
  196. Solved: Format code for multiple areas
  197. multiply value with 1 - optimization
  198. Formatting TextBox
  199. Solved: Problems converting date into required format
  200. Match function
  201. Solved: filtering on named ranges.
  202. Delete blank series from a XY Scatter Chart
  203. Solved: Insert set parts in list
  204. Combo Box question
  205. Worksheet_change
  206. Solved: Sort Data Help
  207. Solved: Excel Charts - Naming
  208. Solved: Array Help!
  209. Need help writing an Input Function
  210. Solved: Forms
  211. Solved: Solved Zoom in if specific cells are selected
  212. Solved: If Not fso.FileExists ?
  213. Solved: Hide button with associated row
  214. Solved: identify last row and change formula accordingly
  215. Solved: Delete a Worksheet Command Button
  216. Adding controls to a form at runtime
  217. Solved: Save changes to Add-in on application close
  218. Solved: save sheet to desktop with name from cell
  219. Solved: Combobox Colors
  220. Solved: Change based upon a cell value
  221. Solved: multiply values from a textbox and combobox in a userform
  222. Solved: Excel does not allow importing* accdb files
  223. Solved: Converting 3 Rows to 8 columns
  224. Solved: Code works without proper Dims, why?
  225. Soap Action Fails: redux and challenge
  226. Linking cells to sheets & Duplicate W/Sheets
  227. Could you give me an example of a VBA script that automates writing scripts?
  228. Solved: Where can I find some VBA scripts or related scripts such as VB & VBS?
  229. Solved: Looking for VBA resources?
  230. Solved: Macro is off... need help with copy & paste function
  231. how to count items in a column
  232. Questioner Form
  233. Excel and Bloomberg
  234. Solved: Coloring sheet tab conditionnally
  235. Solved: Move row to correct sheet if column V = "Y"
  236. How Sheet formulae is called
  237. [SOLVED:] Exporting data to Word
  238. FollowHyperlink
  239. Solved: Using Countif with multiple criteria
  240. Solved: dateserial format
  241. Solved: Minimize/Maximize Userform
  242. Solved: TextBox display columA & B
  243. Userform runs ok in VBA Editor, but not when started from macro in workbook
  244. Solved: Manipulate String based on Carriage Return
  245. Cost Forecast spreadsheet
  246. Solved: File IO low level functions -- not working
  247. Solved: Noob question
  248. Solved: Increment offset
  249. Solved: Creating a name range in one column
  250. Update Links in multiple workbooks