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