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