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