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. form fields in excel
  2. required fields based on IF statement
  3. Solved: how to swap firstname lastname in cell?
  4. Hyperlinks as result in Random Sample
  5. Excel VBA website content copy
  6. printarea with rectangles
  7. Changing the time zone
  8. Solved: User Defined Function not giving fresh results
  9. Stop skipping rows!!
  10. Solved: reduce size of macro
  11. Processing Time
  12. VBA Macro Code to Enter Intranet's Login/Pass?
  13. Drill Down
  14. Solved: edit macro cancel step
  15. Decimal value of characters in cell
  16. HELP macro to Delete Row based on two cells
  17. auto print
  18. Solved: Find, Copy Text from Word and paste in excel
  19. Solved: HELP Worksheet.CodeName is not consistent when copying a worksheet into a workbook
  20. Solved: simplifying formulae
  21. Solved: Showing IP Address
  22. Solved: VBA Speech References Library
  23. Solved: Inputbox method to pick a range in another workbook
  24. Find Names and copy to a new sheet
  25. Internet Explorer controls error
  26. Suppressing display of CUM line chart for future periods
  27. Error Importing XLS sheet into Access via VBA
  28. Copy Files in a folder into a single Master file.
  29. Solved: Exporting data to another Workbook
  30. Maddening, non-repeatable bug
  31. Solved: Sort adds an extra line
  32. Solved: An N-by-1 variant array throws runtime error when N gets down to 1
  33. Solved: Compare date before event execution?
  34. Solved: Close all but Activesheet
  35. Solved: Month and Day swap places when OK cmd button is pressed
  36. Solved: Variable Data with Date
  37. Self defined date format [$-130000]
  38. Solved: IF AND PROBLEM
  39. Solved: Open file path
  40. Copy Worksheet
  41. ctrl c and ctrl v breaks a merge cell
  42. ReDim Question
  43. Solved: Re-start the value if reached a value
  44. Solved: Iterate through columns
  45. Solved: Urgent: Application File Search
  46. populating a cell with value from another
  47. elimanate zero while taking minimum value
  48. Solved: Referencing using a number for column
  49. If 3 times greater than delete row
  50. Solved: Whats the value of y given X
  51. Solved: passing data from a list box to a spreadsheet
  52. Spreadsheet vlookup help.
  53. Solved: Calculating Height of a range
  54. Solved: Filling empty cells across workbooks with zero
  55. select multiple areas in a textbox
  56. count shapes
  57. Importing tables from multiple HTML files, into one spreadsheet. Please Help
  58. Using a worksheet as a database
  59. Copy cell from multiple sheets, into one row in one sheet
  60. Solved: VLOOKUP on multiple criteria
  61. A 'floating' rounded rectangle
  62. CombineFiles - Move instead of Copy
  63. Can I edit a source cell from the linked cell?
  64. Delete Rows Based on Current Date
  65. Solved: Is Insert > Name > Create evil?
  66. TextBox to Cell Freeze
  67. Solved: How to write VBA code to copy data from Word to Excel?
  68. Solved: How do I delete code from a sheet module under program control?
  69. VBA Code to pull selected data from a huge database
  70. Solved: Calculation not working
  71. Solved: Select Checkboxes in Internet Explorer
  72. Solved: running macro runs the wrong macro
  73. Solved: HELP with TRIM !!
  74. CSV Files & Userform Problem
  75. Solved: Unable to connect to Oracle
  76. Solved: Share a workbook without a prompt
  77. Solved: Workbooks(NewFN).Close SaveChanges:=False Index Issue
  78. Solved: Filling comboboxes with filtered data
  79. Sleeper: Implied do loop in excel write # statement
  80. Solved: How to Concatenate Text
  81. Solved: Set cell value from one workshee equal to found cell in another workbook
  82. Solved: OnExit
  83. [SOLVED:] Delete a specific record from an Excel VBA array?
  84. Function for of sum of square of mean deviation
  85. Help With MsgBox if duplicate range
  86. Solved: Writing data to a table in word from excel vba
  87. Listboxes - automatically unselecting themselves?!
  88. automatically scale pivot chart from highest to smallest
  89. How do I "install" custom functions
  90. chart update problem help!!
  91. OWC Spreadsheet Scrolling
  92. Solved: Workbook_Before Close problem
  93. Solved: add differenet worksheet names to current macro
  94. Solved: Copy Paste from workbook to workbook
  95. Solved: Do Loop until rowHeight is between two numbers
  96. Solved: Using arrow keys to navigate through userform fields
  97. Read and Write Binary Registry Keys
  98. Solved: need to add a macro on save
  99. [SOLVED:] Sort Multidimensional Array
  100. amend formula
  101. [SOLVED:] Compile error
  102. disable print screen
  103. Solved: sort will not sort - why?
  104. Solved: Save and encrypt sheets
  105. Solved: duplicate file & strip code from workbook
  106. Solved: Find Multiple Entries Then Delete Row
  107. Set default save path
  108. Unmerge cells & copy line from above
  109. Solved: Looping through a shapes listbox
  110. Solved: Need help easy formula
  111. [SLEEPER:] sum to the last column with data
  112. Lock cell after entry
  113. Solved: Enter today's date based on another cell
  114. [SOLVED:] Help with Case statement
  115. Solved: Can text be copied out of a cell to another cell?
  116. Solved: Merge Data between worksheet
  117. Solved: OnClick event
  118. Solved: Clean up of Custom Menu items
  119. Copy 2 sheets to Network and rename
  120. Solved: Ignore error without converting to number
  121. Solved: Multipage and combo box
  122. Solved: vba copy function
  123. Solved: Scheduling suggestions
  124. Worksheet Formulas and VBA
  125. [SOLVED:] Moving rows up and down a table with VBA
  126. how to run a sumif after formula
  127. CheckIn, CheckOut API's - general question
  128. Copy non blank rows from each workbook in a folder to current workbook under eachotha
  129. Solved: dynamic named ranges
  130. Solved:
  131. Solved: Confused about Workbooks object
  132. Ask for values and delete row
  133. Solved: Ask for values and save as
  134. Sleeper: Do copy macro
  135. Solved: Check if 2 Values Exist in 2 Columns
  136. Robin Hammond's Progress Bar?
  137. Userforms and Other Excel Application
  138. Need help on loop
  139. check my code pls
  140. vb help
  141. For/IF problem
  142. Solved: search for multiple characters in a cell
  143. Disable Copy Paste
  144. Setting checkboxes with Boolean effect
  145. Search as You Type ~~ Narrow down List
  146. Solved: Copy Paste Cell Value To Word as Text Only
  147. [SOLVED:] How to combine 6 different file(but same format) become one
  148. Solved: Excel to Word: A few issues on the Excel part of things
  149. Import data file
  150. Solved: formula not changing the row values accorrdingly
  151. Populating sheets with data from another sheet
  152. Solved: Compare two workbooks and count matches
  153. run time erro 424
  154. Solved: runtime error '1004' unable to set the formula property of the series class.
  155. [SOLVED:] Separate every 3 entries into 2 arrays? (or other solution)
  156. Auto shut down of spreadsheet if inactive.
  157. How to protect Excel Program more seriously?
  158. macro deleting important data in column F:EC
  159. Using Find to Search for a Date
  160. Voltage Ramp
  161. Solved: Store values meeting certain criteria and paste them into other area
  162. Implied Volatility
  163. Implements Keyword in VBA
  164. Solved: Capturing Error Message
  165. Color Backgrounds for Independant Cells
  166. Solved: Adapt code by Tom Ogilvy
  167. [SOLVED:] How to detect when the mouse leaves a control on a userform
  168. Matching variable formats
  169. Solved: Which column is the calling button (mostly) in?
  170. Solved: Controlling Dialog Boxes
  171. Solved: VBA- Smallest non-negative number in a range
  172. macros language help ?
  173. [SOLVED:] Referencing User Selected Workbooks
  174. Solved: Select Date Range
  175. Solved: Worksheet_Change and .PasteSpecial
  176. Sleeper: Identifying the optimal solution in an array
  177. Time Stamp VBA - Need help please!
  178. Solved: Drop-down for each cell under a column
  179. Solved: how to sum rows in columns with Sun
  180. Solved: VBA , min of 2 nox , >0
  181. [SLEEPER:] Replacement of IF function
  182. Solved: Colouring ranges based on data being entered by User
  183. Cant Shift date problem!
  184. [SOLVED:] How to format columns on 'Workbook Open'
  185. Solved: Excel insert rows based on value of previous row
  186. Solved: Selecting range of cells
  187. Issue with ActiveWorkbook.FollowHyperlink
  188. assign macro to tollbar buttons(excel2003)
  189. Solved: Finding last row of a column
  190. Solved: Run Userform via macro toolbar button
  191. Crash after add-in install
  192. Speed up calculation
  193. Solved: paste to last empty row and beyond
  194. Set Focus On Excel Instead Of Powerpoint
  195. Insert tabs in to an excel worksheet
  196. Autofill Rows with formula
  197. Solved: Filter unique values and count their frequency
  198. Solved: UDF Inserting Unwanted Quotation Marks
  199. VBA Check Cells - Easy but help!
  200. Solved: connect with access
  201. Solved: Show the next months Lists
  202. Solved: send active worksheet to outlook mail recipient as an attachment
  203. Solved: Really basic stuff
  204. Font Color Cell
  205. Solved: Application-defined or object-defined error - Len(c.Offset(0,-1).value)
  206. Solved: Error when I attempt to filter worksheet
  207. Solved: How to copy a dynamic range
  208. Solved: Delete Sheets in Add-in
  209. How To Count The Number Of Records Selected By AutoFilter
  210. Solved: Deleting Rows
  211. Help with autocomplete in textBoxes
  212. Solved: min of 2 nos, if positive
  213. Solved: MS Query on open workbook
  214. how run a sumif column name is true
  215. Solved: Delete the Row based on criteria
  216. Solved: How to Link two sets of ranges
  217. Solved: Autofill a column with text
  218. Excel search files
  219. Solved: How to merge Empty cells in a selection
  220. Solved: password lock a worksheet using a userform
  221. Email from excel
  222. Solved: Find Multiple Entries - Change Cell Value
  223. creating a folder then giving a user ID modify permissions to it
  224. Size chart to Word cell
  225. Solved: Namespace
  226. Solved: How to do arithmetic on addresses
  227. Solved: VBA Code . Max of 4 nos and min of 4 nos
  228. Solved: how to avoid LITTLE GREEN TRIANGLE error
  229. Function with circular reference - VBA
  230. Solved: Adding A "ScreenTip" or Pop-Up Message When A User Hovers Their Mouse Over An Image??
  231. payroll weekly time excel formula
  232. Solved: Calculating average based on some criterion
  233. [SOLVED:] Source and location function
  234. [SOLVED:] Add New sheet every day
  235. Record varying length of text in cells
  236. Solved: Undo a Hyperlink
  237. Cumulative % in Pivot
  238. Solved: Any way to retrieve deleted file
  239. Solved: Data Management In Excel - Theory/Design
  240. Solved: Hundreds of links on Multiple Sheets
  241. Solved: Auto Load Form when Excel Launches
  242. Autofilter/Delete Duplicates/Find Changes
  243. Opening/getting data from different excel file
  244. Solved: Merge Excel file through validation
  245. Consolidate data
  246. Solved: Scale graph absolutely
  247. Solved: Transpose column A to rows
  248. Solved: Adding worksheet to blank workbook
  249. Macro to search active cell value and look for it in word docs saved in a folder
  250. [SOLVED:] Using vlookup if the lookup value is not in the first column