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