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