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

  1. Solved: Could you please help me to use VBA for random name
  2. help: export to csv
  3. Remove double quotes in text (csv) file
  4. Check for open file.
  5. Find in different workbook
  6. Solved: Insert A Row
  7. Problems with Worksheet_SelectionChange
  8. Date array function has type mismatch error
  9. Help inserting a new row into several worksheets and copy formula
  10. Counting entries between dates using sumproduct?
  11. Solved: Need a msgbox to report to me the missing record number
  12. How to get variables numbers from array of numbers
  13. Validaing Userform Input
  14. Solved: How can I prevent Button Double clicks?
  15. Searching a keyword in a pdf file from excel using vba
  16. save a single sheet filedialogbox
  17. URGENT HELP REQUIRED
  18. Check shared file open.
  19. Text file read/write.
  20. Solved: Import text from Excel to a PDF file
  21. Displaying Total CMD Button
  22. VBA Macro to split cells at every ";"
  23. Remove hundreds of empty rows
  24. Solved: Copy Tab from close workbook into an open workbook
  25. To consolidate master data from different worksheets
  26. Populating Combobox list from listbox entries
  27. Creating a folder in the drive
  28. unzipped worksheet - protection
  29. Creating Charts using VBA
  30. Store selected ranges address in sheet
  31. Nesting Complex IF Statements
  32. Solved: Comparing two sheets. - I've seen code here before that I like, but I can't find
  33. Run sub when sheet is activated
  34. Excel data table filtering - need help
  35. Excel UK Developers Conference 2012
  36. NUMBER ARRANGER
  37. Solved: Comment filling
  38. Solved: UserForm - Need Help!
  39. multiple target address
  40. Validate Email in a Excel Cell
  41. Load | Delimited file into Sheet3 of the excel workbook
  42. Solved: Apply Row 16 cell formats to all rows
  43. Quick Case Statement
  44. Auto Update VBA Project
  45. Solved: keybd_event API missing information on User Form
  46. Little help with Visual Basics
  47. Can anyone crack this file?
  48. Cut cells and move
  49. application.undo
  50. Euro Sign wont work
  51. match data and return datalength
  52. My VBA code takes 4 hours to run
  53. Excel VBA Shopping Cart
  54. find last used row but not include formula that returns blank
  55. errror message
  56. VBA Coding window highlights text red and then deletes
  57. Forgot on Solved: Insert A Row
  58. "countif" in multiple worksheets using VBA
  59. Solved: Paste data with adding spaces between letters
  60. Unload UserForm resets project
  61. Solved: find string in column A and past used range of row to sheet 2
  62. Checking Columns for Numbers
  63. concatenate a range of cells with header values
  64. Solved: Looping around a userform textbox
  65. Pass TextBox Value to Access Query
  66. Solved: Can I create an Array from 1 to AutoFilter.Range.Columns.Count
  67. Looking up Records
  68. Solved: Help to include network drive when browsing for file location
  69. Concatenate Multiple Rows
  70. Solved: Fill Blank Cells with Value to the Left
  71. Formatting dates
  72. Cells with values
  73. Solved: string split for date
  74. Looking for functions: IsUserPressingAMouseButton / IsUserPressingAKey
  75. Solved: Reduce Numbers Down To A Specific Value
  76. how to store arbitrary selection area to two-dim array
  77. Error Box help
  78. Solved: Writ data to Excel problem
  79. Solved: Code stops?
  80. URGENT: APPEND DATA
  81. Find all occurance of cell value from another work book
  82. Sheet/Tab Copy Limit?
  83. pulling data from different reports into master workbook
  84. Solved: Print Selected Cells to Another Cell
  85. Compare 2 Columns of Excel Sheet
  86. Have txtBox search results populated in listbox
  87. Solved: Occasional filter\sort on worksheet_change glitch
  88. Is this possible with VBA?
  89. Solved: Select File from Form
  90. inputbox cancel
  91. Solved: Find & Replace Letter At End Of Number Only
  92. Problem on closing userform with API handles
  93. Solved: insert space in a string after n characters
  94. Solved: combobox1.value (as YYYY) - 1
  95. Solved: Dynamic Range based on Heading
  96. Code to edit data and to save as a text file.
  97. Volatile Functions and closed workbooks.
  98. Search
  99. workbook link ref cell
  100. Clicking on a Chart Point
  101. Internet Form with Dropdown List using Java/Ajax
  102. Pivot table with data validation reference
  103. Hidden game?
  104. Solved: Combine VB Code
  105. copy a color of font and cell of conditionally fomatted cell
  106. save a workbook and giving it an initial file name based on a cell value
  107. First and Last Bit of GetAsyncKeyState
  108. Hide empty rows
  109. Solved: Selection.Find error
  110. Excel Java and HTML :x
  111. Solved: Networkdays #name? error
  112. Solved: Insert Value of Selected cells to another Cells
  113. Solved: Splash Screen UserForm time delay and dll issues?!
  114. Importing a defined range from another sheet and then grouping/Sorting
  115. Code to Determine The Largest Number From Different Groups of Numbers
  116. Charting from Range assigned using Cells method!?
  117. Basic Arithmetic doesn't work?!
  118. Get Workbook Index from VBA
  119. Pasting a range of cells in Sheet Header
  120. Solved: Problem Moving Data
  121. Run-time error '1004'
  122. Solved: Step on through the code
  123. Inserting a new Column in Pivot Table
  124. Solved: Workbook_BeforeClose
  125. How to delete columns using VBA excel?
  126. Solved: WORKDAY in cell returning wrong Workday?
  127. Solved: Searching for a Value and Highlighting if Found
  128. VBA Excel Chart to PowerPoint
  129. Input box size
  130. Help needed to create a function or vba code for this process
  131. How to Create several buttons dynamically in my own Ms-Excel Plugin DYnamically
  132. Create a moveable button in own MS-EXCEL PLUGIN
  133. Solved: Application OK only in Excel 2000 or earlier
  134. Find and Replace help
  135. Problem with too many identical loops
  136. VBA code to close html confirm window.
  137. Need VBA code to click HTML image button.
  138. How to compare (neighbor) cells within a range object?
  139. How to get the real character when ? is displayed
  140. Find my String in an Array?
  141. Solved: Go back to the cell where you started a macro
  142. VBA Coding extension
  143. Solved: Assistance Modifying Array
  144. Restricting data entry in a table, one row at a time
  145. Macro to Copy from one Workbook to Another
  146. grouping function
  147. Is it possible to use formulas instead of pivot tables to call data from a worksheet?
  148. Solved: underline non duplicated values from 2 columns
  149. Variables Holding Wrong Data
  150. Random NUMBER
  151. Auto Adjust Range on a graph? Help
  152. Solved: Insert columns based on a variable
  153. Solved: macro doesn't work
  154. Solved: Copy Worksheet to new Workbook
  155. Copy each advance filtered data (filter by date 1 to 31) to new sheet
  156. How to change the words size in Excel/VBA Help Window, not in Excel window?
  157. How to read values from a dynamic form with dynamic text box names?
  158. Solved: Code Running Sequentially
  159. How do you incorporate vba code for excel into vba code for access 2010?
  160. Solved: VBA to count number of Cells with Data and write to a text File
  161. call web service via https
  162. Set Print Area conditional
  163. Error: Method or data member not found
  164. Solved: Looping based on a condition
  165. Solved: to rename and create new folder..
  166. Filling down a formula
  167. Solved: covert text to date
  168. Excel VBA/Formula Selective Count
  169. Delete visible sheets except sheet1
  170. Looping through and finding average of data
  171. Solved: Combine coloured sheets from files
  172. Function LEFT / RIGHT
  173. Change cell rule from list to ranged cell automatically
  174. VBA to cut & paste
  175. Solved: Add new record of data to existing worksheet
  176. Solved: cell activate
  177. Mac EXCEL 2011 VBA
  178. Selecting items in already existing Combo Boxes (Drop down list)
  179. Sort Before Graphing
  180. Solved: Finding a string in Excel
  181. Import file to update
  182. control internet explorer popup window from excel
  183. Solved: Create a .txt file from a range of selected cells
  184. Solved: Listbox Index - Number format
  185. Solved: How to make an existing VBA Macro Globally Accessible or Public
  186. VBA to Email Range in body and attach sheets concurrently
  187. Adding Macros te Template
  188. Single value criterion
  189. Google Maps Driving Times - Stopped working
  190. Solved: Summing a dynamic range
  191. Solved: copy from excel to word
  192. macros
  193. Solved: Limiting scroll area is preventing me from clicking any row buttons
  194. Counting number
  195. Extract data in filter format from CSV file
  196. Solved: Problem with Email attachment
  197. IE Temp & memory or what??
  198. Inserting an event procedure
  199. How can I find character with ASCII code 160 in a string using VBA ?
  200. Disable commandbars in Excel 2007 - through VBA
  201. Un-protect sheet for specific user
  202. Send email with data depending on active cell...
  203. Delete Multiple cols in Excel VBA
  204. Simple question
  205. Lookup text if match found, paste it into the next cell
  206. Need to Import Data from Multiple Sheets into a Master Sheet
  207. Solved: Copy Next Column of Data
  208. Solved: How to refer to a cell in VBA
  209. copy and paste data to certain cells
  210. Assign value to read-only object
  211. Solved: VBA formula referencing cell in different worksheet
  212. disable OnTime macro before close file
  213. Extract data from website in an Excel Spreadsheet
  214. search
  215. Run-time error '1004': Copy Method of Worksheet Class failed
  216. [Excel2k3+VBA] Importing spreadsheet specs from Access Tables and Render
  217. Solved: setup page from excel to word
  218. Table View In user form..
  219. auto hide empty rows within a software program
  220. Solved: Macro doesnt work with buttons
  221. CONDITIONAL FORMATTING CHALLENGE Change numbers to RED
  222. Solved: Need to Replace incorrectly spelled names, based on a list of before and after.
  223. Solved: sum(if..) until ..
  224. Comparing the values in two columns and highlight the values missing
  225. Need ideas on how to approach name entry validation.
  226. Solved: Worksheet formula in VBA
  227. Randomize blocks of range by column
  228. Solved: Using IF statement and Select Case statement
  229. Get Data From Closed Workbooks
  230. Get the Windows Login and Logout times
  231. Get the Count of Unique Values in a Column
  232. Retrieve the values
  233. Excel Cell Value Email
  234. Solved: Create a Text File
  235. My simple macro causes my excel to freeze up
  236. Solved: auto save in excel
  237. Imposing Fine
  238. Solved: Copy files runtime error 70 when trying to copy
  239. Solved: Variable .txt file import, Please help!
  240. Solved: Code Not Running after Adding If Statement
  241. Solved: Find column value in multiple sheet and copy Row to Summary
  242. Can vba do the printer setting?
  243. Solved: Why does creating activex button on sheet interfere with value stored in PrevCol var
  244. Solved: January to December based on Year
  245. Solved: #DIV/0! ERROR
  246. Copy Selected Filter and Paste to other sheet with different format
  247. creating a chart from a userform
  248. Solved: Validating columns using Formula or Select Case ?
  249. SQL Query in VBA without using the Access database of OLEDB connection
  250. Solved: output subtotals only to new sheet