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