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