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: Line to close simple window
  2. Auto populate drop down box
  3. form - fullscreen
  4. Solved: search for first blank cell then paste clip board across sheets
  5. Paste selection as Message Body
  6. Solved: Set page as default tab
  7. Solved: how to define the cells?
  8. Solved: Defining a specific cell range
  9. Solved: Getting TextBox to display multiple Vlookup's on Combobox change?
  10. Two Parameters in a web query
  11. help altering recorded code please
  12. Solved: Show if no setting
  13. Solved: Conditional Formating by VBA creates its own condition
  14. Solved: Workbook links need password
  15. Cut & Paste Error, Excel Hang?
  16. Solved: Allow user to set Percentage
  17. How to modify only visible cells
  18. Solved: Formula for incrementing a number in the middle of text?
  19. switch to a .exe installer
  20. Color picker
  21. Excel 97 & 2000 Compatibility??
  22. Solved: Vlookup + ISBLANK?
  23. Solved: Capture picture, save to folder and create hyperlink in cell?
  24. Solved: Allow users to set default save directory.
  25. Solved: Convert chart into a insert comment picture
  26. Solved: CheckBox
  27. delete form
  28. How to Create folder in Web/sharepoint
  29. Solved: InStr Error when using .Comment.Text
  30. VBA Help
  31. Help with speeding up a macro
  32. how to autoadjust the size of a cell in a worksheet?
  33. This code errors out
  34. Collecting list of Photos and hyperlinking to them?
  35. Solved: Combine Non-Contiguous Ranges Hide Col.
  36. Use cell value to search for a file & Copy/Paste?
  37. Advice: Extract Embed Flash file in Excel / Word
  38. an empty textbox in a formula
  39. Solved: Macro to Email Excel workbook
  40. Solved: VLookup problem when using QueryTables.Add
  41. Entering a date between 2 parameters
  42. Solved: Text box Date Calculation Error - Type Mismatch
  43. Solved: Delete Rows based on Criteria
  44. Solved: HOw to make a dynamic bar diagram?
  45. When "idle" Excel workbook opens Visual Basic Editor
  46. Progress bar indicater
  47. Solved: set User Names to an array
  48. Solved: Copying unsorted data to a sorted order in a new sheet
  49. Issues showing userform with Excel 2000 (service pack 3)
  50. Use icon from network drive for desktop shortcut
  51. I want my macro to do the same thing in 25 folders...
  52. Dont allow users to select same in List Boxes
  53. Solved: Formula Results are #N/A because od no data
  54. Help: Seperate data and insert new rows
  55. Hiding sheet after copy same sheet into new workbook
  56. Extract Access Table Names
  57. Solved: Click Cell Insert Check Mark
  58. Solved: Formula error
  59. Sleeper: VBA cut-and-paste code stopped working 100%?
  60. print colour
  61. print-out time
  62. Sum using match feature with multiple criteria
  63. Solved: Textbox Format Value
  64. VBA Help
  65. AutoFit of Merged Cells
  66. Solved: Please help to alter some existing code
  67. Solved: Vlookup formula for unique entries in lists in cells in range?
  68. Solved: Case Select
  69. Solved: Can a form have data referred to another sheet
  70. Return List of Folders Containing a Specific Word
  71. Solved: Sorting Multi Arrays
  72. Solved: List Box question that I can't find answer to
  73. Solved: How to Search the Latest Date in a Worksheet
  74. Solved: Worksheet Protection Vs Macro
  75. Solved: excel/outlook create a "line-break"
  76. Solved: How To Automaticly Close A Workbook If Nothing Changed In 15 Minutes?
  77. Truncating Array Results in a List Box
  78. Sleeper: Msgbox automatically clicks yes
  79. chk and paste the range
  80. Solved: Next Row in Spreadsheet
  81. Solved: Anybody know how to speed up subtotals?
  82. Solved: Selection.End Complile Error: Method or Data Member not Found
  83. Multiple users
  84. Advice how to edit values in non-contig. range
  85. Updating data in summary sheet
  86. Form Help
  87. Connecting To A Database Without The Local Machines Odbc
  88. Email Selection
  89. Solved: Form Help
  90. Auto_open failure
  91. Using ActiveX Objects in Excel
  92. Procedurally generated checkbox code
  93. Help Setting which workbook a Macro will run
  94. Merged Columns
  95. checkdic as dictionary
  96. Solved: ListBox Columnwith
  97. problem in a form
  98. [SOLVED:] Only allowing values to be copied between certain dates?
  99. Help with making code more flexible
  100. Form List Help
  101. Solved: Is there any tooltiptext in excel?
  102. Solved: Sub Menu in My Custom Menu
  103. Solved: Build list of sheet names and create cell validation?
  104. Excel to SQL Connection?
  105. Transferring to VB.net
  106. Conditional Copy of Data using the macro
  107. [SOLVED:] Display Picture in frame on userform follwing hyperlink?
  108. Solved: Shorten this VBA code
  109. Solved: Mask in form
  110. Solved: If value "tick mark" then ...
  111. Locking embeded word object in excel
  112. Solved: variables in formulas
  113. copy range to diffrent book
  114. same code does not workon diffrent sheet with same type of data
  115. Solved: Versatile Form
  116. Running a macro for any workbook/worksheet
  117. Coding of userform
  118. Save Workbook on Webpage
  119. Solved: Trimming "Leading" spaces from cells in VBA?
  120. Solved: printing a dynamic named range problem with non contiguous data?
  121. Solved: Email code crashes if workbook isn't saved
  122. Prevent two network users from opening same workbook?
  123. Userform to Macro
  124. Solved: Adding Txt Boxes in Form
  125. Solved: More than 2 criteria - possible??
  126. Solved: Combining cells using a function key
  127. Userform, Textbox data validation
  128. Telephone Dial
  129. Solved: how to empty combobox?
  130. loop that add lines alternately
  131. Solved: Run Time error 1004
  132. Solved: Save As
  133. Simple Filter
  134. Copying Custom Menu to another Computer
  135. Solved: Set Slider to Current Year
  136. "Picture too large/truncated" error?
  137. If-Then
  138. Found some interesting code:
  139. Interactive selection of worksheet and range
  140. Copy certain range from the sheet matching conditions
  141. Run time error '1004':Select method of worksheet class failed
  142. Solved: Locate max number from column A
  143. Date Wise Max code
  144. Macro to generate documents from database
  145. Solved: Make list boxes visible=False
  146. Querying from Access
  147. Solved: Thinking outside the Square
  148. Header Problem with "text CC F&B"
  149. Formula in a Control
  150. Solved: Worksheet_Calculate event
  151. If Txtbox equals Chr then Show Image
  152. Calling a UserForm when a user clicks a cell
  153. BeforeDoubleClick Event
  154. Extracting max & min values with a condition
  155. UserForm Concept help
  156. Search a Userform Listbox for matching text from another Listbox
  157. Solved: Web browser control
  158. Search for the string and move the cells accordingly
  159. Solved: Cut from Word and paste in Excel
  160. Solved: Help with this code?
  161. Solved: Downloading XLS files from Web page
  162. Calculate doesn't seem to do anything
  163. Sleeper: Advance Filter with command button
  164. how to define color of the cell by coding
  165. open worksheet
  166. Named Ranges in Excel VBA
  167. Solved: simple problem im sure
  168. Solved: Internal rate of return Function
  169. Auto Filter
  170. Solved: Please Help - Major Problem
  171. Solved: Version Control
  172. copy and paste to new row
  173. send Registry Settings with email
  174. Help... I am so lost
  175. Getting data from diferent files in same Folder
  176. Solved: Formula to Script
  177. Checking Textboxes
  178. Solved: Analog Clock
  179. Solved: Help AutoFilter 2 criteria at one time
  180. macro to print payslips
  181. Removing Toolbar etc
  182. Solved: Writing to VBE crashes Excel
  183. USER FORM - lots of small problems - PLEASE HELP!
  184. Check and Transpose
  185. Solved: Problem With A Text Box On A Chart
  186. Tabulation Form
  187. Removing #na from excel cell
  188. Printing Comments
  189. Solved: Match two criteria and display offsets? worksheet function
  190. Sporadic Error 1004 when creating a pivot table
  191. Controling WebBrowser font size
  192. Form vb change help
  193. Solved: AddItem help
  194. Solved: Combining Arrays
  195. Referencing a Workbook
  196. Solved: Search Excel File and populate Web page
  197. Reading a csv file using vba excel!
  198. Consolidated Messages/Strings
  199. Transfer Data From Excel to Access Table
  200. Addin to display under a menu
  201. Solved: Copy Columns and paste in different sequence
  202. Solved: how to use match property of the worksheetfunction class?
  203. Solved: Cut and copy new approach
  204. Solved: Vlookup loop
  205. Solved: conditional formating offset
  206. Solved: apply end of cell to paste
  207. Solved: Copy Data that meets criteria
  208. Solved: A Loop To Create A Worksheet Formula
  209. Solved: Form to Spreadsheet problem
  210. Solved: Two versions of one project -- oops!
  211. Tick appropriate box
  212. Userform vs controls in worksheet
  213. Solved: multipage page selection?
  214. Error 400
  215. Solved: Loop Help
  216. how to show 4 digit number
  217. subtotal at pagebreak
  218. Show todate as default
  219. msgBox with a Text Box Input
  220. Allow user to set Button Caption
  221. Private Sub userform_load()????
  222. event driven actions in repsonse to data
  223. Solved: loop, find value and replace assistance
  224. Solved: Print Prompt For Form
  225. SUM(IF across multiple sheets in another workbook
  226. [SOLVED:] I need fixed decimal
  227. macro to set expiry date
  228. Phone dialer sheet is attached
  229. Solved: Mixed Date formats
  230. very simple one
  231. Form If Statement
  232. currency in a concatenated string
  233. import outlook calender automaticly using vb
  234. Solved: TOOLBAR -> HELP!
  235. Extracting multiple max & min values from a column
  236. Solved: conditional format date
  237. Range format
  238. Drop down query
  239. Userform to do Filter Mode
  240. Userform to use a PIVOT
  241. Solved: If a cell is full
  242. User form and tab key
  243. Extracting Word From String...
  244. Solved: Indirect reference for form controls
  245. Deleting Rows w/ specifics datas
  246. Copy updated sheet from closed workbook
  247. Solved: Auto_Open/Auto_Close
  248. Insert alternative rows
  249. Run-time error method ' ' of object ' ' fail
  250. macros cannot be found