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 a Picture or Object Color using cell values
  2. Importing From txt File
  3. checking that a user entered decimal number in textbox is only upto 4 decimal places
  4. Creating a Login Form
  5. Application.EnableEvents problem
  6. [SLEEPER:] Close Wbk-a and open Wbk-b
  7. Lookup data from many sheet and Skip blank
  8. Solved: Convert Date
  9. Force Macro + Other Applications
  10. Solved: MATCHROW = 0 > HIGLIGHT
  11. add alert to txt if criteria met
  12. [SOLVED:] Grid combination logic problem
  13. Macro To Add Grades Into System
  14. How do you make a clickable button without creating a form?
  15. Sync Pivot Tables
  16. Amend Macro Store Info In Different Places
  17. need a save as text macro with delimiter
  18. Solved: match / lookup to code table on different sheet
  19. Filling a range of cells using a VBA function
  20. Solved: Getting data from other sheet with if statement and somprodukt
  21. Solved: *Automatically Unprotect & Protect sheet - Macro command button
  22. Solved: Apply code only to column A
  23. Debugging - Show workbook if code running on memory?
  24. Replace and sort macro
  25. Run a macro on a different wbk
  26. Solved: Automatically import a .bas module
  27. email results
  28. Solved: Collates data from many sheets to Master sheet
  29. Little Regex Problem
  30. Solved: Help: Run-time error '1004': Application-defined or object defined error
  31. Creating a folder with cell contents
  32. If statement logic question
  33. Solved: Loop that works on all sheets in workbook
  34. Moving range to onther sheetbase on cell value
  35. how came wb close by module showing in VBAProject window?
  36. Solved: updating data from another workbook
  37. Listbox selection criteria report
  38. Solved: Displaying - 0 - while using VBA
  39. Automatically move cursor if value exist
  40. Exclude Sat & Sun while calcualting due date
  41. Solved: Resizing Array
  42. Not able to access elements from a webpage
  43. How to compare two sheets
  44. Set Formula and Notify if changed
  45. [SOLVED:] VB Code to Copy a table and place it in an email.
  46. Text Import Code crashes at same record
  47. Getting data from different sheet and sort and sum
  48. [SOLVED:] If statement based on active worksheet Index Name
  49. Solved: Listbox+rangecopy+concatenate
  50. Copy Prices (with conditions - VBA) from one workbook to another
  51. Solved: Vlookup with an Index & Match formula
  52. Solved: Getting External Data From Web
  53. Help with Solver in VBA (range related)
  54. Reading a text file
  55. Need Help in creating a movie list catalogue
  56. Disable Cut, Copy, Paste Request
  57. Excel 2007 - Can vba display the MenuFloaties mini toolbar?
  58. Solved: Arrange sheet by name in between other sheets
  59. [SOLVED:] Topic - Help Debugging Code : Placing a range in the body of an email.
  60. User Form
  61. Search data and return latest status based on date & time
  62. Solved: cancel ESC key
  63. File Size comparison by VBA
  64. Solved: Button to Copy & Move to another sheet ERROR
  65. Putting selected cells data into one cell
  66. [SOLVED:] Clean up Sort
  67. Automatic Creation of combobox
  68. How can we update the date in a cell when we modify a text cell?
  69. How to get help quickly - and keep getting it.
  70. Solved: New Excel files based on Cell values
  71. Rearrange Excel Sheet to uploadable File for SQL Server
  72. Solved: Merge data as value without formatting
  73. Delete data from Pivot Table
  74. Solved: Conditional Output to Pre-Formatted Worksheet
  75. pull letter above after subtotal
  76. [SLEEPER:] User Defined Function - Mtwo = 2X
  77. [SOLVED:] Need to count rows in the copied range, or rows in the clipborad
  78. Small problems with generating a Bubble Chart in VBA
  79. Workbook Open/Before Close events
  80. Solved: Formula for count by day and hour
  81. Solved: Need to limit choices for the save as name.
  82. Solved: Excel2007 .RemoveDuplicates
  83. looping results
  84. Deducting amount of time (hrs) from a date and time stamp (dd:mm:yy hh:mm:ss)
  85. User Defined Function - Payment(mode, price)
  86. Solved: Create a sound
  87. VBA Lookup Errors
  88. Macro Slows with the same data...
  89. [SLEEPER:] Why does my code not work Internet Explorer
  90. Run-time error 1004 trying to select cells
  91. Copy/Paste Macro issue
  92. Solved: Calling a function from a worksheet formula
  93. Solved: How to combined Modul
  94. HELP needed with VBA MMULT
  95. driving hours
  96. Solved: prevent textbox selection without disabling it
  97. Solved: Someone hide the codes?
  98. Solved: Test Large Change
  99. Store data and put them on a new sheet?
  100. Help to modify code
  101. Delete everything on sheet except?
  102. Solved: How do you set up this simple array?
  103. copy worksheet and values
  104. Solved: Radio button is not working - variable not defined
  105. [SOLVED:] After filtering row16 down, fill row10 with top visible row. If no results do nothing
  106. Lost Shortcut functionality
  107. Frame visible properties
  108. Columns in ListView
  109. Find Data in a table and enter =now into a certain cell
  110. Solved: Alternate for INDEX/MATCH
  111. Setting ws name
  112. Looping through a bunch of text files
  113. Change Graph data range
  114. Open internet at workbook open
  115. Need help with modifying this array
  116. Easiest way to write greater or less than?
  117. If / Instr command to change variable
  118. Solved: Modify code to close workbook if opened on wrong computer
  119. MsgBox - Displaying two values
  120. Solved: Show date and time in a message box
  121. Search for blank cell based on two conditions
  122. Solved: Need to set textbox to the width between Column 1 and column 24
  123. Protecting Excel Workbook
  124. Solved: passing an array to a class
  125. Save as Macro
  126. Solved: COUNTIF using multiple criteria
  127. Solved: if user keys a specific word in cell
  128. Solved: Dump Call Stack
  129. Solved: Creating a textbox in each cell of the active row range Column 1 to 24
  130. Solved: Selection Change Event only if Row Selected Changes.
  131. Solved: What code lanuages does Excel 2010 understand?
  132. Solved: Permission Denied renaming Textbox if name in the thousand's in 2003 - ok in 2007
  133. vba I/O text
  134. Solved: skip value with error
  135. Solved: Copy and rename sheet in different name
  136. Solved: custom class - multiple values for an attribute
  137. Help in combining multiple spreadsheets
  138. Solved: Select a Sheet in another Workbook
  139. Custom Formatting For Two Numbers in a Column
  140. How to find 2 reference point and grab info where they intersect
  141. Connecting to Oracle Database
  142. VBA for Highlighting
  143. Gmail Macro
  144. Mathematical Calculation "at which point - specific percentage could be achieved"
  145. Need empty recordset for almost complete code
  146. Rearrange columns
  147. XML help needed
  148. Solved: Error Handling Help
  149. Sum text after grouping
  150. Extend the msgbox wider?
  151. Custom sort modification
  152. Solved: do...loop statement
  153. [SLEEPER:] Application.onkey
  154. Copy Two Columns into one column
  155. Solved: Finding and manipulating cell ranges
  156. Solved: select folder bij list
  157. Solved: Chart Macro
  158. Disable print button in worksheet command bar - Excel 2007
  159. [SLEEPER:] Problem with File picker
  160. Solved: Link button to PayPal
  161. Copy & paste
  162. Solved: set printer to 2 copies automatically
  163. Sleeper: Excel Reverting to all values
  164. Solved: Help with formula to divide number into 4 cells
  165. Solved: Ontime event
  166. Solved: Set all sheets to pagebreak preview.
  167. multiple ranges to if statement
  168. kill wkb & close excel
  169. Monitor cell for change
  170. Module class and form Listed in VBA without folders
  171. Randomly Generate text in cells from a combined range of cells
  172. [SOLVED:] Macro Tweak
  173. Solved: VLookup Code Error in form - Runtime Error 1004
  174. Solved: Tweak Macro Not To Eliminate Numbers
  175. Drag & Drop?
  176. Solved: Clear sheet only if File is selected
  177. Solved: SPECIAL NUMBERING
  178. Text String Joiner Macro
  179. Solved: Flashing text
  180. Solved: space bar
  181. Vlookup for multiple instances
  182. Solved: SUMIF not working =:(
  183. Solved: If file is open, can the Thisworkbook open event save a copy and leave it open?
  184. How to Populate Userform Labels from a Range
  185. Solved: VBA to Save PowerPoint
  186. SelectionChange Select Current Row of Range and Lock
  187. How to get rid of these dead macros?
  188. Detect Conditional Compilation Setting via code
  189. click paypal button
  190. odd or even
  191. Unhide column without selecting sheet
  192. Solved: Search for date in range and return cell address
  193. Practice Problems
  194. Solved: When closing Workbook repeated message "Do you want to save?"
  195. print files form dialog
  196. visual Queue in excel
  197. Solved: Screen / Worksheet Refresh
  198. index match help
  199. Solved: IF...ELSE...THEN LOOP HELP Please Help!
  200. Solved: One Script for Multiple Worksheets
  201. Solved: Insert year into cell
  202. Is Late-binding possible in VBA?
  203. Solved: Conditionally moving cell contents
  204. VBA application terminates when Control events are added programaticly
  205. help understanding code
  206. Forex Rates from a Java Applet
  207. Solved: dynamic list
  208. msgBox to naming folder
  209. Link Cell to MS Project % Complete
  210. Pause blinking caption
  211. Updating Inventory
  212. Edit Feature in Userform
  213. Radio button, activate, highlight cells?
  214. Accessing Outlook Contacts / Categories
  215. Make a button transparent?
  216. Solved: Flash Border Line
  217. Solved: Radio button is not working.
  218. Automated Functions
  219. connect Excel to AS/400
  220. moving sheets
  221. How to get out of 'Excel is waiting for another appplication...'
  222. Have sound embedded in VBA file?
  223. Solved: Clearcontents in a row
  224. Solved: Activate Macro When Sheet is Opened?
  225. How to hide a Button
  226. Solved: If Then Statement
  227. Solved: Boolean Working?
  228. Copy/paste a local file into PowerPoint
  229. Solved: Is the coordinate system inside a chart area different than outside.
  230. multiple form
  231. Right-Click on Toolbar button
  232. [SLEEPER:] Add a condition
  233. combining vlookup & hlookup
  234. Using an IF statement with multiples
  235. Return Value with color
  236. Solved: A code to write TXT file
  237. an active sheet save as copy
  238. Merge workbook to single workbook
  239. Solved: Error Handler
  240. Dual Monitor Setting in VBA
  241. hiding button when save
  242. Macro code only working on first 2 pages of Worksheet
  243. [SOLVED:] Adding same items to combo boxes on multiple sheets
  244. error help
  245. lookup
  246. Solved: Insert text from last row
  247. External File Processor
  248. link excel to word letter
  249. Getting time-stamp every 5 seconds
  250. Solved: 2007 Menus