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

  1. [SOLVED:] data cleanup from program
  2. [SLEEPER:] Match or Lookup commands
  3. [SLEEPER:] Comparing two worksheets with a twist
  4. [SOLVED:] Conditional sort and concatenate
  5. [SOLVED:] Restricting Save Priveliges
  6. [SOLVED:] Reducing the code if possible
  7. [SOLVED:] I know I am asking alot but I'm lost
  8. [SOLVED:] Match two columns
  9. [SOLVED:] Delete Hidden Columns
  10. [SOLVED:] Automate Responses to Message Boxes and Input Boxes
  11. [SOLVED:] Form value in cell not included in formula
  12. Advice: Excel to Access DB
  13. [SOLVED:] Question on my Timesheet Tool
  14. [SOLVED:] Search By Region
  15. [SLEEPER:] Import, Skip Duplicate Records
  16. Changing Cell Reference to Sheet Name via Formula
  17. [SOLVED:] Automatic Reference to Outlook 9.0 Object Library
  18. [SOLVED:] Forcing a Save As
  19. [SOLVED:] Automation Error - Object invoked has disc . . . .
  20. [SOLVED:] Printing formulas (on your printer!)
  21. Solved: UK Random Lottery Challenge!
  22. [SOLVED:] Recorded Macro Lost
  23. [SOLVED:] Help Help
  24. [SOLVED:] "OnAction" problem
  25. [SOLVED:] Very strange
  26. [SOLVED:] A test to see if an entire range is empty
  27. [SOLVED:] Userform variable
  28. [SOLVED:] Restrict characters
  29. Sleeper: Excel VBA and HTML pages
  30. Sleeper: Rationalize my import / export code
  31. [SOLVED:] Blocking Alphabetical Entries into Textboxes
  32. Solved: Data Validation in xl 2000
  33. [SOLVED:] Header rows
  34. [SOLVED:] Colour Cells depending on time
  35. [SOLVED:] OLE action warning message
  36. Sleeper: why??????????
  37. [SOLVED:] Programmatic validation client disconnect error
  38. [SOLVED:] Transpose every line
  39. Sleeper: Cannot remove Open password from workbook
  40. [SOLVED:] Add Sheet Based On Value
  41. [SLEEPER:] When references stop... referencing
  42. [SOLVED:] Excel multi Combo Box Problem..
  43. [SOLVED:] Data from userform to worksheet
  44. [SOLVED:] Open a file(s)
  45. [SOLVED:] Search & cell reference
  46. Sleeping: Selecting Hidden Cells & Auto fill
  47. [SOLVED:] Using a combo box as an input box
  48. [SOLVED:] Some Answers I have gotten Here
  49. Sleeper: What screen resolution do you run Excel in
  50. [SOLVED:] excel memory problem?
  51. Sleeper: FlexGrid Control, list box
  52. [SOLVED:] Selecting a dynamic range using code
  53. Sleeper: Creating a template "Installer"
  54. [SOLVED:] Variable Print Header
  55. [SOLVED:] List box to populate,command button to highlight & delete
  56. Sleeper: Strange Error Message for Digital Signature
  57. [SOLVED:] Import from Outlook to Excel
  58. [SOLVED:] Outlook Global Address List (GAL) ..
  59. [SOLVED:] GetObject not working
  60. Sleeper: VLOOKUP?
  61. [SOLVED:] Calendar control
  62. [SOLVED:] Conditional Compare Needed/Sort by Color
  63. Sleeper: Ghost during the scroll...
  64. [SOLVED:] lists boxes and more
  65. Sleeper: drawing tool
  66. [SOLVED:] Timesheet Question
  67. [SOLVED:] A Different Type of "Timesheet" Query
  68. [SOLVED:] 2 drop down menus or data val? or a combination!
  69. Sleeper: Calculate number of pages per office
  70. [SOLVED:] Trouble with conditional format for entire column
  71. [SOLVED:] Paste Special Question
  72. [SOLVED:] Help with userform combobox and Excel
  73. [SOLVED:] Clear Contents Leaving Formulae Intact
  74. [SOLVED:] Cell reference in worksheet formula???
  75. [SOLVED:] data val box with more than 1 column data
  76. [SOLVED:] Opening workbooks
  77. [SOLVED:] Delete if Cells are blank
  78. [SOLVED:] Deselecting cells
  79. [SOLVED:] Ghost 2 the return
  80. [SOLVED:] Skip if cell is filled - tab to next blank cell
  81. [SOLVED:] UserForm for input date & time
  82. [SOLVED:] Printing Workbooks with certain criteria
  83. Sleeper: This is crazy - References completely non-functional
  84. [SOLVED:] Calendar control to pick date
  85. [SOLVED:] VBA code Paste Link into PPT
  86. Get username w/ API
  87. [SOLVED:] names in text box
  88. [SOLVED:] Import rules for text files
  89. Solved: Search engine
  90. Sleeper: summarizing data from 7 sheets
  91. [SOLVED:] How does a macro check for cell (fill) colour?
  92. [SOLVED:] How to select non-contingous cells
  93. Sleeper: SHIFT OR MOVE Cells On The Right...
  94. [SOLVED:] Return text from a TextBox
  95. [SOLVED:] Pivot Table question
  96. [SOLVED:] .HasPassword property
  97. Sleeper: ORDERING...
  98. [SOLVED:] Save problem
  99. [SLEEPER:] How do I get an OLEObjects check box to call a function when clicked? (VBA)
  100. [SOLVED:] Listing Names of Subs & Functions
  101. [SOLVED:] Declare a Constant Array
  102. [SOLVED:] Conditional formatting help needed
  103. [SOLVED:] Beginners question
  104. [SOLVED:] VBA Update Code
  105. [SOLVED:] Open Word from Excel
  106. Sleeper: If Row is Selected question
  107. [SOLVED:] Picture, changes with list selection
  108. Sleeper: More Form help needed
  109. [SOLVED:] How to work with every cell in an array?
  110. Sleeper: Automate adding radio buttons ?
  111. [SOLVED:] multi-column list box
  112. Advice: Runtime error message
  113. [SOLVED:] Automate a column
  114. [SOLVED:] Forcing a value in textbox before allowing closing?
  115. [SOLVED:] Userform Search Option
  116. [SOLVED:] msgbox help
  117. [SOLVED:] Update Readonly.
  118. [SOLVED:] Disable worksheet copy
  119. [SOLVED:] Relation between two or more "Sub"
  120. [SOLVED:] Help!!! I've screwed up my Excel!
  121. [SOLVED:] Find-Change-Delete
  122. [SOLVED:] Trying to place values in a sheet
  123. Advice: Security of VBA project
  124. Sleeper: User form help
  125. [SOLVED:] Animation Error
  126. Sleeper: One last piece of the pie
  127. [SOLVED:] Excel 97 help / SaveCopyAs
  128. [SOLVED:] Array Base
  129. Sleeper: MSComm1.ComPort = 1 won't debug.
  130. [SOLVED:] Find Value?
  131. [SOLVED:] Call Program problem
  132. Sleeper: Connecting to SQL
  133. [SOLVED:] Query/Search and Display
  134. [SOLVED:] Help with macro
  135. [SOLVED:] User Form Help Again
  136. [SOLVED:] File Save As
  137. [SOLVED:] Clear contents only
  138. [SOLVED:] The proper way
  139. [SOLVED:] Clear then Recreate existing toolbars?
  140. [SOLVED:] Unloading Splash Screen
  141. [SOLVED:] VBA Conditional Format Every Other Row
  142. Sleeper: couple of Problems
  143. [SOLVED:] Removing spaces
  144. [SOLVED:] Help with index and match
  145. [SOLVED:] Clear Textbox with more than 256 characters
  146. [SOLVED:] Creating Summary Workbook from Multiple Workbooks
  147. [SOLVED:] Better Style for Code
  148. [SOLVED:] Counting data occurances between two non-adjacent columns
  149. Solved: Matching by columns entered
  150. [SOLVED:] Altering closed workbooks.
  151. [SOLVED:] Multiple messages
  152. [SOLVED:] Select Case Problem
  153. [SOLVED:] Deleting empty rows with a twist
  154. [SOLVED:] Using a Cell Value as a counter limit
  155. [SOLVED:] Strange VBE - problem
  156. Sleeper: Calendar Object Destination Cell Formatting
  157. [SOLVED:] Array Question - look for duplicates
  158. [SOLVED:] Mutlipage UserForm Referencing
  159. Sleeper: Unique Array Help / Code cleanup wanted
  160. [SOLVED:] Looping Through Sheets Clearing Cells
  161. [SOLVED:] Making an AddIn ( Requirements )
  162. [SOLVED:] Outta Sight Cell Comments
  163. [SOLVED:] Missing Microsoft Common Dialog Control
  164. [SOLVED:] Importing text to columns
  165. [SOLVED:] Help with userform
  166. [SOLVED:] Sheet Protection
  167. [SOLVED:] Custom menu
  168. [SOLVED:] How to get a dropdown box working
  169. Sleeper: Searching Web Data
  170. [SOLVED:] Search for todays date
  171. [SOLVED:] Excel formula re: last entry
  172. [SOLVED:] Compare two sheets
  173. Sleeper: Copy multiple non-contiguous selections to other workbook
  174. [SOLVED:] Finding from till end
  175. Sleeper: Formula will not see both columns
  176. Sleeper: Naming a range and subdividing it
  177. [SOLVED:] Is there a way to call up....
  178. Sleeper: Combo Box Range problem
  179. Sleeper: MAcro Range Help
  180. [SOLVED:] Transparent Form Buttons
  181. [SOLVED:] beginner here.
  182. [SOLVED:] Check if workbook is already open
  183. [SOLVED:] AutoFill Question
  184. Sleeper: Filtered Dropdowns
  185. [SOLVED:] Select range of class error
  186. [SOLVED:] Counter Help
  187. [SOLVED:] Any Suggestion on how to improve?
  188. [SOLVED:] Matching Problem
  189. [SOLVED:] Input cells restriction
  190. [SOLVED:] Unhighlight cells
  191. [SOLVED:] ActiveX Listbox control Index
  192. [SOLVED:] Adjusting code
  193. [SOLVED:] Macro housing
  194. Advice: Help with a macro to insert and delete rows
  195. [SOLVED:] Frame Caption
  196. [SOLVED:] Can font color or fill color trigger an event?
  197. [SOLVED:] Select Multiple Columns using Column Number
  198. Sleeper: Run Time Error
  199. [SOLVED:] How to make this into VARIABLE
  200. [SOLVED:] Extract Last Name From A Cell
  201. [SOLVED:] Error Handling
  202. [SOLVED:] Checking for an Empty Row
  203. [SOLVED:] Need help with counters
  204. [SOLVED:] How to Paste info from an Excel Macro into a new word document
  205. [SOLVED:] Combining two cells into One
  206. [SOLVED:] Number format in Pivot Tables
  207. [SOLVED:] Next empty Range (Row)
  208. [SOLVED:] Check values on different sheets
  209. [SOLVED:] Next empty Dynamic row
  210. Sleeper: Need to modify this Routine
  211. [SOLVED:] Unhiding spreadsheets upon meeting a condition
  212. [SOLVED:] Send data to a floppy disk.
  213. [SOLVED:] VLOOKUP help
  214. [SOLVED:] Code review please
  215. [SOLVED:] xl 2000 Page Setup User Defined Paper Size
  216. [SOLVED:] Changing Date Format's
  217. [SOLVED:] Externall call
  218. [SOLVED:] Removing unwanted rows
  219. [SOLVED:] Error on Open Workbook
  220. Sleeper: Print User Form
  221. [SOLVED:] Problem with vba routine
  222. [SOLVED:] FIND function in a macro
  223. [SOLVED:] Clear selection from listbox
  224. [SOLVED:] Auto Filter problem
  225. Sleeper: SQL Query
  226. [SOLVED:] Excel and Option Boxes
  227. [SOLVED:] Range and Selection question
  228. [SOLVED:] filling in cells in multiple spreadsheets?
  229. [SOLVED:] User Defined type
  230. [SOLVED:] Getting a cell's defined name
  231. [SOLVED:] Advanced cell search... ?
  232. [SOLVED:] Save As path help
  233. [SOLVED:] Data transfer to ListBox
  234. [SOLVED:] Copy Active Sheet to new workbook
  235. [SOLVED:] Import/Export Sheet Modules
  236. [SOLVED:] Copy range from column to column
  237. [SOLVED:] Personal.xla is MIA
  238. [SOLVED:] Running an Add-in
  239. [SOLVED:] xldown is giving me an error
  240. [SOLVED:] Web Control in a User Form
  241. [SOLVED:] Searching the Directory (Windows Explorer)
  242. [SOLVED:] Populating A cell with the users name
  243. [SOLVED:] Copy and paste from a filtered list...
  244. [SOLVED:] So simple I'm ashamed to post
  245. [SOLVED:] Sorting numbers in a single cell
  246. [SOLVED:] Time Limit?
  247. Sleeper: Smart Tags
  248. [SOLVED:] Two Listbox
  249. [SOLVED:] Advice needed! scope considerations...
  250. [SOLVED:] Tree View Control in a UserForm