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