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. Problems with foreach loop in a modul
  2. Solved: finding MAX number and matching symbol
  3. Solved: xlCellType
  4. Solved: Userform & Class Module Interaction
  5. Solved: ActiveCell.FormulaR1C1 dynamic column
  6. Solved: Reading a .csv File?
  7. Help With automatically reading a column
  8. Sum months plus today
  9. Solved: how does xlMultiply work? and can i paste and multipy in one go?
  10. Delete named Sheets if they exist
  11. Solved: Listening to the active sheet's events from the personal macro
  12. Download from Excel via URLDownloadToFile
  13. Excel 2007 Macro Recorded
  14. Solved: Intersect
  15. Formulas
  16. Playing with arrays... sort of
  17. Conditional locking of row
  18. VBA Error help please
  19. VBA to copy 3 worksheets and email
  20. Excel to Word... little help required
  21. Solved: Macro Recorder Code fails
  22. Can this code be simplified
  23. Solved: Using a Date variable in Excel 2007 macro
  24. Excel Macro Help
  25. Selection
  26. Solved: Clear cell contents without deleting formula
  27. Solved: multiple file selection
  28. VBA for multiple excel file
  29. Extract a list of employees according to month
  30. Solved: Probably a quick solution to this! - finding rows
  31. Solved: Delimiting in odd situations...
  32. Solved: Excel VBA
  33. Write a value from a cell formula
  34. Solved: Why is this code simply exiting without reason?
  35. Use of Ajax in an inputbox?
  36. Solved: Hide unhide rows in range
  37. Set StartCell as ActiveCell
  38. Solved: Formula to allocate absolute values
  39. Solved: How to export bookmarks from word to excel
  40. VBA Code Problems with Sending Excel DB through Outlook
  41. Sorting While in .FilterMode
  42. adding up interchanging word in a single cell
  43. Split The Column Data based on first column values using VBA
  44. [SOLVED:] How do you clear filter in macro?
  45. Solved: XY chart with values on top of each other
  46. [SLEEPER:] Use combobox as history
  47. vba MultiSelect ListBox based on advanced filter
  48. Divide the Column Data using VBA
  49. Solved: Change cell colour if changes made
  50. Multi Select List Box based on Advanced Filter
  51. Solved: Add 1 when copying and linking.
  52. Solved: Error Handling
  53. Help with Syntax Using ADO to Query Excel Worksheet
  54. Solved: Football Team Record Ranking
  55. Solved: Detecting Conditional Formatting
  56. Solved: Removing certain string
  57. Solved: Date as an Index
  58. Executing Macro at Time with Excel Closed
  59. Search Function in a User Form
  60. Solved: Selecting a Range of Rows
  61. Solved: using name in VBA propertys vs Sheet name
  62. Solved: How to create Yes or No Message Box?
  63. [SOLVED:] Extract a string from a cell
  64. Is this a timeout issue?
  65. Grabbing Data..Excel VBA
  66. Solved: VLOOKUP the Nth Occurance
  67. Solved: Use Vlookup in VBA Code
  68. Excel 2007 macro for comparing multiple dates
  69. Solved: could not set the value property. Invalid property value
  70. Combo Box / List box help
  71. Stop dialog box popping up
  72. Solved: Hlookup and Vlookup problem
  73. Solved: Filter from Drop Down Box
  74. how to change multiple value instead of one value at a time?
  75. VBA Code to know the date of creating a new worksheet
  76. lookup function in VBA
  77. Solved: Events
  78. Need macro to list folder with name and size in excel. Thanks
  79. User form will not allow blank fields
  80. Solved: index/match
  81. Copy & Paste Dates with Macro
  82. Solved: Worksheet Change Event
  83. [SOLVED:] Uncheck CheckBoxes if one is checked
  84. Tool or editor require for understanding return value of each argument of so many nes
  85. Month selection
  86. Set trial period for use of your project
  87. ِAccepting new repeated entries or not
  88. Solved: Avoiding errors in formulas
  89. Problem: ClassFactory cannot supply requested class
  90. Confused About Run-time error '1004': Application-defined or object-defined error
  91. Capturing UNDO Stack
  92. con.open error message data source name not found no default driver specified
  93. coloring similar cells in values in the same column
  94. Create school timetable by vba
  95. Copy contents from various excel files in a folder and merge
  96. Sum of Cells Within the Selected Range (vba)
  97. Solved: 1004 error
  98. Open and copy/paste data to same row...
  99. Solved: SUM(IF with an OR statement produces incorrect results.
  100. Solved: auto run the macro
  101. Solved: VLOOKUP Question
  102. Solved: Count an array of data based on Sum
  103. Solved: Putting a slash between numbers and text
  104. Copy row to the duplicate row - Macro
  105. Exchange (part of) file name with a cell ref in Vlookup formula?
  106. combobox generate another combobox
  107. Solved: Changing default weekday
  108. Solved: vba vlookup fix
  109. Bookmark Runtime Errors, 5941 and 462
  110. How to compare two same files
  111. combobox generate another combobox
  112. Charting Scenarios
  113. Dynamically creating variables...possible?
  114. Find and Replace Dynamic values
  115. VBA help: need to transfer 130 cells to memory and back
  116. Printing specific records
  117. how do we access a variable declared in one form to another form
  118. Adding a blank string in between
  119. Worksheet event code to copy Formula
  120. Solved: Unmerge target cell
  121. Solved: converting multi-dimension array to single-dimension
  122. How to import XML to excel without the HTML, I think?
  123. Solved: Write to Word from Excel
  124. Solved: Sum an array of data when records are > $xxx
  125. Range References in VBA when Wks Rows/Columns Deleted
  126. Solved: Run-time Error 70 creating application object in Windows 7
  127. transpose macro
  128. Pivot Table
  129. Copy specific multiple groups of sheets to new workbooks
  130. Solved: find first item in column
  131. align input data
  132. Random Sampler Macro
  133. Finding the min or max value in a sub range of a reference.
  134. Solved: SEARCH COLUMN FOR VALUE AND COPY ROW
  135. [SOLVED:] Macro to find specified date in a range
  136. How to delete external links excel 2007
  137. Solved: Deleting duplicate data
  138. Defining an array as a range of cells
  139. hyperlink
  140. Solved: Error Setting Selection.Formula in a ListColumn
  141. Solved: extend the border line until desired row
  142. Control on Combobox
  143. Solved: represent column by variable
  144. Problem with UDF Function
  145. Run time error '6'
  146. Update links between workbooks
  147. Find row based on picture
  148. Classes
  149. Need help replacing For Next Loop with AutoFilter
  150. VBA OOp
  151. Assort information in columns from rows
  152. Solved: Deleting Defined Names
  153. Install a new font in Excel
  154. mail item problem
  155. Force enabling macro
  156. Solved: Separating between each two digits
  157. Wierd Calculation Issue - VBA- Excel (2007)
  158. DTPicker
  159. Changing dates in a cell
  160. Solved: Copy 2 cells with formula.
  161. [SOLVED:] Saving a chart to .pdf
  162. Solved: is there any way i can change the WB created date
  163. add item to a listbox
  164. Solved: Total distance and time between two cities in a state
  165. vblf's peculiarities
  166. using vba to copy and paste from a website
  167. Solved: copying value set to variable
  168. Solved: Defining a variable number of arrays?
  169. How to highlight conditional formatting
  170. Listen to double click
  171. Save file as TXT or CSV
  172. Create New tab
  173. Greate ChartLines & Show SeriesPoint(i)Values?
  174. Formula help
  175. how to stop at the last row
  176. Unviewable projects
  177. [SOLVED:] Sending Excel range to Access; question...
  178. random
  179. Add 1250 textboxes in excel using vba vb6
  180. Get entire worksheet range
  181. Copying a row in Excel using VBA
  182. Solved: Creating a number of workbooks
  183. Solved: Compare Column Data
  184. Transparent Command Button Covers Text
  185. Working with Cell Comments
  186. Solved: Horizontal Sorting
  187. Array Formula
  188. VBA Application to print multiple, user selected files
  189. VBA Function Help
  190. Set Chart Height and Width to Match Page Dimensions
  191. Spedometer Type Chart (Donut) - Help with Formula
  192. Solved: Add from Month of April Onward
  193. Set Properties for Printing
  194. [SOLVED:] Run a macro at a specific time and day
  195. Formulas help
  196. Messy alignment when copying to Power Point
  197. Unique items in ListBox
  198. Solved: correction
  199. Solved: Producing Error
  200. Sleeper: Compare one workbook with multiple workbooks
  201. Solved: data from txt to existing sheet (only fix my code)
  202. [SOLVED:] Select Case
  203. Excel 2007 error with code for creating passwords
  204. Excel Date Problem (XLD!!!)
  205. I expect this is fairly simple...
  206. Automatic Sort On double Click
  207. 2D arrays
  208. Ribbon Object in xl2007 vs CommandBar Object in xl2003
  209. Creating a UserForm Programatically, with Frame
  210. Excel 2007 Unlocking Specific Cells Based on Password
  211. combox transfers data
  212. [SOLVED:] Replace carriage return and line feed in excel
  213. Solved: Checkboxes form Form Controls
  214. Need help with some VBA - Probably very simple
  215. Solved: zoom sheet on background
  216. Microsoft listview control 6.0 (SP4) problem
  217. Solved: How to raise/lower the Windows Taskbar with code
  218. Conditionally hide and unhide cell ranges
  219. Solved: Dynamically determine week number and filter
  220. Excell 2007 - select all/copy
  221. What Are the Black Dots For On Excel Worksheet?
  222. Solved: Importing Data from Multiple Worksheets
  223. Filter Fails to Work - Incorrect Format?
  224. copying chart from one workbook to another using VB
  225. Need help with combobox
  226. Solved: Copying data from excel to word
  227. VBA Code to Delete Rows with AWR
  228. [SOLVED:] Detect changes to VBA code.
  229. UDF Function to refer to the Sheet Name
  230. Write this formula in a shorter way
  231. Reference to different VBAProject
  232. Excel VBA for multiple email on button
  233. VBA: Go Down Page & Add Seperator Lines
  234. Need help with word to excel function
  235. filtering cells based on data in listbox
  236. Data Validation List with no empty cells
  237. Limit cell to numeric values only
  238. Training Educational DVDs for VBA on excel
  239. VBA Dynamically Saving in a Folder Structure
  240. how to search all w sh in WB
  241. Solved: Application or object defined error
  242. VBA Code if a user input in an inputbox causes error in a running macro
  243. VBA Not working in Office XP
  244. Export Excel data to Access table thru TransferSpreadsheet
  245. Solved: Count cells except empty cells
  246. Help using VBA
  247. Referring to the first and last cell of a range
  248. Solved: Cut and Paste Problem
  249. Excel VBA error method 'minimumscaleisauto' of object 'axes' failed
  250. How to search and modify existing record